APPS.JL_BR_AP_PAY_SCHED_GDF_PKG dependencies on AP_INVOICES_ALL

Line 299: ( P_Invoice_Id ap_invoices_all.invoice_id%TYPE

295: --
296: --
297:
298: PROCEDURE Suppl_Def_Pay_Sched_GDF
299: ( P_Invoice_Id ap_invoices_all.invoice_id%TYPE
300: ) IS
301: l_invoice_type_lookup_code varchar2(25);
302: s_colldoc_assoc varchar2(1);
303: v_vndstid number;

Line 473: from ap_invoices_all int,

469: IF (l_process_type = 'IMMEDIATE') THEN
470:
471: select sum(nvl(int.invoice_amount,0))
472: into int_amt
473: from ap_invoices_all int,
474: ap_invoice_relationships rel,
475: iby_docs_payable_all iby
476: where rel.original_invoice_id = iby.calling_app_doc_unique_ref2 -- ap.invoice_id
477: and rel.original_payment_num = iby.calling_app_doc_unique_ref3 -- ap.payment_num

Line 597: FROM ap_invoices_all ap,

593: RETURN Number
594: IS
595: Cursor ap_inv IS
596: SELECT 1 br_c
597: FROM ap_invoices_all ap,
598: iby_docs_payable_all iby
599: WHERE ap.invoice_id = iby.calling_app_doc_unique_ref2
600: AND ap.global_attribute_category = 'JL.BR.APXINWKB.AP_INVOICES'
601: AND iby.document_payable_id = P_Doc_Payable_ID;