DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PER_PERIODS_OF_SERVICE

Line 2911: from per_periods_of_service

2907: select max(date_start)
2908: ,max(actual_termination_date)
2909: into l_hire_date
2910: ,l_termination_date
2911: from per_periods_of_service
2912: where person_id = l_person_id;
2913:
2914: exception
2915: when no_data_found then