APPS.POS_ASN_XML dependencies on HZ_PARTY_SITES

Line 436: hz_party_sites party,

432: SELECT count(*)
433: INTO l_loc_count
434: FROM
435: hz_locations loc,
436: hz_party_sites party,
437: hz_cust_acct_sites_all cust
438: WHERE
439: cust.ece_tp_location_code = p_ship_to_partner_id
440: and cust.org_id = p_org_id

Line 453: hz_party_sites party,

449: SELECT min(loc.location_id)
450: INTO p_ship_to_location_id
451: FROM
452: hz_locations loc,
453: hz_party_sites party,
454: hz_cust_acct_sites_all cust
455: WHERE
456: cust.ece_tp_location_code = p_ship_to_partner_id
457: and cust.org_id = p_org_id