APPS.AP_PO_GAPLESS_SBI_PKG dependencies on PO_VENDOR_SITES

Line 24: FROM PO_VENDOR_SITES

20: SELECT vendor_id,
21: org_id
22: INTO l_vendor_id,
23: l_org_id
24: FROM PO_VENDOR_SITES
25: WHERE selling_company_identifier = p_selling_co_id
26: AND rownum = 1;
27:
28: -- Checking for duplicates in AP_INVOICES_ALL table

Line 113: From PO_VENDOR_SITES_ALL

109: BEGIN
110:
111: Select default_pay_site_id
112: Into l_alt_site_id
113: From PO_VENDOR_SITES_ALL
114: Where vendor_site_id = p_site_id; --Bug 3628373
115:
116: If l_alt_site_id is Not Null THEN
117: l_source_site_id := l_alt_site_id;

Line 125: FROM PO_VENDOR_SITES_ALL

121: SELECT NVL(gapless_inv_num_flag, 'N'), /* Bug 5197828 */
122: selling_company_identifier
123: INTO x_gapless_inv_num_flag,
124: x_selling_company_id
125: FROM PO_VENDOR_SITES_ALL
126: WHERE vendor_site_id = l_source_site_id;
127:
128: /* Bug 5197828 */
129: --If l_gapless_inv_num is Not Null Then