APPS.PER_ES_COMP_CERT_ARCHIVE_PKG dependencies on HR_LOCATIONS_ALL

Line 401: hr_locations_all addr

397: ,hr_general.decode_lookup('ES_PROVINCE_CODES',addr.region_2) prov
398: ,addr.postal_code postal_code
399: ,addr.telephone_number_1 telephone_number
400: FROM hr_organization_units hou,
401: hr_locations_all addr
402: WHERE hou.organization_id = c_organization_id
403: AND hou.location_id = addr.location_id;
404: --
405: l_found BOOLEAN;

Line 623: hr_locations_all addr

619:
620: CURSOR csr_get_wc_prov(c_wc_id NUMBER) IS
621: SELECT hr_general.decode_lookup('ES_PROVINCE_CODES',addr.region_2) prov
622: FROM hr_organization_units hou,
623: hr_locations_all addr
624: WHERE hou.organization_id = c_wc_id
625: AND hou.location_id = addr.location_id;
626:
627: l_wc_prov hr_lookups.meaning%type;