VIEW: APPS.HRFV_APPRAISAL_DETAILS

Source

View Text - Preformatted

SELECT bgrT.name Business_Group_Name, orgT.name Department, apse.full_name Appraisee, appr.full_name Appraiser, mapr.full_name Main_Appraiser , apr.appraisal_date Appraisal_Date, apr.appraisal_period_start_date Appraisal_Start_Date, apr.appraisal_period_end_date Appraisal_End_Date, apr.next_appraisal_date Next_Appraisal_Date, apr.comments Appraisal_Comments, rtt.name Rating_Level_Name, rtl.step_value Step_Value, HR_BIS.BIS_DECODE_LOOKUP('APPRAISAL_TYPE',apr.type) Appraisal_Type, HR_BIS.BIS_DECODE_LOOKUP('APPRAISAL_SYSTEM_STATUS',apr.appraisal_system_status) Appraisal_Status, HR_BIS.BIS_DECODE_LOOKUP('APPRAISEE_ACCESS',apr.appraisee_access) Appraisee_Access, apr.type Appraisal_Type_Code, apr.appraisal_system_status Appraisal_Status_Code, apr.appraisee_access Appraisee_Access_Code, apr.creation_date creation_date, apr.last_update_date last_update_date, '_DF:PER:PER_APPRAISALS:APR', apr.appraisal_id Appraisal_Id, apr.business_group_id Business_Group_Id, apr.appraisal_template_id Appraisal_Template_Id, apr.appraisee_person_id Appraisee_Person_Id, apr.appraiser_person_id Appraiser_Person_Id, apr.group_initiator_id Group_Initiator_Id, apr.overall_performance_level_id Overall_Performance_Level_Id, apr.main_appraiser_id Main_Appraiser_Id, apr.assignment_id Assignment_Id, apr.event_id Event_Id, rtl.rating_scale_id rating_scale_id, rtl.competence_id competence_id, orgT.organization_id organization_id FROM per_appraisals apr , hr_all_organization_units_tl bgrT , hr_all_organization_units_tl orgT , per_people_x apse , per_people_x appr , per_people_x mapr , per_rating_levels rtl , per_rating_levels_tl rtt WHERE apr.business_group_id = bgrT.organization_id AND bgrT.language = USERENV('LANG') AND apr.assignment_organization_id = orgT.organization_id AND orgT.language = USERENV('LANG') AND apr.appraisee_person_id = apse.person_id AND apr.appraiser_person_id = appr.person_id AND apr.main_appraiser_id = mapr.person_id (+) AND apr.overall_performance_level_id = rtl.rating_level_id (+) AND rtl.rating_level_id = rtt.rating_level_id (+) AND rtt.language (+) = USERENV('LANG') AND apr.business_group_id = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, apr.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, ORGT.NAME DEPARTMENT
, APSE.FULL_NAME APPRAISEE
, APPR.FULL_NAME APPRAISER
, MAPR.FULL_NAME MAIN_APPRAISER
, APR.APPRAISAL_DATE APPRAISAL_DATE
, APR.APPRAISAL_PERIOD_START_DATE APPRAISAL_START_DATE
, APR.APPRAISAL_PERIOD_END_DATE APPRAISAL_END_DATE
, APR.NEXT_APPRAISAL_DATE NEXT_APPRAISAL_DATE
, APR.COMMENTS APPRAISAL_COMMENTS
, RTT.NAME RATING_LEVEL_NAME
, RTL.STEP_VALUE STEP_VALUE
, HR_BIS.BIS_DECODE_LOOKUP('APPRAISAL_TYPE'
, APR.TYPE) APPRAISAL_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('APPRAISAL_SYSTEM_STATUS'
, APR.APPRAISAL_SYSTEM_STATUS) APPRAISAL_STATUS
, HR_BIS.BIS_DECODE_LOOKUP('APPRAISEE_ACCESS'
, APR.APPRAISEE_ACCESS) APPRAISEE_ACCESS
, APR.TYPE APPRAISAL_TYPE_CODE
, APR.APPRAISAL_SYSTEM_STATUS APPRAISAL_STATUS_CODE
, APR.APPRAISEE_ACCESS APPRAISEE_ACCESS_CODE
, APR.CREATION_DATE CREATION_DATE
, APR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, '_DF:PER:PER_APPRAISALS:APR'
, APR.APPRAISAL_ID APPRAISAL_ID
, APR.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, APR.APPRAISAL_TEMPLATE_ID APPRAISAL_TEMPLATE_ID
, APR.APPRAISEE_PERSON_ID APPRAISEE_PERSON_ID
, APR.APPRAISER_PERSON_ID APPRAISER_PERSON_ID
, APR.GROUP_INITIATOR_ID GROUP_INITIATOR_ID
, APR.OVERALL_PERFORMANCE_LEVEL_ID OVERALL_PERFORMANCE_LEVEL_ID
, APR.MAIN_APPRAISER_ID MAIN_APPRAISER_ID
, APR.ASSIGNMENT_ID ASSIGNMENT_ID
, APR.EVENT_ID EVENT_ID
, RTL.RATING_SCALE_ID RATING_SCALE_ID
, RTL.COMPETENCE_ID COMPETENCE_ID
, ORGT.ORGANIZATION_ID ORGANIZATION_ID
FROM PER_APPRAISALS APR
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, PER_PEOPLE_X APSE
, PER_PEOPLE_X APPR
, PER_PEOPLE_X MAPR
, PER_RATING_LEVELS RTL
, PER_RATING_LEVELS_TL RTT
WHERE APR.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND APR.ASSIGNMENT_ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG')
AND APR.APPRAISEE_PERSON_ID = APSE.PERSON_ID
AND APR.APPRAISER_PERSON_ID = APPR.PERSON_ID
AND APR.MAIN_APPRAISER_ID = MAPR.PERSON_ID (+)
AND APR.OVERALL_PERFORMANCE_LEVEL_ID = RTL.RATING_LEVEL_ID (+)
AND RTL.RATING_LEVEL_ID = RTT.RATING_LEVEL_ID (+)
AND RTT.LANGUAGE (+) = USERENV('LANG')
AND APR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, APR.BUSINESS_GROUP_ID) WITH READ ONLY