DBA Data[Home] [Help]

APPS.ARP_CREDIT_MEMO_MODULE dependencies on RA_INTERFACE_LINES

Line 5328: FROM ra_interface_lines int

5324: and substr(rl.type, 1,1) = 'P';
5325:
5326: CURSOR c2 IS
5327: SELECT int.previous_customer_trx_id
5328: FROM ra_interface_lines int
5329: WHERE int.request_id = p_request_id
5330: AND int.previous_customer_trx_id IS NOT NULL
5331: AND NOT EXISTS (SELECT 1
5332: FROM ra_cust_trx_line_gl_dist ctlgd

Line 5434: FROM ra_interface_lines int,

5430: int.interface_line_id,
5431: ps.selected_for_receipt_batch_id,
5432: int.cust_trx_type_id,
5433: int.amount
5434: FROM ra_interface_lines int,
5435: ar_payment_schedules ps
5436: WHERE int.request_id = p_request_id
5437: AND int.previous_customer_trx_id IS NOT NULL
5438: AND int.previous_customer_trx_id = ps.customer_trx_id ;