APPS.PAY_DK_ARCHIVE_EIN dependencies on PER_PERIODS_OF_SERVICE

Line 760: SELECT MAX(date_start) lhd FROM per_periods_of_service

756: rg_csr_get_person_details csr_get_person_details%rowtype;
757:
758: /* Getting the latest hire date */
759: CURSOR csr_latest_hire_date(pid per_all_people_f.person_id%type) IS
760: SELECT MAX(date_start) lhd FROM per_periods_of_service
761: WHERE person_id=pid;
762:
763: rg_csr_latest_hire_date csr_latest_hire_date%rowtype;
764: