DBA Data[Home] [Help]

APPS.HXT_TIME_COLLECTION dependencies on PER_ALL_ASSIGNMENTS_F

Line 6491: FROM hxt_per_aei_ddf_v aeiv, per_all_assignments_f asm -- Bug 12776437

6487: --get rotation plan id for the assignment
6488: BEGIN
6489: SELECT hxt_rotation_plan
6490: INTO l_rot_id
6491: FROM hxt_per_aei_ddf_v aeiv, per_all_assignments_f asm -- Bug 12776437
6492: WHERE asm.assignment_id = p_assignment_id
6493: AND asm.assignment_id = aeiv.assignment_id
6494: AND p_date_worked BETWEEN asm.effective_start_date
6495: AND asm.effective_end_date