VIEW: APPS.HRFV_PROBATIONS

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,pp.full_name person_name ,pps.date_start probation_start_date ,hr_discoverer.check_end_date(asg.date_probation_end) probation_end_date ,hr_bis.bis_decode_lookup('FREQUENCY',asg.probation_unit) probation_units ,asg.probation_period probation_length ,sup.full_name supervisor_name ,sup.employee_number supervisor_number ,orgT.name organization_name ,asg.assignment_number assignment_number ,hr_bis.bis_decode_lookup('YES_NO',asg.primary_flag) primary_flag ,asg.assignment_id assignment_id ,pp.business_group_id business_group_id ,pp.person_id person_id FROM hr_all_organization_units_tl orgT ,hr_all_organization_units_tl bgrT ,per_all_people_f sup ,per_periods_of_service pps ,per_people_x pp ,per_all_assignments_f asg WHERE asg.person_id = pp.person_id AND asg.organization_id = orgT.organization_id AND orgT.language = userenv('LANG') AND (asg.probation_unit IS NOT NULL OR asg.date_probation_end IS NOT NULL) AND asg.supervisor_id = sup.person_id(+) AND pp.person_id = pps.person_id AND asg.period_of_service_id = pps.period_of_service_id AND pp.employee_number IS NOT NULL AND asg.assignment_type = 'E' AND TRUNC(sysdate) BETWEEN sup.effective_start_date (+) AND sup.effective_end_date (+) AND TRUNC(sysdate) BETWEEN asg.effective_start_date AND asg.effective_end_date AND pp.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND pp.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,pp.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PP.FULL_NAME PERSON_NAME
, PPS.DATE_START PROBATION_START_DATE
, HR_DISCOVERER.CHECK_END_DATE(ASG.DATE_PROBATION_END) PROBATION_END_DATE
, HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY'
, ASG.PROBATION_UNIT) PROBATION_UNITS
, ASG.PROBATION_PERIOD PROBATION_LENGTH
, SUP.FULL_NAME SUPERVISOR_NAME
, SUP.EMPLOYEE_NUMBER SUPERVISOR_NUMBER
, ORGT.NAME ORGANIZATION_NAME
, ASG.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ASG.PRIMARY_FLAG) PRIMARY_FLAG
, ASG.ASSIGNMENT_ID ASSIGNMENT_ID
, PP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PP.PERSON_ID PERSON_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_ALL_PEOPLE_F SUP
, PER_PERIODS_OF_SERVICE PPS
, PER_PEOPLE_X PP
, PER_ALL_ASSIGNMENTS_F ASG
WHERE ASG.PERSON_ID = PP.PERSON_ID
AND ASG.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG')
AND (ASG.PROBATION_UNIT IS NOT NULL OR ASG.DATE_PROBATION_END IS NOT NULL)
AND ASG.SUPERVISOR_ID = SUP.PERSON_ID(+)
AND PP.PERSON_ID = PPS.PERSON_ID
AND ASG.PERIOD_OF_SERVICE_ID = PPS.PERIOD_OF_SERVICE_ID
AND PP.EMPLOYEE_NUMBER IS NOT NULL
AND ASG.ASSIGNMENT_TYPE = 'E'
AND TRUNC(SYSDATE) BETWEEN SUP.EFFECTIVE_START_DATE (+)
AND SUP.EFFECTIVE_END_DATE (+)
AND TRUNC(SYSDATE) BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND PP.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND PP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PP.BUSINESS_GROUP_ID) WITH READ ONLY