DBA Data[Home] [Help]

APPS.HXT_TIME_COLLECTION dependencies on PER_ASSIGNMENTS_F

Line 6110: FROM hxt_per_aei_ddf_v aeiv, per_assignments_f asm

6106: --get rotation plan id for the assignment
6107: BEGIN
6108: SELECT hxt_rotation_plan
6109: INTO l_rot_id
6110: FROM hxt_per_aei_ddf_v aeiv, per_assignments_f asm
6111: WHERE asm.assignment_id = p_assignment_id
6112: AND asm.assignment_id = aeiv.assignment_id
6113: AND p_date_worked BETWEEN asm.effective_start_date
6114: AND asm.effective_end_date