DBA Data[Home] [Help]

APPS.JG_ZZ_AERL_DT_PKG dependencies on AP_INVOICES

Line 18: ,ap_invoices api

14: cursor c_get_ap_batch_name
15: is
16: select apb.batch_name
17: from ap_batches apb
18: ,ap_invoices api
19: where apb.batch_id = api.batch_id
20: and api.invoice_id = trx_id;
21:
22: cursor c_get_gl_batch_name

Line 65: from ap_invoices_all

61: begin
62: if pv_source = 'AP' then
63: select invoice_type_lookup_code
64: into lv_fin_doc_type
65: from ap_invoices_all
66: where invoice_id = pn_trx_id;
67: elsif pv_source = 'AR' then
68: if pv_entity_code = 'RECEIPTS' then
69: select sl.trx_type into lv_sl_trx_type