DBA Data[Home] [Help]

APPS.BEN_GLOBAL_ENRT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 278: per_assignment_status_types ast

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'
282: and asg.assignment_status_type_id = ast.assignment_status_type_id