APPS.AP_APPROVAL_PKG dependencies on AP_SUPPLIERS

Line 785: ap_suppliers PV,

781: nvl(AI.net_of_retainage_flag,'N'), --9356460
782: nvl(pvs.tolerance_id,ASP.tolerance_id), --added nvl for bug 8425996
783: nvl(pvs.services_tolerance_id,ASP.services_tolerance_id) --added nvl for bug 8425996
784: FROM ap_invoices_all AI,
785: ap_suppliers PV,
786: ap_supplier_sites_all PVS,
787: ap_system_parameters_all ASP --added table for bug 8425996
788: WHERE AI.invoice_id = p_invoice_id
789: AND AI.vendor_id = PV.vendor_id

Line 12494: TYPE VendorIdTab IS TABLE OF ap_suppliers.vendor_id%TYPE INDEX BY BINARY_INTEGER;

12490: l_current_calling_sequence VARCHAR2(2000);
12491: l_debug_info VARCHAR2(1000);
12492:
12493:
12494: TYPE VendorIdTab IS TABLE OF ap_suppliers.vendor_id%TYPE INDEX BY BINARY_INTEGER;
12495: l_vendor_id_list VendorIdTab;
12496:
12497: --cursor fetches vendors information
12498: CURSOR vndr_list_to_process IS

Line 12501: AP_SUPPLIERS APS

12497: --cursor fetches vendors information
12498: CURSOR vndr_list_to_process IS
12499: select APS.vendor_id
12500: from IBY_EXT_PAYEE_RELATIONSHIPS IEPR,
12501: AP_SUPPLIERS APS
12502: where IEPR.remit_party_id in (select party_id from ap_suppliers
12503: where vendor_id = p_vendor_id)
12504: and IEPR.party_id = APS.party_id
12505: UNION

Line 12502: where IEPR.remit_party_id in (select party_id from ap_suppliers

12498: CURSOR vndr_list_to_process IS
12499: select APS.vendor_id
12500: from IBY_EXT_PAYEE_RELATIONSHIPS IEPR,
12501: AP_SUPPLIERS APS
12502: where IEPR.remit_party_id in (select party_id from ap_suppliers
12503: where vendor_id = p_vendor_id)
12504: and IEPR.party_id = APS.party_id
12505: UNION
12506: select APS.vendor_id

Line 12507: from AP_SUPPLIERS APS

12503: where vendor_id = p_vendor_id)
12504: and IEPR.party_id = APS.party_id
12505: UNION
12506: select APS.vendor_id
12507: from AP_SUPPLIERS APS
12508: where APS.vendor_id = p_vendor_id;
12509:
12510: Begin
12511: