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.HXT_TIME_SUMMARY dependencies on HXT_SHIFT_DIFF_RULES

Line 1335: FROM hxt_shift_diff_rules sdr

1331: SELECT sdr.start_time
1332: ,sdr.stop_time
1333: -- ,sdr.element_type_id
1334: ,sdr.carryover_time
1335: FROM hxt_shift_diff_rules sdr
1336: WHERE sdr.sdp_id = g_sdp_id
1337: AND g_DATE_WORKED BETWEEN
1338: sdr.effective_start_date AND sdr.effective_end_date;
1339:

Line 1340: ln_sd_start hxt_shift_diff_rules.start_time%TYPE;

1336: WHERE sdr.sdp_id = g_sdp_id
1337: AND g_DATE_WORKED BETWEEN
1338: sdr.effective_start_date AND sdr.effective_end_date;
1339:
1340: ln_sd_start hxt_shift_diff_rules.start_time%TYPE;
1341: ln_sd_stop hxt_shift_diff_rules.stop_time%TYPE;
1342: ln_sd_carryover hxt_shift_diff_rules.carryover_time%TYPE;
1343: sd_start_time DATE;
1344: sd_stop_time DATE;

Line 1341: ln_sd_stop hxt_shift_diff_rules.stop_time%TYPE;

1337: AND g_DATE_WORKED BETWEEN
1338: sdr.effective_start_date AND sdr.effective_end_date;
1339:
1340: ln_sd_start hxt_shift_diff_rules.start_time%TYPE;
1341: ln_sd_stop hxt_shift_diff_rules.stop_time%TYPE;
1342: ln_sd_carryover hxt_shift_diff_rules.carryover_time%TYPE;
1343: sd_start_time DATE;
1344: sd_stop_time DATE;
1345: sd_carryover_time DATE;

Line 1342: ln_sd_carryover hxt_shift_diff_rules.carryover_time%TYPE;

1338: sdr.effective_start_date AND sdr.effective_end_date;
1339:
1340: ln_sd_start hxt_shift_diff_rules.start_time%TYPE;
1341: ln_sd_stop hxt_shift_diff_rules.stop_time%TYPE;
1342: ln_sd_carryover hxt_shift_diff_rules.carryover_time%TYPE;
1343: sd_start_time DATE;
1344: sd_stop_time DATE;
1345: sd_carryover_time DATE;
1346: sd_date_worked DATE;

Line 1562: from hxt_shift_diff_rules sdr

1558: select sdr.start_time
1559: ,sdr.stop_time
1560: ,sdr.carryover_time
1561: ,sdr.element_type_id
1562: from hxt_shift_diff_rules sdr
1563: where sdr.sdp_id = g_sdp_id
1564: and g_date_worked between sdr.effective_start_date
1565: and sdr.effective_end_date;
1566:

Line 1567: sdp_start hxt_shift_diff_rules.start_time%TYPE;

1563: where sdr.sdp_id = g_sdp_id
1564: and g_date_worked between sdr.effective_start_date
1565: and sdr.effective_end_date;
1566:
1567: sdp_start hxt_shift_diff_rules.start_time%TYPE;
1568: sdp_stop hxt_shift_diff_rules.stop_time%TYPE;
1569: sdp_carryover hxt_shift_diff_rules.carryover_time%TYPE;
1570: sdp_earning hxt_shift_diff_rules.element_type_id%TYPE;
1571: sdp_start_time DATE;

Line 1568: sdp_stop hxt_shift_diff_rules.stop_time%TYPE;

1564: and g_date_worked between sdr.effective_start_date
1565: and sdr.effective_end_date;
1566:
1567: sdp_start hxt_shift_diff_rules.start_time%TYPE;
1568: sdp_stop hxt_shift_diff_rules.stop_time%TYPE;
1569: sdp_carryover hxt_shift_diff_rules.carryover_time%TYPE;
1570: sdp_earning hxt_shift_diff_rules.element_type_id%TYPE;
1571: sdp_start_time DATE;
1572: sdp_stop_time DATE;

Line 1569: sdp_carryover hxt_shift_diff_rules.carryover_time%TYPE;

1565: and sdr.effective_end_date;
1566:
1567: sdp_start hxt_shift_diff_rules.start_time%TYPE;
1568: sdp_stop hxt_shift_diff_rules.stop_time%TYPE;
1569: sdp_carryover hxt_shift_diff_rules.carryover_time%TYPE;
1570: sdp_earning hxt_shift_diff_rules.element_type_id%TYPE;
1571: sdp_start_time DATE;
1572: sdp_stop_time DATE;
1573: sdp_carryover_time DATE;

Line 1570: sdp_earning hxt_shift_diff_rules.element_type_id%TYPE;

1566:
1567: sdp_start hxt_shift_diff_rules.start_time%TYPE;
1568: sdp_stop hxt_shift_diff_rules.stop_time%TYPE;
1569: sdp_carryover hxt_shift_diff_rules.carryover_time%TYPE;
1570: sdp_earning hxt_shift_diff_rules.element_type_id%TYPE;
1571: sdp_start_time DATE;
1572: sdp_stop_time DATE;
1573: sdp_carryover_time DATE;
1574:

Line 2077: FROM hxt_shift_diff_rules sdr

2073:
2074: CURSOR sd_rules IS
2075: SELECT sdr.element_type_id
2076: ,sdr.carryover_time
2077: FROM hxt_shift_diff_rules sdr
2078: WHERE sdr.sdp_id = g_sdp_id
2079: AND g_DATE_WORKED BETWEEN
2080: sdr.effective_start_date AND sdr.effective_end_date
2081: AND ( (sdr.start_time <= to_number(to_char(segment_start_time, 'HH24MI'))

Line 2126: FROM hxt_shift_diff_rules sdr

2122: -- the segment does not fall within any rule.
2123:
2124: CURSOR sd_rules IS
2125: SELECT sdr.start_time
2126: FROM hxt_shift_diff_rules sdr
2127: WHERE sdr.sdp_id = g_sdp_id
2128: AND g_DATE_WORKED BETWEEN
2129: sdr.effective_start_date AND sdr.effective_end_date
2130: AND ( ( to_number(to_char(segment_start_time, 'HH24MI')) < sdr.start_time