APPS.POS_BULKLOAD_ENTITIES dependencies on HZ_PARTY_SITES

Line 228: HZ_PARTY_SITES PS

224:
225: CURSOR c_party_site (c_party_id IN NUMBER, c_address_name iN VARCHAR) IS
226: SELECT PS.Party_Site_ID
227: FROM AP_Suppliers AP,
228: HZ_PARTY_SITES PS
229: WHERE AP.Party_ID = PS.Party_ID
230: AND AP.Party_ID = c_Party_ID
231: AND PS.STATUS = 'A'
232: AND PS.PARTY_SITE_NAME = c_address_name

Line 239: HZ_PARTY_SITES PS

235: CURSOR c_supplier_site (c_party_id IN NUMBER, c_party_site_id IN NUMBER, c_vendor_site_code IN VARCHAR) IS
236: SELECT SS.Vendor_Site_ID
237: FROM AP_Suppliers AP,
238: AP_SUPPLIER_SITES_ALL SS,
239: HZ_PARTY_SITES PS
240: WHERE AP.Party_ID = PS.Party_ID
241: AND AP.Party_ID = c_Party_ID
242: AND PS.STATUS = 'A'
243: AND PS.Party_Site_ID = c_party_site_id

Line 351: HZ_PARTY_SITES PS

347:
348: CURSOR c_party_site (c_party_id IN NUMBER) IS
349: SELECT PS.Party_Site_ID
350: FROM AP_Suppliers AP,
351: HZ_PARTY_SITES PS
352: WHERE AP.Party_ID = PS.Party_ID
353: AND AP.Party_ID = p_Party_ID
354: AND PS.STATUS = 'A'
355: AND rownum < 2;

Line 362: HZ_PARTY_SITES PS

358: SELECT SS.Party_Site_ID,
359: SS.Vendor_Site_ID
360: FROM AP_Suppliers AP,
361: AP_SUPPLIER_SITES_ALL SS,
362: HZ_PARTY_SITES PS
363: WHERE AP.Party_ID = PS.Party_ID
364: AND AP.Party_ID = p_Party_ID
365: AND PS.STATUS = 'A'
366: AND PS.Party_Site_ID = SS.Party_Site_ID