APPS.HXT_TIME_CLOCK dependencies on HXT_ROTATION_PLANS

Line 1092: FROM hxt_rotation_plans hrp,

1088:
1089: -- ***** Start new code for Bug 2669059 **************
1090: CURSOR l_wsh_details_cur(c_hxt_rotation_plan NUMBER, c_date_worked DATE) IS
1091: SELECT hws.off_shift_prem_id, hws.shift_diff_ovrrd_id
1092: FROM hxt_rotation_plans hrp,
1093: hxt_rotation_schedules hrs,
1094: hxt_weekly_work_schedules hwws,
1095: hxt_work_shifts hws
1096: WHERE hrp.id = c_hxt_rotation_plan