DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_PROCESS dependencies on FND_PROFILE

Line 4128: select (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start

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
4130: where person_id = p_resource_id
4131: ORDER BY date_start DESC;
4132:

Line 4929: select (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start

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
4931: where person_id = p_resource_id
4932: ORDER BY date_start DESC;
4933: