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;
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:
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:
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