VIEW: APPS.BENBV_CWB_PERSON_INFO_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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