APPS.AR_CONFIRMATION_ACTION dependencies on RA_CUSTOMER_TRX

Line 44: ra_customer_trx trx,

40: trx.trx_date,
41: trx.INVOICE_CURRENCY_CODE,
42: trxl.line_number
43: from ar_document_transfers dt,
44: ra_customer_trx trx,
45: ra_customer_trx_lines trxl
46: where dt.document_transfer_id = l_doc_transfer_id and
47: trx.customer_trx_id = l_trx_id and
48: trxl.customer_trx_line_id(+) = l_trx_line_id and

Line 45: ra_customer_trx_lines trxl

41: trx.INVOICE_CURRENCY_CODE,
42: trxl.line_number
43: from ar_document_transfers dt,
44: ra_customer_trx trx,
45: ra_customer_trx_lines trxl
46: where dt.document_transfer_id = l_doc_transfer_id and
47: trx.customer_trx_id = l_trx_id and
48: trxl.customer_trx_line_id(+) = l_trx_line_id and
49: dt.source_table = 'RA_CUSTOMER_TRX' and

Line 49: dt.source_table = 'RA_CUSTOMER_TRX' and

45: ra_customer_trx_lines trxl
46: where dt.document_transfer_id = l_doc_transfer_id and
47: trx.customer_trx_id = l_trx_id and
48: trxl.customer_trx_line_id(+) = l_trx_line_id and
49: dt.source_table = 'RA_CUSTOMER_TRX' and
50: dt.source_id = trx.customer_trx_id and
51: trx.customer_trx_id = trxl.customer_trx_id(+);
52: l_trx_rec trx%rowtype;
53: begin