DBA Data[Home] [Help]

APPS.BEN_GLOBAL_ENRT dependencies on PER_ALL_ASSIGNMENTS_F

Line 280: from per_all_assignments_f asg,

276: -- Get employee active assignments first, then look for active
277: -- benefit's assignments.
278: cursor c1 is
279: select asg.payroll_id
280: from per_all_assignments_f asg,
281: per_assignment_status_types ast
282: where asg.person_id = p_person_id
283: and asg.assignment_type <> 'C'
284: and asg.primary_flag = 'Y'