DBA Data[Home] [Help]

APPS.ARP_PROCESS_RCTS dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 912: ra_cust_trx_line_gl_dist rctlg

908:
909: SELECT COUNT(payment_schedule_id)
910: INTO l_dummy
911: FROM ar_payment_schedules ps,
912: ra_cust_trx_line_gl_dist rctlg
913: WHERE ps.associated_cash_receipt_id = p_cr_id
914: AND ps.class = 'CB'
915: AND ps.customer_trx_id = rctlg.customer_trx_id
916: AND ( nvl(ps.amount_applied, 0) <> 0

Line 1019: ra_cust_trx_line_gl_dist dm_gld

1015: p_debit_memo_number,
1016: p_debit_memo_doc_number
1017: from ra_cust_trx_types ctt_dm,
1018: ra_customer_trx ct_dm,
1019: ra_cust_trx_line_gl_dist dm_gld
1020: where ct_dm.reversed_cash_receipt_id = p_cr_id
1021: and ct_dm.cust_trx_type_id = ctt_dm.cust_trx_type_id
1022: and ct_dm.customer_trx_id = dm_gld.customer_trx_id
1023: and dm_gld.account_class = 'REC'