DBA Data[Home] [Help]

APPS.HRI_OPL_REC_CAND_PIPLN dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1961: ,per_assignment_status_types ast

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

Line 1962: ,per_assignment_status_types ast_irc

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