DBA Data[Home] [Help]

APPS.IGS_FI_PRC_APINT dependencies on PO_VENDOR_SITES_ALL

Line 821: FROM po_vendor_sites_all po

817: AND TRUNC(SYSDATE) <= TRUNC(NVL(END_DATE_ACTIVE,sysdate));
818:
819: CURSOR c_vendor_sites(cp_vendor_site_id igs_fi_party_vendrs.vendor_site_id%TYPE) IS
820: SELECT 'x'
821: FROM po_vendor_sites_all po
822: WHERE ((po.org_id = g_n_org_id) OR (po.org_id IS NULL AND g_n_org_id IS NULL))
823: AND po.vendor_site_id = cp_vendor_site_id
824: AND TRUNC(SYSDATE) <= TRUNC(NVL(po.inactive_date, sysdate));
825: