DBA Data[Home] [Help]

APPS.AP_PARTYMERGE_GRP dependencies on AP_INVOICES_ALL

Line 105: FROM ap_invoices_all ai,

101: -- this because 3.1.2.1 of veto rules HLD
102:
103: SELECT COUNT(*)
104: INTO l_unpaid_invoices
105: FROM ap_invoices_all ai,
106: ap_supplier_sites_all pav
107: WHERE ai.vendor_site_id = pav.vendor_site_id
108: AND pav.party_site_id = p_from_fk_id
109: AND nvl(ai.payment_status_flag,'N') <> 'Y';

Line 381: FROM ap_invoices_all ai,

377: -- of the tables ai, pov, pvs, sql will return zero i.e. go ahead
378:
379: SELECT COUNT(*)
380: INTO l_unpaid_invoices
381: FROM ap_invoices_all ai,
382: ap_suppliers pov,
383: ap_supplier_sites_all pvs
384: WHERE ai.vendor_site_id = pvs.vendor_site_id
385: AND pvs.vendor_id = pov.vendor_id