DBA Data[Home] [Help]

APPS.AR_DEP_BAL_RPT_PKG dependencies on HZ_CUST_ACCOUNTS

Line 145: FROM hz_cust_accounts HCA

141: BEGIN
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

Line 169: ,hz_cust_accounts HCA

165: INTO ln_invoice_bal
166: FROM ra_customer_trx RCT
167: ,ra_cust_trx_line_gl_dist_all RCTD
168: ,ra_cust_trx_types_all RCTT
169: ,hz_cust_accounts HCA
170: ,hz_parties HZP
171: ,gl_code_combinations GCC
172: ,ar_adjustments_all ARA
173: ,ar_distributions_all ARD