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