View: HRFV_PROBATIONS

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_PROBATIONS

View Text

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

Columns