DBA Data[Home] [Help]

APPS.HXT_TIME_COLLECTION dependencies on HXT_WORK_SHIFTS

Line 68: hxt_work_shifts wsh,

64: per_assignment_status_types ast,
65: per_assignments_f asm,
66: hxt_shifts sht,
67: hxt_weekly_work_schedules wws,
68: hxt_work_shifts wsh,
69: hxt_rotation_schedules rts
70: WHERE c_assignment_id = asm.assignment_id
71: AND TRUNC (c_date_worked) BETWEEN TRUNC (asm.effective_start_date)
72: AND TRUNC (asm.effective_end_date)