DBA Data[Home] [Help]

APPS.PO_FED_FIELD_FUNCTIONS dependencies on AP_SUPPLIER_SITES_ALL

Line 2187: FROM AP_SUPPLIER_SITES_ALL

2183: l_state,
2184: l_province,
2185: l_country,
2186: l_zipcode
2187: FROM AP_SUPPLIER_SITES_ALL
2188: WHERE vendor_id = x_supplier_id
2189: AND vendor_site_id = x_supplier_site_id;
2190:
2191: d_progress := 20;

Line 2236: from AP_SUPPLIER_SITES_ALL

2232: l_state,
2233: l_province,
2234: l_country,
2235: l_zipcode
2236: from AP_SUPPLIER_SITES_ALL
2237: where pay_site_flag = 'Y'
2238: and vendor_id = x_supplier_id
2239: AND vendor_site_id = x_supplier_site_id;
2240:

Line 2547: from AP_SUPPLIER_SITES_ALL

2543: l_state,
2544: l_province,
2545: l_country,
2546: l_zipcode
2547: from AP_SUPPLIER_SITES_ALL
2548: where pay_site_flag = 'Y'
2549: and vendor_id = x_supplier_id
2550: AND VENDOR_SITE_ID = p_remit_to_addrs;
2551:

Line 2774: FROM AP_SUPPLIER_SITES_ALL

2770: l_state,
2771: l_province,
2772: l_country,
2773: l_zipcode
2774: FROM AP_SUPPLIER_SITES_ALL
2775: WHERE vendor_id = l_supplier_id
2776: AND vendor_site_id = l_supplier_site_id;
2777:
2778: BEGIN