APPS.ECX_TP_API dependencies on HZ_LOCATIONS

Line 2143: select ADDRESS1 ||ADDRESS2 || ADDRESS3 || ADDRESS4 ||CITY ||POSTAL_CODE ||STATE ||PROVINCE || COUNTY||COUNTRY from hz_locations where location_id =(select location_id from hz_party_sites where party_id=v_party_id and party_site_id=v_party_site_id);

2139: cursor customer_party_name(v_party_id varchar) is
2140: select PARTY_NAME from hz_parties where party_id=v_party_id;
2141:
2142: cursor customer_site_name(v_party_id varchar,v_party_site_id varchar) is
2143: select ADDRESS1 ||ADDRESS2 || ADDRESS3 || ADDRESS4 ||CITY ||POSTAL_CODE ||STATE ||PROVINCE || COUNTY||COUNTRY from hz_locations where location_id =(select location_id from hz_party_sites where party_id=v_party_id and party_site_id=v_party_site_id);
2144: cursor org_table(v_party_id varchar) is
2145: select decode(party_type,'C','HZ_PARTIES','EXCHANGE','HZ_PARTIES','CARRIER','HZ_PARTIES','S','PO_VENDORS','I','HR_LOCATIONS','B','CE_BANK_BRANCHES_V') from ecx_tp_headers where party_id =v_party_id ;
2146:
2147: cursor org_site_table(v_party_id varchar) is