DBA Data[Home] [Help]

APPS.BEN_GLOBAL_ENRT dependencies on PER_ALL_ASSIGNMENTS_F

Line 277: from per_all_assignments_f asg,

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