DBA Data[Home] [Help]

APPS.HXT_TIME_CLOCK dependencies on HXT_WEEKLY_WORK_SCHEDULES

Line 1037: -- hxt_weekly_work_schedules wws,

1033: -- hxt_per_aei_ddf_v aeiv, --ORACLE
1034: -- per_assignment_status_types ast,
1035: -- per_assignments_f asm,
1036: -- hxt_shifts sht,
1037: -- hxt_weekly_work_schedules wws,
1038: -- hxt_work_shifts wsh,
1039: -- hxt_rotation_schedules rts
1040: -- WHERE c_assignment_id = asm.assignment_id
1041: -- AND ast.assignment_status_type_id = asm.assignment_status_type_id

Line 1094: hxt_weekly_work_schedules hwws,

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
1097: AND c_date_worked BETWEEN hrp.date_from
1098: AND NVL (hrp.date_to, c_date_worked )