Product: | BEN - Advanced Benefits |
---|---|
Description: | This view captures Person Information for Compensation Workbench |
Implementation/DBA Data: | APPS.BENBV_CWB_PERSON_INFO_V |
SELECT CPI.EFFECTIVE_DATE
, CPI.FULL_NAME
, CPI.BRIEF_NAME
, CPI.CUSTOM_NAME
, CPI.SUPERVISOR_FULL_NAME
, CPI.SUPERVISOR_BRIEF_NAME
, CPI.SUPERVISOR_CUSTOM_NAME
, CPI.LEGISLATION_CODE
, CPI.YEARS_EMPLOYED
, CPI.YEARS_IN_JOB
, CPI.YEARS_IN_POSITION
, CPI.YEARS_IN_GRADE
, CPI.EMPLOYEE_NUMBER
, CPI.START_DATE
, CPI.ORIGINAL_START_DATE
, CPI.ADJUSTED_SVC_DATE
, CPI.BASE_SALARY
, CPI.BASE_SALARY_CHANGE_DATE
, CPI.PAYROLL_NAME
, CPI.PERFORMANCE_RATING
, CPI.PERFORMANCE_RATING_TYPE
, CPI.PERFORMANCE_RATING_DATE
, CPI.GRADE_ANNULIZATION_FACTOR
, CPI.PAY_ANNULIZATION_FACTOR
, CPI.GRD_MIN_VAL
, CPI.GRD_MAX_VAL
, CPI.GRD_MID_POINT
, CPI.EMP_CATEGORY
, CPI.CHANGE_REASON
, CPI.NORMAL_HOURS
, CPI.EMAIL_ADDRESS
, CPI.CUSTOM_SEGMENT1
, CPI.CUSTOM_SEGMENT2
, CPI.CUSTOM_SEGMENT3
, CPI.CUSTOM_SEGMENT4
, CPI.CUSTOM_SEGMENT5
, CPI.CUSTOM_SEGMENT6
, CPI.CUSTOM_SEGMENT7
, CPI.CUSTOM_SEGMENT8
, CPI.CUSTOM_SEGMENT9
, CPI.CUSTOM_SEGMENT10
, CPI.WS_COMMENTS
, CPI.FREQUENCY
, CPI.GRD_QUARTILE
, CPI.GRD_COMPARATIO
, CPI.CUSTOM_SEGMENT11
, CPI.CUSTOM_SEGMENT12
, CPI.CUSTOM_SEGMENT13
, CPI.CUSTOM_SEGMENT14
, CPI.CUSTOM_SEGMENT15
, CPI.PEOPLE_GROUP_NAME
, CPI.PEOPLE_GROUP_SEGMENT1
, CPI.PEOPLE_GROUP_SEGMENT2
, CPI.PEOPLE_GROUP_SEGMENT3
, CPI.PEOPLE_GROUP_SEGMENT4
, CPI.PEOPLE_GROUP_SEGMENT5
, CPI.PEOPLE_GROUP_SEGMENT6
, CPI.PEOPLE_GROUP_SEGMENT7
, CPI.PEOPLE_GROUP_SEGMENT8
, CPI.PEOPLE_GROUP_SEGMENT9
, CPI.PEOPLE_GROUP_SEGMENT10
, CPI.PEOPLE_GROUP_SEGMENT11
, CPI.BASE_SALARY_FREQUENCY
, CPI.NEW_ASSGN_OVN
, CPI.FEEDBACK_COMMENTS
, CPI.FEEDBACK_DATE
, CPI.FEEDBACK_RATING
, CPI.ASS_ATTRIBUTE1
, CPI.ASS_ATTRIBUTE10
, CPI.ASS_ATTRIBUTE11
, CPI.ASS_ATTRIBUTE12
, CPI.ASS_ATTRIBUTE13
, CPI.ASS_ATTRIBUTE14
, CPI.ASS_ATTRIBUTE15
, CPI.ASS_ATTRIBUTE16
, CPI.ASS_ATTRIBUTE17
, CPI.ASS_ATTRIBUTE18
, CPI.ASS_ATTRIBUTE19
, CPI.ASS_ATTRIBUTE2
, CPI.ASS_ATTRIBUTE20
, CPI.ASS_ATTRIBUTE21
, CPI.ASS_ATTRIBUTE22
, CPI.ASS_ATTRIBUTE23
, CPI.ASS_ATTRIBUTE24
, CPI.ASS_ATTRIBUTE25
, CPI.ASS_ATTRIBUTE26
, CPI.ASS_ATTRIBUTE27
, CPI.ASS_ATTRIBUTE28
, CPI.ASS_ATTRIBUTE29
, CPI.ASS_ATTRIBUTE3
, CPI.ASS_ATTRIBUTE30
, CPI.ASS_ATTRIBUTE4
, CPI.ASS_ATTRIBUTE5
, CPI.ASS_ATTRIBUTE6
, CPI.ASS_ATTRIBUTE7
, CPI.ASS_ATTRIBUTE8
, CPI.ASS_ATTRIBUTE9
, CPI.ASS_ATTRIBUTE_CATEGORY
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_CWB_PERSON_INFO:CPI'
, /* CODES */ CPI.POST_PROCESS_STAT_CD
, HR_BIS.BIS_DECODE_LOOKUP('LOOKUP_NOT_FOUND'
, CPI.POST_PROCESS_STAT_CD)
, /* ID COLUMNS */ CPI.GROUP_PER_IN_LER_ID
, CPI.ASSIGNMENT_ID
, CPI.PERSON_ID
, CPI.BUSINESS_GROUP_ID
, CPI.ORGANIZATION_ID
, CPI.JOB_ID
, CPI.GRADE_ID
, CPI.POSITION_ID
, CPI.PEOPLE_GROUP_ID
, CPI.SOFT_CODING_KEYFLEX_ID
, CPI.LOCATION_ID
, CPI.PAY_RATE_ID
, CPI.ASSIGNMENT_STATUS_TYPE_ID
, CPI.NEW_PERF_REVIEW_ID
, CPI.NEW_PERF_EVENT_ID
, CPI.SUPERVISOR_ID
, /* WHO COLUMNS */ CPI.LAST_UPDATE_DATE
, CPI.LAST_UPDATED_BY
, CPI.CREATED_BY
, CPI.CREATION_DATE
FROM BEN_CWB_PERSON_INFO CPI
WHERE CPI.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CPI.BUSINESS_GROUP_ID) WITH READ ONLY