DBA Data[Home] [Help]

APPS.PN_LEASE_UTILS dependencies on PO_VENDOR_SITES_ALL

Line 2217: FROM po_vendor_sites_all

2213:
2214: CURSOR c_vendor_site
2215: IS
2216: SELECT vendor_site_id
2217: FROM po_vendor_sites_all
2218: WHERE vendor_id = p_vendor_id
2219: AND pay_site_flag = 'Y'
2220: AND TRUNC (SYSDATE) <= NVL (inactive_date, SYSDATE)
2221: AND org_id = p_org_id

Line 2227: FROM po_vendor_sites_all

2223:
2224: CURSOR c_vendor_site_id
2225: IS
2226: SELECT vendor_site_id
2227: FROM po_vendor_sites_all
2228: WHERE vendor_id = p_vendor_id
2229: AND pay_site_flag = 'Y'
2230: AND TRUNC (SYSDATE) <= NVL (inactive_date, SYSDATE)
2231: AND org_id = p_org_id