DBA Data[Home] [Help]

APPS.AR_DEP_BAL_RPT_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 146: ,ra_customer_trx_lines RCTL

142: BEGIN /*Query to find the Balances for the given Customer Trx Id */
143: SELECT NVL(RCTL.extended_amount,0)
144: INTO ln_commitment_bal
145: FROM hz_cust_accounts HCA
146: ,ra_customer_trx_lines RCTL
147: ,ra_customer_trx RCT
148: ,ra_cust_trx_types RCTT
149: WHERE RCT.customer_trx_id = p_customer_trx_id
150: AND RCT.cust_trx_type_id = RCTT.cust_trx_type_id