APPS.POS_ASN_XML dependencies on HZ_PARTY_SITES

Line 457: hz_party_sites party,

453: SELECT count(*)
454: INTO l_loc_count
455: FROM
456: hz_locations loc,
457: hz_party_sites party,
458: hz_cust_acct_sites_all cust
459: WHERE
460: cust.ece_tp_location_code = p_ship_to_partner_id
461: and cust.org_id = p_org_id

Line 474: hz_party_sites party,

470: SELECT min(loc.location_id)
471: INTO p_ship_to_location_id
472: FROM
473: hz_locations loc,
474: hz_party_sites party,
475: hz_cust_acct_sites_all cust
476: WHERE
477: cust.ece_tp_location_code = p_ship_to_partner_id
478: and cust.org_id = p_org_id