DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_PROCESS dependencies on PER_PERIODS_OF_SERVICE

Line 4125: FROM per_periods_of_service

4121: CURSOR c_emp_terminateinfo(
4122: p_resource_id NUMBER
4123: ) IS
4124: SELECT final_process_date, date_start
4125: FROM per_periods_of_service
4126: WHERE person_id = p_resource_id
4127: union all
4128: select (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start
4129: from per_periods_of_placement

Line 4926: FROM per_periods_of_service

4922: CURSOR c_emp_terminateinfo(
4923: p_resource_id NUMBER
4924: ) IS
4925: SELECT final_process_date, date_start
4926: FROM per_periods_of_service
4927: WHERE person_id = p_resource_id
4928: union all
4929: select (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start
4930: from per_periods_of_placement