1957: assignment_status_type_id
1958: ,NVL(apl.termination_reason, 'NA_EDW') termination_reason
1959: FROM
1960: per_all_assignments_f asg
1961: ,per_assignment_status_types ast
1962: ,per_assignment_status_types ast_irc
1963: ,per_all_vacancies vac
1964: ,irc_assignment_statuses ias
1965: ,per_applications apl
1958: ,NVL(apl.termination_reason, 'NA_EDW') termination_reason
1959: FROM
1960: per_all_assignments_f asg
1961: ,per_assignment_status_types ast
1962: ,per_assignment_status_types ast_irc
1963: ,per_all_vacancies vac
1964: ,irc_assignment_statuses ias
1965: ,per_applications apl
1966: ,per_recruitment_activities pra