DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_PROCESS dependencies on PER_PERIODS_OF_SERVICE

Line 5121: FROM per_periods_of_service

5117: CURSOR c_emp_terminateinfo(
5118: p_resource_id NUMBER
5119: ) IS
5120: SELECT final_process_date, date_start
5121: FROM per_periods_of_service
5122: WHERE person_id = p_resource_id
5123: union all
5124: select (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start
5125: from per_periods_of_placement

Line 6278: FROM per_periods_of_service

6274: CURSOR c_emp_terminateinfo(
6275: p_resource_id NUMBER
6276: ) IS
6277: SELECT final_process_date, date_start
6278: FROM per_periods_of_service
6279: WHERE person_id = p_resource_id
6280: union all
6281: select (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start
6282: from per_periods_of_placement