APPS.PER_HU_ABS_REP_ARCHIVE_PKG dependencies on PER_PREVIOUS_EMPLOYERS

Line 1135: FROM per_previous_employers

1131: RETURN NUMBER
1132: IS
1133: CURSOR csr_pre_emp_sickness_holiday(c_person_id NUMBER) IS
1134: SELECT pem_information1
1135: FROM per_previous_employers
1136: WHERE business_group_id = p_business_group_id
1137: AND person_id = c_person_id
1138: AND to_char(end_date,'YYYY') = p_termination_year
1139: ORDER BY end_date DESC;