APPS.ECX_TP_SYNCH dependencies on HZ_LOCATIONS

Line 64: STATE ||' '||PROVINCE ||' '||COUNTY||' '||COUNTRY from hz_locations

60: select PARTY_NAME from hz_parties where party_id=v_party_id;
61:
62: cursor customer_site_name(v_party_id varchar,v_party_site_id varchar) is
63: select ADDRESS1||' '||ADDRESS2||' ' || ADDRESS3 ||' '|| ADDRESS4||' ' ||CITY||' ' ||POSTAL_CODE||' ' ||
64: STATE ||' '||PROVINCE ||' '||COUNTY||' '||COUNTRY from hz_locations
65: where location_id =(select location_id from hz_party_sites where party_id=v_party_id and party_site_id=v_party_site_id);
66:
67: cursor org_table(v_party_id varchar) is
68: 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 ;