View: PA_CANDIDATES_V

Product:	PA - Projects
Description:	This view stores information of candidate nomination.
Implementation/DBA Data:	APPS.PA_CANDIDATES_V

View Text

SELECT CAND.CANDIDATE_ID
, RES.RESOURCE_NAME
, RES.RESOURCE_ID
, RES.PERSON_ID
, ASGMT.PROJECT_ID
, PROJ.NAME
, PROJ.SEGMENT1
, CAND.ASSIGNMENT_ID
, ASGMT.ASSIGNMENT_NAME
, ASGMT.START_DATE
, ASGMT.END_DATE
, RES.RESOURCE_JOB_LEVEL
, ORG.NAME
, RES.RESOURCE_ORGANIZATION_ID
, CAND.STATUS_CODE
, PS.PROJECT_STATUS_NAME
, PS.PROJECT_SYSTEM_STATUS_CODE
, CAND.NOMINATED_BY_PERSON_ID
, PA_CANDIDATE_UTILS.GET_RESOURCE_ID(CAND.NOMINATED_BY_PERSON_ID) AS NOMINATED_BY_RESOURCE_ID
, PA_CANDIDATE_UTILS.GET_NOMINATOR_NAME(CAND.NOMINATED_BY_PERSON_ID) AS NOMINATED_BY
, CAND.NOMINATION_DATE
, CAND.NOMINATION_COMMENTS
, CAND.CANDIDATE_RANKING
, CAND.RECORD_VERSION_NUMBER
, ASGMT.STAFFING_OWNER_PERSON_ID
, PA_RESOURCE_UTILS.GET_PERSON_NAME_NO_DATE(ASGMT.STAFFING_OWNER_PERSON_ID) AS STAFFING_OWNER_NAME FROM PA_CANDIDATES CAND
, PA_RESOURCES_DENORM RES
, PA_PROJECT_ASSIGNMENTS ASGMT
, PA_PROJECTS_ALL PROJ
, PA_PROJECT_STATUSES PS
, HR_ALL_ORGANIZATION_UNITS ORG
WHERE CAND.RESOURCE_ID = RES.RESOURCE_ID AND CAND.STATUS_CODE = PS.PROJECT_STATUS_CODE AND CAND.ASSIGNMENT_ID = ASGMT.ASSIGNMENT_ID AND ASGMT.START_DATE BETWEEN RES.RESOURCE_EFFECTIVE_START_DATE
AND NVL(RES.RESOURCE_EFFECTIVE_END_DATE
, ASGMT.START_DATE+1) AND ASGMT.PROJECT_ID = PROJ.PROJECT_ID AND PS.STATUS_TYPE = 'CANDIDATE' AND RES.RESOURCE_ORGANIZATION_ID = ORG.ORGANIZATION_ID (+)
AND RES.SCHEDULABLE_FLAG = 'Y'

Columns