DBA Data[Home] [Help]

APPS.ARP_PROCESS_RCTS dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 965: ra_cust_trx_line_gl_dist rctlg

961:
962: SELECT COUNT(payment_schedule_id)
963: INTO l_dummy
964: FROM ar_payment_schedules ps,
965: ra_cust_trx_line_gl_dist rctlg
966: WHERE ps.associated_cash_receipt_id = p_cr_id
967: AND ps.class = 'CB'
968: AND ps.customer_trx_id = rctlg.customer_trx_id
969: AND ( nvl(ps.amount_applied, 0) <> 0

Line 1072: ra_cust_trx_line_gl_dist dm_gld

1068: p_debit_memo_number,
1069: p_debit_memo_doc_number
1070: from ra_cust_trx_types ctt_dm,
1071: ra_customer_trx ct_dm,
1072: ra_cust_trx_line_gl_dist dm_gld
1073: where ct_dm.reversed_cash_receipt_id = p_cr_id
1074: and ct_dm.cust_trx_type_id = ctt_dm.cust_trx_type_id
1075: and ct_dm.customer_trx_id = dm_gld.customer_trx_id
1076: and dm_gld.account_class = 'REC'