APPS.PAY_DK_ARCHIVE_EHOL dependencies on PER_PERIODS_OF_SERVICE

Line 1157: SELECT MAX(date_start) lhd FROM per_periods_of_service

1153: /* Getting the latest hire date */
1154: /* For Bug 9011035 */
1155: CURSOR csr_latest_hire_date(pid per_all_people_f.person_id%type
1156: ,p_end_date DATE) IS
1157: SELECT MAX(date_start) lhd FROM per_periods_of_service
1158: WHERE person_id=pid
1159: AND date_start <= p_end_date;
1160:
1161: rg_csr_latest_hire_date csr_latest_hire_date%rowtype;