APPS.PER_HU_ABS_REP_ARCHIVE_PKG dependencies on HR_LOCATIONS

Line 280: FROM hr_locations hrl

276: AND pur.effective_end_date ;
277: --
278: CURSOR csr_location_code(c_location_id NUMBER) IS
279: SELECT hrl.location_code
280: FROM hr_locations hrl
281: WHERE hrl.location_id = c_location_id;
282: --
283: CURSOR csr_job_name(c_job_id NUMBER) IS
284: SELECT jbt.name

Line 411: l_location_code hr_locations.location_code%TYPE;

407: --l_base_absence NUMBER;
408: --l_child_care_absence NUMBER;
409: --l_additional_absence NUMBER;
410:
411: l_location_code hr_locations.location_code%TYPE;
412: l_job_name per_job_definitions.segment1%TYPE;
413:
414: l_calculation_date DATE;
415: l_term_end_date DATE;