DBA Data[Home] [Help]

APPS.PER_FR_TERMINATION dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 413: , per_assignment_status_types ast

409: , scl.segment4
410: , scl.segment2
411: from per_all_assignments_f a
412: , hr_soft_coding_keyflex scl
413: , per_assignment_status_types ast
414: where a.period_of_service_id = p_period_of_service_id
415: and p_actual_termination_date = a.effective_end_date
416: and a.assignment_status_type_id = ast.assignment_status_type_id
417: and ast.per_system_status <> 'TERM_ASSIGN'