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.

[Home] [Help]

APPS.HXT_TIME_SUMMARY dependencies on HXT_SHIFT_DIFF_RULES

Line 2627: FROM hxt_shift_diff_rules sdr

2623: SELECT sdr.start_time
2624: ,sdr.stop_time
2625: -- ,sdr.element_type_id
2626: ,sdr.carryover_time
2627: FROM hxt_shift_diff_rules sdr
2628: WHERE sdr.sdp_id = g_sdp_id
2629: AND g_DATE_WORKED BETWEEN
2630: sdr.effective_start_date AND sdr.effective_end_date;
2631:

Line 2632: ln_sd_start hxt_shift_diff_rules.start_time%TYPE;

2628: WHERE sdr.sdp_id = g_sdp_id
2629: AND g_DATE_WORKED BETWEEN
2630: sdr.effective_start_date AND sdr.effective_end_date;
2631:
2632: ln_sd_start hxt_shift_diff_rules.start_time%TYPE;
2633: ln_sd_stop hxt_shift_diff_rules.stop_time%TYPE;
2634: ln_sd_carryover hxt_shift_diff_rules.carryover_time%TYPE;
2635: sd_start_time DATE;
2636: sd_stop_time DATE;

Line 2633: ln_sd_stop hxt_shift_diff_rules.stop_time%TYPE;

2629: AND g_DATE_WORKED BETWEEN
2630: sdr.effective_start_date AND sdr.effective_end_date;
2631:
2632: ln_sd_start hxt_shift_diff_rules.start_time%TYPE;
2633: ln_sd_stop hxt_shift_diff_rules.stop_time%TYPE;
2634: ln_sd_carryover hxt_shift_diff_rules.carryover_time%TYPE;
2635: sd_start_time DATE;
2636: sd_stop_time DATE;
2637: sd_carryover_time DATE;

Line 2634: ln_sd_carryover hxt_shift_diff_rules.carryover_time%TYPE;

2630: sdr.effective_start_date AND sdr.effective_end_date;
2631:
2632: ln_sd_start hxt_shift_diff_rules.start_time%TYPE;
2633: ln_sd_stop hxt_shift_diff_rules.stop_time%TYPE;
2634: ln_sd_carryover hxt_shift_diff_rules.carryover_time%TYPE;
2635: sd_start_time DATE;
2636: sd_stop_time DATE;
2637: sd_carryover_time DATE;
2638: sd_date_worked DATE;

Line 2878: from hxt_shift_diff_rules sdr

2874: select sdr.start_time
2875: ,sdr.stop_time
2876: ,sdr.carryover_time
2877: ,sdr.element_type_id
2878: from hxt_shift_diff_rules sdr
2879: where sdr.sdp_id = g_sdp_id
2880: and g_date_worked between sdr.effective_start_date
2881: and sdr.effective_end_date;
2882:

Line 2883: sdp_start hxt_shift_diff_rules.start_time%TYPE;

2879: where sdr.sdp_id = g_sdp_id
2880: and g_date_worked between sdr.effective_start_date
2881: and sdr.effective_end_date;
2882:
2883: sdp_start hxt_shift_diff_rules.start_time%TYPE;
2884: sdp_stop hxt_shift_diff_rules.stop_time%TYPE;
2885: sdp_carryover hxt_shift_diff_rules.carryover_time%TYPE;
2886: sdp_earning hxt_shift_diff_rules.element_type_id%TYPE;
2887: sdp_start_time DATE;

Line 2884: sdp_stop hxt_shift_diff_rules.stop_time%TYPE;

2880: and g_date_worked between sdr.effective_start_date
2881: and sdr.effective_end_date;
2882:
2883: sdp_start hxt_shift_diff_rules.start_time%TYPE;
2884: sdp_stop hxt_shift_diff_rules.stop_time%TYPE;
2885: sdp_carryover hxt_shift_diff_rules.carryover_time%TYPE;
2886: sdp_earning hxt_shift_diff_rules.element_type_id%TYPE;
2887: sdp_start_time DATE;
2888: sdp_stop_time DATE;

Line 2885: sdp_carryover hxt_shift_diff_rules.carryover_time%TYPE;

2881: and sdr.effective_end_date;
2882:
2883: sdp_start hxt_shift_diff_rules.start_time%TYPE;
2884: sdp_stop hxt_shift_diff_rules.stop_time%TYPE;
2885: sdp_carryover hxt_shift_diff_rules.carryover_time%TYPE;
2886: sdp_earning hxt_shift_diff_rules.element_type_id%TYPE;
2887: sdp_start_time DATE;
2888: sdp_stop_time DATE;
2889: sdp_carryover_time DATE;

Line 2886: sdp_earning hxt_shift_diff_rules.element_type_id%TYPE;

2882:
2883: sdp_start hxt_shift_diff_rules.start_time%TYPE;
2884: sdp_stop hxt_shift_diff_rules.stop_time%TYPE;
2885: sdp_carryover hxt_shift_diff_rules.carryover_time%TYPE;
2886: sdp_earning hxt_shift_diff_rules.element_type_id%TYPE;
2887: sdp_start_time DATE;
2888: sdp_stop_time DATE;
2889: sdp_carryover_time DATE;
2890:

Line 3394: FROM hxt_shift_diff_rules sdr

3390:
3391: CURSOR sd_rules IS
3392: SELECT sdr.element_type_id
3393: ,sdr.carryover_time
3394: FROM hxt_shift_diff_rules sdr
3395: WHERE sdr.sdp_id = g_sdp_id
3396: AND g_DATE_WORKED BETWEEN
3397: sdr.effective_start_date AND sdr.effective_end_date
3398: AND ( (sdr.start_time <= to_number(to_char(segment_start_time, 'HH24MI'))

Line 3443: FROM hxt_shift_diff_rules sdr

3439: -- the segment does not fall within any rule.
3440:
3441: CURSOR sd_rules IS
3442: SELECT sdr.start_time
3443: FROM hxt_shift_diff_rules sdr
3444: WHERE sdr.sdp_id = g_sdp_id
3445: AND g_DATE_WORKED BETWEEN
3446: sdr.effective_start_date AND sdr.effective_end_date
3447: AND ( ( to_number(to_char(segment_start_time, 'HH24MI')) < sdr.start_time