APPS.AR_CONFIRMATION_ACTION dependencies on AR_DOCUMENT_TRANSFERS

Line 10: select * from ar_document_transfers

6: p_msgid in VARCHAR2,
7: p_exception_message in varchar2 default null,
8: p_exception_type in varchar2 default null) is
9: cursor doc is
10: select * from ar_document_transfers
11: where document_transfer_id = p_doc_transfer_id;
12: doc_rec ar_document_transfers%rowtype;
13:
14: begin

Line 12: doc_rec ar_document_transfers%rowtype;

8: p_exception_type in varchar2 default null) is
9: cursor doc is
10: select * from ar_document_transfers
11: where document_transfer_id = p_doc_transfer_id;
12: doc_rec ar_document_transfers%rowtype;
13:
14: begin
15: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_CONFIRMATION_ACTION.update_status(+)'); end if;
16: open doc; fetch doc into doc_rec; close doc;

Line 43: from ar_document_transfers dt,

39: trx.trx_number,
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