APPS.EAM_ASSET_LOG_PVT dependencies on HZ_PARTY_SITES

Line 774: select Decode(nvl(ciih.OLD_LOCATION_TYPE_CODE,l_location_type_code) , 'HZ_PARTY_SITES', (SELECT hz.address1

770:
771:
772: --cpaturing the old Location Name
773:
774: select Decode(nvl(ciih.OLD_LOCATION_TYPE_CODE,l_location_type_code) , 'HZ_PARTY_SITES', (SELECT hz.address1
775: ||','
776: ||hz.address2
777: ||','
778: ||hz.address3

Line 792: hz_party_sites hps

788: ||','
789: ||hz.country
790: FROM
791: hz_locations hz,
792: hz_party_sites hps
793: WHERE
794: hz.location_id = hps.location_id
795: AND hps.party_site_id = ciih.old_location_id),
796: 'HZ_LOCATIONS', (SELECT hz.address1

Line 932: select Decode(nvl(ciih.NEW_LOCATION_TYPE_CODE,l_location_type_code) , 'HZ_PARTY_SITES', (SELECT hz.address1

928: WHERE instance_history_id = p_ref_id;
929:
930: --capturing the new location Name
931:
932: select Decode(nvl(ciih.NEW_LOCATION_TYPE_CODE,l_location_type_code) , 'HZ_PARTY_SITES', (SELECT hz.address1
933: ||','
934: ||hz.address2
935: ||','
936: ||hz.address3

Line 950: hz_party_sites hps

946: ||','
947: ||hz.country
948: FROM
949: hz_locations hz,
950: hz_party_sites hps
951: WHERE
952: hz.location_id = hps.location_id
953: AND hps.party_site_id = ciih.new_location_id),
954: 'HZ_LOCATIONS', (SELECT hz.address1