APPS.PAY_DK_ARCHIVE_EIN dependencies on PER_PERIODS_OF_SERVICE

Line 890: SELECT MAX(date_start) lhd FROM per_periods_of_service

886: /* Getting the latest hire date */
887: /* For Bug 9011035 */
888: CURSOR csr_latest_hire_date(pid per_all_people_f.person_id%type
889: ,p_end_date DATE) IS
890: SELECT MAX(date_start) lhd FROM per_periods_of_service
891: WHERE person_id=pid
892: AND date_start <= p_end_date;
893:
894: rg_csr_latest_hire_date csr_latest_hire_date%rowtype;