Can someone tell me what this statement is doing?
- From: "Good, John" <John.Good@xxxxxxxxxxxxxxxxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Fri, 20 Jun 2008 12:06:56 -0400
FOR l_rec_tax_txn_details IN it_cur_txns_t_tax_txns_dtls LOOP
l_rec_tax_txn_details is not a table name or a variable in the
procedure. I do not know what it is or where it is defined.
it_cur_txns_t_tax_txns_dtls is a cursor as defined below.
CURSOR it_cur_txns_t_tax_txns_dtls
IS
SELECT DISTINCT(IT_TBL_T_TAX_TXN_DETAILS.TRANSACTION_NO),
IT_TBL_T_TAX_TXN_DETAILS.ACCT_NO,
IT_TBL_T_TAX_TXN_DETAILS.TAX_TYPE,
IT_TBL_T_TAX_TXN_DETAILS.FORM_TYPE,
IT_TBL_T_TAX_TXN_DETAILS.TAX_YR,
IT_TBL_T_TAX_TXN_DETAILS.AMT_RCVD,
IT_TBL_T_TAX_TXN_DETAILS.CITY_AMT,
IT_TBL_T_TAX_TXN_DETAILS.SCHOOL_AMT,
(IT_TBL_T_TAX_TXN_DETAILS.CITY_LIABILITY_PAID +
IT_TBL_T_TAX_TXN_DETAILS.CITY_ESTIMATED_TAX_PAID) CITY_LIABILITY_PAID,
(IT_TBL_T_TAX_TXN_DETAILS.SCHOOL_LIABILITY_PAID +
IT_TBL_T_TAX_TXN_DETAILS.SCHOOL_ESTIMATED_TAX_PAID)
SCHOOL_LIABILITY_PAID,
(IT_TBL_T_TAX_TXN_DETAILS.CITY_INTEREST_PAID +
IT_TBL_T_TAX_TXN_DETAILS.CITY_ESTIMATED_INTEREST_PAID)
CITY_INTEREST_PAID,
(IT_TBL_T_TAX_TXN_DETAILS.SCHOOL_INTEREST_PAID +
IT_TBL_T_TAX_TXN_DETAILS.SCHOOL_ESTIMATED_INTEREST_PAID)
SCHOOL_INTEREST_PAID,
(IT_TBL_T_TAX_TXN_DETAILS.CITY_PENALTY_PAID +
IT_TBL_T_TAX_TXN_DETAILS.CITY_ESTIMATED_PENALTY_PAID) CITY_PENALTY_PAID,
(IT_TBL_T_TAX_TXN_DETAILS.SCHOOL_PENALTY_PAID +
IT_TBL_T_TAX_TXN_DETAILS.SCHOOL_ESTIMATED_PENALTY_PAID)
SCHOOL_PENALTY_PAID,
IT_TBL_T_TAX_TXN_DETAILS.CITY_ESTIMATED_P_I_PAID,
IT_TBL_T_TAX_TXN_DETAILS.SCHOOL_ESTIMATED_P_I_PAID,
SERVICE_CHARGE_PAID,
(IT_TBL_T_TAX_TXN_DETAILS.CITY_CREDIT -
IT_TBL_T_TAX_TXN_DETAILS.CURRENT_CITY_CREDIT)
CITY_CREDIT,
(IT_TBL_T_TAX_TXN_DETAILS.SCHOOL_CREDIT -
IT_TBL_T_TAX_TXN_DETAILS.CURRENT_SCHOOL_CREDIT)
SCHOOL_CREDIT,
IT_TBL_T_TAX_TXN_DETAILS.TYPE_OF_RETURN,
-- IT_TBL_T_TAX_TXN_DETAILS.TRANSACTION_NO,
IT_TBL_T_TAX_TXN_DETAILS.SEQUENCE_NO,
IT_TBL_T_CASH_TXNS.DATE_DRC,
IT_TBL_T_CASH_TXNS.CONTROLLERS_STATUS_FLAG
FROM IT_TBL_T_TAX_TXN_DETAILS,
IT_TBL_T_CASH_TXNS
WHERE IT_TBL_T_TAX_TXN_DETAILS.TRANSACTION_NO =
IT_TBL_T_CASH_TXNS.TRANSACTION_NO
AND ( IT_TBL_T_CASH_TXNS.STATUS_FLAG = 'P'
AND IT_TBL_T_CASH_TXNS.FORM_TYPE IN('BILL','BNBILL')
AND IT_TBL_T_CASH_TXNS.CONTROLLERS_STATUS_FLAG = 'T'
AND IT_TBL_T_CASH_TXNS.DATE_DRC IS NULL
AND IT_TBL_T_CASH_TXNS.DATE_DEPOSITED <= i_dt_report_date
--commented by Meenal BArve 27th JAn 2004 for eliminating previouly
posted transaction
--AND TRUNC(IT_TBL_T_TAX_TXN_DETAILS.DATE_POSTED) <= i_dt_report_date)
--commented upto this
AND TRUNC(IT_TBL_T_TAX_TXN_DETAILS.DATE_POSTED) = i_dt_report_date)
ORDER BY IT_TBL_T_TAX_TXN_DETAILS.TAX_TYPE;
Other related posts:
