DBA Data[Home] [Help]

APPS.HR_EX_EMPLOYEE_INTERNAL dependencies on PER_ASSIGNMENTS_F

Line 357: FROM per_assignments_f asg,

353: , max(effective_start_date) as effective_start_date
354: , max(effective_end_date) as effective_end_date
355: , asg.payroll_id as payroll_id
356: , asg.object_version_number as object_version_number
357: FROM per_assignments_f asg,
358: per_assignment_status_types ast
359: WHERE asg.person_id = cp_person_id
360: AND asg.period_of_service_id = cp_period_of_service_id
361: AND ast.per_system_status = 'TERM_ASSIGN'