APPS.HXT_TIME_DETAIL dependencies on HXT_SHIFT_DIFF_RULES

Line 1599: FROM hxt_shift_diff_rules sdr

1595: -- sdr.start and stop are numbers.
1596: CURSOR sd_rules
1597: IS
1598: SELECT sdr.element_type_id
1599: FROM hxt_shift_diff_rules sdr
1600: WHERE sdr.sdp_id = g_sdp_id
1601: AND g_date_worked BETWEEN sdr.effective_start_date
1602: AND sdr.effective_end_date
1603: AND ( ( sdr.start_time <=

Line 1661: FROM hxt_shift_diff_rules sdr

1657: -- of the segment does not fall within any rule.
1658: CURSOR sd_rules
1659: IS
1660: SELECT sdr.element_type_id
1661: FROM hxt_shift_diff_rules sdr
1662: WHERE sdr.sdp_id = g_sdp_id
1663: AND g_date_worked BETWEEN sdr.effective_start_date
1664: AND sdr.effective_end_date
1665: AND ( ( TO_NUMBER (TO_CHAR (p_segment_start_time,

Line 2369: FROM hxt_shift_diff_rules sdr, pay_element_types_f elt

2365: CURSOR sdp_rule_cursor
2366: IS
2367: SELECT sdr.start_time, sdr.stop_time, sdr.carryover_time,
2368: elt.element_name
2369: FROM hxt_shift_diff_rules sdr, pay_element_types_f elt
2370: WHERE sdr.sdp_id = g_sdp_id
2371: AND sdr.element_type_id = elt.element_type_id
2372: AND trunc(p_sum_time_in) BETWEEN elt.effective_start_date
2373: AND elt.effective_end_date;