DBA Data[Home] [Help]

APPS.JA_CN_AP_PBD_EXPORT_PKG dependencies on AP_INVOICES_PKG

Line 2467: select AP_INVOICES_PKG.GET_APPROVAL_STATUS(ai.invoice_id,

2463: loop
2464:
2465: if l_void_date is not null and l_void_date =l_invoice.accounting_date then
2466:
2467: select AP_INVOICES_PKG.GET_APPROVAL_STATUS(ai.invoice_id,
2468: ai.invoice_amount,
2469: ai.payment_status_flag,
2470: ai.invoice_type_lookup_code) into l_invoice_status
2471: from ap_invoices_all ai

Line 2544: select AP_INVOICES_PKG.GET_APPROVAL_STATUS(ai.invoice_id,

2540: '.begin',
2541: 'Enter procedure');
2542: END IF; --ln_proc_level>=ln_dbg_level
2543: if pv_period_from<>pv_period_to then
2544: select AP_INVOICES_PKG.GET_APPROVAL_STATUS(ai.invoice_id,
2545: ai.invoice_amount,
2546: ai.payment_status_flag,
2547: ai.invoice_type_lookup_code)
2548: into l_invoice_status