APPS.JL_BR_AP_PAY_SCHED_GDF_PKG dependencies on AP_INVOICES

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 310: FROM ap_invoices

306: -- Select the Vendor Site ID, Invoice Type and Global_Attr1 from the invoice.
307: ----------------------------------------------------------------------------
308: SELECT vendor_site_id, invoice_type_lookup_code, substr(global_attribute1,1,1)
309: INTO v_vndstid, l_invoice_type_lookup_code, s_colldoc_assoc
310: FROM ap_invoices
311: WHERE invoice_id = P_Invoice_ID;
312: ------------------------------------------------------------------------------------------
313: -- First fill the AP_Payment_Schedules GDF
314: ------------------------------------------------------------------------------------------

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;

Line 600: AND ap.global_attribute_category = 'JL.BR.APXINWKB.AP_INVOICES'

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;
602: BEGIN
603: P_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
604: For db_reg in ap_inv Loop