[Home] [Help]
APPS.PA_RESOURCE_UTILS dependencies on PER_ASSIGNMENT_STATUS_TYPES
Line 3534: per_assignment_status_types status,
3530: cursor get_active_assignment
3531: is
3532: select asgn.assignment_id
3533: from per_all_assignments_f asgn,
3534: per_assignment_status_types status,
3535: (select person_id, actual_termination_date
3536: from per_periods_of_service
3537: union all
3538: select person_id, actual_termination_date