[Home] [Help]
View: PA_CANDIDATE_REVIEWS_V
Product: | PA - Projects |
Description: | This view stores information of candidate reviews. |
Implementation/DBA Data: |
APPS.PA_CANDIDATE_REVIEWS_V
|
View Text
SELECT CAND_REW.CANDIDATE_REVIEW_ID
, CAND_REW.CANDIDATE_ID
, CAND_REW.STATUS_CODE
, PS.PROJECT_STATUS_NAME
, CAND_REW.REVIEWER_PERSON_ID
, PA_CANDIDATE_UTILS.GET_RESOURCE_ID(CAND_REW.REVIEWER_PERSON_ID)
, PER.FULL_NAME
, CAND_REW.REVIEW_DATE
, CAND_REW.CHANGE_REASON_CODE
, LKP.MEANING
, CAND_REW.REVIEW_COMMENTS
, PA_CANDIDATE_UTILS.GET_CANDIDATE_SCORE(RES.RESOURCE_ID
, RES.PERSON_ID
, CAND.ASSIGNMENT_ID
, ASGMT.PROJECT_ID
, NULL
, NULL
, NULL
, NULL
, RES.RESOURCE_JOB_LEVEL
, NULL
, NULL
, NULL
, NULL
, NULL) FROM PA_CANDIDATE_REVIEWS CAND_REW
, PER_PEOPLE_X PER
, PA_PROJECT_STATUSES PS
, PA_LOOKUPS LKP
, PA_CANDIDATES CAND
, PA_RESOURCES_DENORM RES
, PA_PROJECT_ASSIGNMENTS ASGMT
WHERE CAND_REW.REVIEWER_PERSON_ID = PER.PERSON_ID AND CAND_REW.STATUS_CODE = PS.PROJECT_STATUS_CODE (+) AND PS.STATUS_TYPE (+) = 'CANDIDATE' AND CAND_REW.CHANGE_REASON_CODE = LKP.LOOKUP_CODE (+) AND LKP.LOOKUP_TYPE (+) = 'CANDIDATE_STS_CHANGE_REASON'
AND CAND.CANDIDATE_ID = CAND_REW.CANDIDATE_ID
AND CAND.RESOURCE_ID = RES.RESOURCE_ID
AND CAND.ASSIGNMENT_ID = ASGMT.ASSIGNMENT_ID
AND ASGMT.START_DATE BETWEEN RES.RESOURCE_EFFECTIVE_START_DATE
AND NVL(RES.RESOURCE_EFFECTIVE_END_DATE
, SYSDATE+1)
AND RES.SCHEDULABLE_FLAG = 'Y'
Columns
Name |
CANDIDATE_REVIEW_ID |
CANDIDATE_ID |
STATUS_CODE |
STATUS_NAME |
REVIEWER_PERSON_ID |
REVIEWER_RESOURCE_ID |
REVIEWER_NAME |
REVIEW_DATE |
CHANGE_REASON_CODE |
CHANGE_REASON |
REVIEW_COMMENTS |
CANDIDATE_SCORE |