eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_HAC_BUS dependencies on HR_GENERAL

Line 309: IF p_start_date > NVL(p_end_date, hr_general.END_OF_TIME) THEN

305: -- END IF;
306: --
307: -- check that the start date is not equal to or more than the end date
308: --
309: IF p_start_date > NVL(p_end_date, hr_general.END_OF_TIME) THEN
310: --
311: hr_utility.set_message
312: (809
313: ,'HXC_0055_HAC_COMP_DT_ERR'

Line 370: AND NVL(s.end_date, hr_general.END_OF_TIME)

366: FROM hxc_approval_comps s
367: WHERE s.approval_style_id = p_approval_style_id
368: AND s.time_recipient_id = p_time_recipient_id
369: AND s.start_date >= p_start_date
370: AND NVL(s.end_date, hr_general.END_OF_TIME)
371: <= NVL(p_end_date,hr_general.END_OF_TIME)
372: AND p_time_recipient_id <> -1 ;
373: --
374: l_result VARCHAR2 (1);

Line 371: <= NVL(p_end_date,hr_general.END_OF_TIME)

367: WHERE s.approval_style_id = p_approval_style_id
368: AND s.time_recipient_id = p_time_recipient_id
369: AND s.start_date >= p_start_date
370: AND NVL(s.end_date, hr_general.END_OF_TIME)
371: <= NVL(p_end_date,hr_general.END_OF_TIME)
372: AND p_time_recipient_id <> -1 ;
373: --
374: l_result VARCHAR2 (1);
375: --

Line 451: AND NVL(s.end_date, hr_general.END_OF_TIME)

447: WHERE s.approval_comp_id <> p_approval_comp_id
448: AND s.approval_style_id = p_approval_style_id
449: AND s.time_recipient_id = p_time_recipient_id
450: AND s.start_date >= p_start_date
451: AND NVL(s.end_date, hr_general.END_OF_TIME)
452: <= NVL(p_end_date,hr_general.END_OF_TIME)
453: AND p_time_recipient_id <> -1 ;
454: --
455: l_result VARCHAR2 (1);

Line 452: <= NVL(p_end_date,hr_general.END_OF_TIME)

448: AND s.approval_style_id = p_approval_style_id
449: AND s.time_recipient_id = p_time_recipient_id
450: AND s.start_date >= p_start_date
451: AND NVL(s.end_date, hr_general.END_OF_TIME)
452: <= NVL(p_end_date,hr_general.END_OF_TIME)
453: AND p_time_recipient_id <> -1 ;
454: --
455: l_result VARCHAR2 (1);
456: --

Line 647: AND NVL(s.end_date, hr_general.END_OF_TIME) < p_start_date)

643: FROM hxc_approval_comps s
644: WHERE s.approval_style_id = p_approval_style_id
645: AND s.time_recipient_id = p_time_recipient_id
646: AND NOT ( (s.start_date < p_start_date
647: AND NVL(s.end_date, hr_general.END_OF_TIME) < p_start_date)
648: OR (s.start_date > p_end_date
649: AND NVL(s.end_date, hr_general.END_OF_TIME)
650: > NVL(p_end_date, hr_general.END_OF_TIME))
651: )

Line 649: AND NVL(s.end_date, hr_general.END_OF_TIME)

645: AND s.time_recipient_id = p_time_recipient_id
646: AND NOT ( (s.start_date < p_start_date
647: AND NVL(s.end_date, hr_general.END_OF_TIME) < p_start_date)
648: OR (s.start_date > p_end_date
649: AND NVL(s.end_date, hr_general.END_OF_TIME)
650: > NVL(p_end_date, hr_general.END_OF_TIME))
651: )
652: AND p_time_recipient_id <> -1;
653: --

Line 650: > NVL(p_end_date, hr_general.END_OF_TIME))

646: AND NOT ( (s.start_date < p_start_date
647: AND NVL(s.end_date, hr_general.END_OF_TIME) < p_start_date)
648: OR (s.start_date > p_end_date
649: AND NVL(s.end_date, hr_general.END_OF_TIME)
650: > NVL(p_end_date, hr_general.END_OF_TIME))
651: )
652: AND p_time_recipient_id <> -1;
653: --
654: BEGIN

Line 845: AND NVL(s.end_date, hr_general.END_OF_TIME) < p_start_date)

841: WHERE s.approval_comp_id <> p_approval_comp_id
842: AND s.approval_style_id = p_approval_style_id
843: AND s.time_recipient_id = p_time_recipient_id
844: AND NOT ( (s.start_date < p_start_date
845: AND NVL(s.end_date, hr_general.END_OF_TIME) < p_start_date)
846: OR (s.start_date > p_end_date
847: AND NVL(s.end_date, hr_general.END_OF_TIME)
848: > NVL(p_end_date, hr_general.END_OF_TIME))
849: )

Line 847: AND NVL(s.end_date, hr_general.END_OF_TIME)

843: AND s.time_recipient_id = p_time_recipient_id
844: AND NOT ( (s.start_date < p_start_date
845: AND NVL(s.end_date, hr_general.END_OF_TIME) < p_start_date)
846: OR (s.start_date > p_end_date
847: AND NVL(s.end_date, hr_general.END_OF_TIME)
848: > NVL(p_end_date, hr_general.END_OF_TIME))
849: )
850: AND p_time_recipient_id <> -1 ;
851: --

Line 848: > NVL(p_end_date, hr_general.END_OF_TIME))

844: AND NOT ( (s.start_date < p_start_date
845: AND NVL(s.end_date, hr_general.END_OF_TIME) < p_start_date)
846: OR (s.start_date > p_end_date
847: AND NVL(s.end_date, hr_general.END_OF_TIME)
848: > NVL(p_end_date, hr_general.END_OF_TIME))
849: )
850: AND p_time_recipient_id <> -1 ;
851: --
852: BEGIN