APPS.HXC_SUPERVISOR_DASHBOARD dependencies on HR_GENERAL

Line 277: AND date_to = hr_general.end_of_time;

273: hxc_time_building_blocks
274: WHERE scope = 'TIMECARD'
275: AND time_building_block_id = p_timecard_id
276: AND object_version_number = p_timecard_ovn
277: AND date_to = hr_general.end_of_time;
278:
279: /*
280: Delete extra records from GTT hxc_temp_tcd.
281: */

Line 671: ,NVL(ppos.actual_termination_date,hr_general.end_of_time) period_end_date

667: htt.resource_id
668: ,htt.start_time
669: ,htt.stop_time
670: ,ppos.date_start period_start_date
671: ,NVL(ppos.actual_termination_date,hr_general.end_of_time) period_end_date
672: FROM
673: hxc_temp_tcd htt
674: ,per_periods_of_service ppos
675: WHERE (htt.period_exist = p_period_exist OR

Line 679: AND p_end_date < NVL(ppos.actual_termination_date, hr_general.end_of_time)

675: WHERE (htt.period_exist = p_period_exist OR
676: htt.period_exist = lower(p_period_exist))
677: AND ppos.person_id = htt.resource_id
678: AND p_start_date > ppos.date_start
679: AND p_end_date < NVL(ppos.actual_termination_date, hr_general.end_of_time)
680: AND htt.user_id = p_user_id;
681:
682: CURSOR c_cont_emp_hire_records(p_user_id number,p_period_exist VARCHAR2)
683: IS

Line 689: ,NVL(ppos.actual_termination_date,hr_general.end_of_time) period_end_date

685: htt.resource_id
686: ,htt.start_time
687: ,htt.stop_time
688: ,ppos.date_start period_start_date
689: ,NVL(ppos.actual_termination_date,hr_general.end_of_time) period_end_date
690: FROM
691: hxc_temp_tcd htt
692: ,per_periods_of_placement ppos
693: WHERE (htt.period_exist = p_period_exist OR

Line 697: AND p_end_date < NVL(ppos.actual_termination_date,hr_general.end_of_time)

693: WHERE (htt.period_exist = p_period_exist OR
694: htt.period_exist = lower(p_period_exist))
695: AND ppos.person_id = htt.resource_id
696: AND p_start_date > ppos.date_start
697: AND p_end_date < NVL(ppos.actual_termination_date,hr_general.end_of_time)
698: AND htt.user_id = p_user_id;
699:
700:
701: CURSOR c_get_suspended_assignments