APPS.INL_SHIPMENT_PVT dependencies on HZ_PARTY_SITES

Line 2766: FROM hz_party_sites hps,

2762: p_var_value => p_third_parties_allowed);
2763: BEGIN
2764: SELECT hps.party_site_id
2765: INTO l_party_site_id
2766: FROM hz_party_sites hps,
2767: hz_locations hl
2768: WHERE hps.location_id = hl.location_id
2769: AND hps.party_site_id = p_party_site_id
2770: AND ((p_third_parties_allowed = 1

Line 2894: hz_party_sites hps

2890: po_headers_all ph,
2891: po_line_locations_all pll,
2892: po_vendors pv,
2893: po_vendor_sites_all pvs,
2894: hz_party_sites hps
2895: WHERE
2896: ph.po_header_id = pll.po_header_id
2897: AND hps.party_site_id = pvs.party_site_id
2898: AND pll.line_location_id = sl.ship_line_source_id

Line 2927: hz_party_sites hps

2923: po_headers_all ph,
2924: po_line_locations_all pll,
2925: po_vendors pv,
2926: po_vendor_sites_all pvs,
2927: hz_party_sites hps
2928: WHERE
2929: ph.po_header_id = pll.po_header_id
2930: AND hps.party_site_id = pvs.party_site_id
2931: AND pll.line_location_id = sl.ship_line_source_id

Line 3933: hz_party_sites hps

3929: CURSOR c_ln_group IS
3930: SELECT ship_line_group_num, ship_line_group_id, lg.party_id, lg.party_site_id,
3931: lg.ship_line_group_reference, hps.party_site_name
3932: FROM inl_ship_line_groups lg,
3933: hz_party_sites hps
3934: WHERE hps.party_site_id = lg.party_site_id
3935: AND ship_header_id = p_ship_header_id
3936: ORDER BY ship_line_group_num;
3937: BEGIN