APPS.HXC_TIMEKEEPER_PROCESS dependencies on FND_PROFILE

Line 651: g_abs_intg_profile_set:= nvl(FND_PROFILE.VALUE('HR_ABS_OTL_INTEGRATION'),'N');

647: Setting the value for the HR OTL Integration Profile to a
648: global var.
649: */
650: -- Change start
651: g_abs_intg_profile_set:= nvl(FND_PROFILE.VALUE('HR_ABS_OTL_INTEGRATION'),'N');
652: -- Change end
653:
654:
655: -- DELETE FROM detail_temp;

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

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
5126: where person_id = p_resource_id
5127: ORDER BY date_start DESC;
5128:

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

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
6283: where person_id = p_resource_id
6284: ORDER BY date_start DESC;
6285: