APPS.BEN_ENROLMENT_REQUIREMENTS2 dependencies on PER_ALL_ASSIGNMENTS_F

Line 36: FROM per_all_assignments_f asg

32: )
33: IS
34: SELECT asg.assignment_id,
35: asg.organization_id
36: FROM per_all_assignments_f asg
37: WHERE person_id = c_per_id
38: and asg.assignment_type <> 'C'
39: AND asg.primary_flag = decode(c_run_md, 'I',asg.primary_flag, 'Y')
40: AND c_effdt