DBA Data[Home] [Help]

APPS.BEN_GLOBAL_ENRT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 281: per_assignment_status_types ast

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