VIEW: APPS.HRFV_REVIEWS

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,peo.full_name person_name ,peo.employee_number employee_number ,asg.assignment_number assignment_number ,hr_bis.bis_decode_lookup('EMP_INTERVIEW_TYPE', evt.type) review_type ,evt.date_start review_date ,prv.review_date performance_review_date ,hr_bis.bis_decode_lookup('PERFORMANCE_RATING', prv.performance_rating) performance_rating ,prv.next_perf_review_date next_performance_review_date ,hr_bis.bis_decode_lookup('YES_NO', nvl(peo.current_employee_flag,'N')) current_employee_flag ,locT.location_code review_location ,'_DF:PER:PER_EVENTS:evt' ,evt.assignment_id assignment_id ,evt.business_group_id business_group_id ,evt.event_id employee_review_id ,evt.location_id location_id ,prv.performance_review_id performance_review_id ,peo.person_id person_id FROM hr_locations_all_tl locT ,hr_all_organization_units_tl bgrT ,per_people_x peo ,per_all_assignments_f asg ,per_events evt ,per_performance_reviews prv WHERE peo.person_id = asg.person_id AND asg.assignment_id = evt.assignment_id AND evt.event_id = prv.event_id (+) AND evt.date_start between asg.effective_start_date and asg.effective_end_date AND evt.location_id = locT.location_id (+) AND locT.language (+) = userenv('LANG') AND evt.emp_or_apl = 'E' AND evt.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND evt.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, evt.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, ASG.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, HR_BIS.BIS_DECODE_LOOKUP('EMP_INTERVIEW_TYPE'
, EVT.TYPE) REVIEW_TYPE
, EVT.DATE_START REVIEW_DATE
, PRV.REVIEW_DATE PERFORMANCE_REVIEW_DATE
, HR_BIS.BIS_DECODE_LOOKUP('PERFORMANCE_RATING'
, PRV.PERFORMANCE_RATING) PERFORMANCE_RATING
, PRV.NEXT_PERF_REVIEW_DATE NEXT_PERFORMANCE_REVIEW_DATE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, NVL(PEO.CURRENT_EMPLOYEE_FLAG
, 'N')) CURRENT_EMPLOYEE_FLAG
, LOCT.LOCATION_CODE REVIEW_LOCATION
, '_DF:PER:PER_EVENTS:EVT'
, EVT.ASSIGNMENT_ID ASSIGNMENT_ID
, EVT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EVT.EVENT_ID EMPLOYEE_REVIEW_ID
, EVT.LOCATION_ID LOCATION_ID
, PRV.PERFORMANCE_REVIEW_ID PERFORMANCE_REVIEW_ID
, PEO.PERSON_ID PERSON_ID
FROM HR_LOCATIONS_ALL_TL LOCT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_PEOPLE_X PEO
, PER_ALL_ASSIGNMENTS_F ASG
, PER_EVENTS EVT
, PER_PERFORMANCE_REVIEWS PRV
WHERE PEO.PERSON_ID = ASG.PERSON_ID
AND ASG.ASSIGNMENT_ID = EVT.ASSIGNMENT_ID
AND EVT.EVENT_ID = PRV.EVENT_ID (+)
AND EVT.DATE_START BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND EVT.LOCATION_ID = LOCT.LOCATION_ID (+)
AND LOCT.LANGUAGE (+) = USERENV('LANG')
AND EVT.EMP_OR_APL = 'E'
AND EVT.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND EVT.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, EVT.BUSINESS_GROUP_ID) WITH READ ONLY