DBA Data[Home] [Help]

APPS.JAI_BOE_MIGRATION_PKG dependencies on AP_INVOICES

Line 246: FROM AP_INVOICES

242: ) IS
243:
244: CURSOR boe_invoice_cur(pn_invoice_num IN VARCHAR2) IS
245: SELECT PAYMENT_STATUS_FLAG
246: FROM AP_INVOICES
247: WHERE INVOICE_NUM = pn_invoice_num;
248:
249: boe_invoice_payment_status AP_INVOICES.PAYMENT_STATUS_FLAG%TYPE;
250: boe_status jai_cmn_boe_hdrs.status%TYPE;

Line 249: boe_invoice_payment_status AP_INVOICES.PAYMENT_STATUS_FLAG%TYPE;

245: SELECT PAYMENT_STATUS_FLAG
246: FROM AP_INVOICES
247: WHERE INVOICE_NUM = pn_invoice_num;
248:
249: boe_invoice_payment_status AP_INVOICES.PAYMENT_STATUS_FLAG%TYPE;
250: boe_status jai_cmn_boe_hdrs.status%TYPE;
251:
252: BEGIN
253: Fnd_File.put_line(Fnd_File.LOG,' **Start update_boe_hdr for boe_id:' || pn_boe_id ||' invoice num:' || pv_invoice_num ||'applied amount:' || pn_amount_applied || ' **');