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_DETAIL dependencies on HXT_SHIFT_DIFF_RULES

Line 1159: FROM hxt_shift_diff_rules sdr

1155: -- sdr.start and stop are numbers.
1156: CURSOR sd_rules
1157: IS
1158: SELECT sdr.element_type_id
1159: FROM hxt_shift_diff_rules sdr
1160: WHERE sdr.sdp_id = g_sdp_id
1161: AND g_date_worked BETWEEN sdr.effective_start_date
1162: AND sdr.effective_end_date
1163: AND ( ( sdr.start_time <=

Line 1221: FROM hxt_shift_diff_rules sdr

1217: -- of the segment does not fall within any rule.
1218: CURSOR sd_rules
1219: IS
1220: SELECT sdr.element_type_id
1221: FROM hxt_shift_diff_rules sdr
1222: WHERE sdr.sdp_id = g_sdp_id
1223: AND g_date_worked BETWEEN sdr.effective_start_date
1224: AND sdr.effective_end_date
1225: AND ( ( TO_NUMBER (TO_CHAR (p_segment_start_time,

Line 1823: FROM hxt_shift_diff_rules sdr, pay_element_types_f elt

1819: CURSOR sdp_rule_cursor
1820: IS
1821: SELECT sdr.start_time, sdr.stop_time, sdr.carryover_time,
1822: elt.element_name
1823: FROM hxt_shift_diff_rules sdr, pay_element_types_f elt
1824: WHERE sdr.sdp_id = g_sdp_id
1825: AND sdr.element_type_id = elt.element_type_id
1826: AND trunc(p_sum_time_in) BETWEEN elt.effective_start_date
1827: AND elt.effective_end_date;