APPS.PER_ES_COMP_CERT_ARCHIVE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 89: l_business_group_id hr_organization_units.business_group_id%type;

85: --
86:
87: l_ovn NUMBER;
88: l_action_info_id NUMBER;
89: l_business_group_id hr_organization_units.business_group_id%type;
90: l_start_date DATE;
91: l_end_date DATE;
92: l_legal_employer number;
93: l_legal_representative_info csr_legal_representative_info%rowtype;

Line 400: FROM hr_organization_units hou,

396: ,addr.town_or_city town_or_city
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: --

Line 622: FROM hr_organization_units hou,

618: AND jbt.job_id = c_job_id;
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: