[Home] [Help]
SELECT bgrt.name business_group_name ,ree.full_name reviewee_name ,ree.employee_number reviewee_employee_number ,asg.assignment_number reviewee_assignment_number ,hr_bis.bis_decode_lookup('EMP_INTERVIEW_TYPE', evt.type) review_type ,evt.date_start planned_review_date ,hr_bis.bis_decode_lookup('YES_NO',nvl(ree.current_employee_flag,'N')) reviewee_current_employee_flag ,rer.full_name reviewer_name ,rer.employee_number reviewer_employee_number ,'_DF:PER:PER_BOOKINGS:bkg' ,evt.business_group_id business_group_id ,evt.event_id employee_review_id ,bkg.booking_id employee_reviewer_id ,evt.assignment_id reviewee_assignment_id ,ree.person_id reviewee_person_id ,rer.person_id reviewer_person_id FROM hr_all_organization_units_tl bgrT ,per_all_people_f rer ,per_people_x ree ,per_all_assignments_f asg ,per_events evt ,per_bookings bkg WHERE ree.person_id = asg.person_id AND rer.person_id = bkg.person_id AND bkg.event_id = evt.event_id AND asg.assignment_id = evt.assignment_id AND evt.event_or_interview = 'I' AND evt.emp_or_apl = 'E' AND evt.date_start between asg.effective_start_date and asg.effective_end_date AND trunc(sysdate) between rer.effective_start_date and rer.effective_end_date 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
SELECT BGRT.NAME BUSINESS_GROUP_NAME
, REE.FULL_NAME REVIEWEE_NAME
, REE.EMPLOYEE_NUMBER REVIEWEE_EMPLOYEE_NUMBER
, ASG.ASSIGNMENT_NUMBER REVIEWEE_ASSIGNMENT_NUMBER
, HR_BIS.BIS_DECODE_LOOKUP('EMP_INTERVIEW_TYPE'
, EVT.TYPE) REVIEW_TYPE
, EVT.DATE_START PLANNED_REVIEW_DATE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, NVL(REE.CURRENT_EMPLOYEE_FLAG
, 'N')) REVIEWEE_CURRENT_EMPLOYEE_FLAG
, RER.FULL_NAME REVIEWER_NAME
, RER.EMPLOYEE_NUMBER REVIEWER_EMPLOYEE_NUMBER
, '_DF:PER:PER_BOOKINGS:BKG'
, EVT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EVT.EVENT_ID EMPLOYEE_REVIEW_ID
, BKG.BOOKING_ID EMPLOYEE_REVIEWER_ID
, EVT.ASSIGNMENT_ID REVIEWEE_ASSIGNMENT_ID
, REE.PERSON_ID REVIEWEE_PERSON_ID
, RER.PERSON_ID REVIEWER_PERSON_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_ALL_PEOPLE_F RER
, PER_PEOPLE_X REE
, PER_ALL_ASSIGNMENTS_F ASG
, PER_EVENTS EVT
, PER_BOOKINGS BKG
WHERE REE.PERSON_ID = ASG.PERSON_ID
AND RER.PERSON_ID = BKG.PERSON_ID
AND BKG.EVENT_ID = EVT.EVENT_ID
AND ASG.ASSIGNMENT_ID = EVT.ASSIGNMENT_ID
AND EVT.EVENT_OR_INTERVIEW = 'I'
AND EVT.EMP_OR_APL = 'E'
AND EVT.DATE_START BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN RER.EFFECTIVE_START_DATE
AND RER.EFFECTIVE_END_DATE
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
|
|
|
|