APPS.GHG_TRANSACTIONS_API_PKG dependencies on PO_VENDOR_SITES

Line 98: FROM po_vendor_sites

94: FROM po_vendors pv
95: WHERE pv.enabled_flag = 'Y'
96: AND pv.vendor_id = nvl(p_supplier_id, -1)
97: AND EXISTS (SELECT 1
98: FROM po_vendor_sites
99: WHERE vendor_id = pv.vendor_id
100: AND TRUNC(NVL(inactive_date, sysdate + 1)) > TRUNC(sysdate)
101: AND pay_site_flag = 'Y');
102:

Line 114: FROM po_vendor_sites

110: -- Check Input Supplier Site ID
111: x_debug('Check Input Supplier Site ID');
112: SELECT COUNT(*)
113: INTO v_row_count
114: FROM po_vendor_sites
115: WHERE vendor_id = nvl(p_supplier_id, -1)
116: AND vendor_site_id = nvl(p_supplier_site_id, -1)
117: AND TRUNC(NVL(inactive_date, sysdate + 1)) > TRUNC(sysdate)
118: AND pay_site_flag = 'Y';