APPS.PO_PDOI_HEADER_PROCESS_PVT dependencies on PO_VENDOR_SITES

Line 3316: FROM po_vendor_sites

3312: SELECT p_key,
3313: p_index_tbl(i),
3314: min(vendor_site_id),
3315: vendor_id
3316: FROM po_vendor_sites
3317: WHERE p_vendor_id_tbl(i) IS NOT NULL
3318: AND x_vendor_site_id_tbl(i) IS NULL
3319: AND vendor_id = p_vendor_id_tbl(i)
3320: AND purchasing_site_flag = 'Y'

Line 3365: FROM po_vendor_sites_all

3361: Decode(pay_on_code, --Bug 13461573
3362: 'RECEIPT','RECEIPT',
3363: 'RECEIPT_AND_USE','RECEIPT',
3364: NULL ) pay_on_code
3365: FROM po_vendor_sites_all
3366: WHERE vendor_site_id = x_vendor_site_id_tbl(i);
3367:
3368: d_position := 40;
3369: