DBA Data[Home] [Help]

APPS.AR_DEP_BAL_RPT_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 147: ,ra_customer_trx_lines RCTL

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