DBA Data[Home] [Help]

APPS.HRI_OPL_REC_CAND_PIPLN dependencies on PER_REQUISITIONS

Line 1967: ,per_requisitions prq

1963: ,per_all_vacancies vac
1964: ,irc_assignment_statuses ias
1965: ,per_applications apl
1966: ,per_recruitment_activities pra
1967: ,per_requisitions prq
1968: WHERE asg.assignment_id = p_info_rec.asg_id
1969: AND apl.application_id = asg.application_id
1970: AND asg.assignment_status_type_id = ast.assignment_status_type_id
1971: AND ias.assignment_status_type_id = ast_irc.assignment_status_type_id (+)