APPS.INV_LABEL_PVT8 dependencies on HZ_LOCATIONS

Line 1062: FROM hz_locations hz) hr

1058: ,hz.address2 address_line_2,hz.address3 address_line_3
1059: ,hz.address4 address_line_4,hz.city city,hz.postal_code postal_code
1060: ,hz.state state,hz.county county,hz.country country,hz.province province
1061: ,hz.description location_code, hz.description location_description
1062: FROM hz_locations hz) hr
1063: WHERE hr.location_id = p_location_id;
1064:
1065: CURSOR c_location(p_site_use_id NUMBER) IS
1066: SELECT location

Line 1074: FROM hz_party_sites hps, hz_locations hl, hz_contact_points hcp

1070: CURSOR c_phone_fax(p_location_id NUMBER, p_type VARCHAR2) IS
1071: SELECT hcp.phone_country_code||decode(hcp.phone_country_code, NULL, '',' ')||
1072: decode(hcp.phone_area_code,NULL,'','(')||hcp.phone_area_code||decode(hcp.phone_area_code,NULL,'',')')||
1073: hcp.phone_number customer_site_tel_number
1074: FROM hz_party_sites hps, hz_locations hl, hz_contact_points hcp
1075: WHERE hps.location_id = hl.location_id
1076: AND hcp.owner_table_name = 'HZ_PARTY_SITES'
1077: AND hcp.owner_table_id = hps.party_site_id
1078: AND (((hcp.phone_line_type IN ('PHONE','GEN')) AND (p_type = 'PHONE')) OR