View: HRFV_ACCRUAL_PLAN_ENROLLMENTS

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, PAP.ACCRUAL_PLAN_NAME ACCRUAL_PLAN_NAME
, HR_BIS.BIS_DECODE_LOOKUP('US_PTO_ACCRUAL'
, PAP.ACCRUAL_CATEGORY) ACCRUAL_CATEGORY
, HR_BIS.BIS_DECODE_LOOKUP('US_ACCRUAL_START_TYPE'
, PAP.ACCRUAL_START) ACCRUAL_START_RULE
, HR_BIS.BIS_DECODE_LOOKUP('HOURS_OR_DAYS'
, PAP.ACCRUAL_UNITS_OF_MEASURE) ACCRUAL_UNITS
, PEE.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, HR_DISCOVERER.CHECK_END_DATE(PEE.EFFECTIVE_END_DATE) EFFECTIVE_END_DATE
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, NVL(FND_DATE.CANONICAL_TO_DATE(PEV.SCREEN_ENTRY_VALUE)
, PPS.DATE_START) CONTINUOUS_SERVICE_DATE
, PAB.ANNUAL_RATE ANNUAL_RATE
, ASS.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, ORGT.NAME ORGANIZATION_NAME
, JOB.NAME JOB_NAME
, POS.NAME POSITION_NAME
, GRD.NAME GRADE_NAME
, LOCT.LOCATION_CODE LOCATION_NAME
, PAY.PAYROLL_NAME PAYROLL_NAME
, PAP.ACCRUAL_PLAN_ID ACCRUAL_PLAN_ID
, PEE.ASSIGNMENT_ID ASSIGNMENT_ID
, PAP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID ELEMENT_ENTRY_ID
, GRD.GRADE_ID GRADE_ID
, JOB.JOB_ID JOB_ID
, ASS.PAYROLL_ID PAYROLL_ID
, ASS.PERSON_ID PERSON_ID
, POS.POSITION_ID POSITION_ID
FROM PER_PEOPLE_X PEO
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_JOBS JOB
, PER_ALL_POSITIONS POS
, PER_GRADES GRD
, HR_LOCATIONS_ALL_TL LOCT
, PAY_PAYROLLS_X PAY
, PER_PERIODS_OF_SERVICE PPS
, PER_ASSIGNMENTS_X ASS
, PAY_ELEMENT_ENTRIES_X PEE
, PAY_ELEMENT_LINKS_X PEL
, PAY_ELEMENT_ENTRY_VALUES_X PEV
, PAY_ELEMENT_TYPES_X PET
, PAY_INPUT_VALUES_X PIV
, PAY_ACCRUAL_BANDS PAB
, PAY_ACCRUAL_PLANS PAP
WHERE PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PEE.ASSIGNMENT_ID = ASS.ASSIGNMENT_ID
AND PEL.ELEMENT_LINK_ID = PEE.ELEMENT_LINK_ID
AND PET.ELEMENT_TYPE_ID = PEL.ELEMENT_TYPE_ID
AND TRUNC(SYSDATE) >= (SELECT MIN(PTP2.START_DATE)
FROM PER_TIME_PERIODS PTP2
WHERE PTP2.PAYROLL_ID = ASS.PAYROLL_ID
AND PTP2.START_DATE >= (SELECT MIN(PEE1.EFFECTIVE_START_DATE)
FROM PAY_ELEMENT_ENTRIES_F PEE1
WHERE PEE1.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID))
AND PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_ID
AND PIV.DISPLAY_SEQUENCE = 1
AND PIV.NAME <> 'PAY VALUE'
AND PIV.INPUT_VALUE_ID = PEV.INPUT_VALUE_ID
AND PEV.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND ASS.PERIOD_OF_SERVICE_ID = PPS.PERIOD_OF_SERVICE_ID
AND PAP.ACCRUAL_PLAN_ID = PAB.ACCRUAL_PLAN_ID
AND (TRUNC(ABS(MONTHS_BETWEEN(NVL( FND_DATE.CANONICAL_TO_DATE( DECODE(SUBSTR(PIV.UOM
, 1
, 1)
, 'D'
, PEV.SCREEN_ENTRY_VALUE
, NULL))
, PPS.DATE_START)
, TRUNC(SYSDATE))))/12) BETWEEN PAB.LOWER_LIMIT
AND PAB.UPPER_LIMIT
AND ASS.PERSON_ID = PEO.PERSON_ID
AND ASS.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG')
AND ASS.JOB_ID = JOB.JOB_ID(+)
AND ASS.POSITION_ID = POS.POSITION_ID(+)
AND ASS.GRADE_ID = GRD.GRADE_ID(+)
AND ASS.LOCATION_ID = LOCT.LOCATION_ID(+)
AND LOCT.LANGUAGE (+) = USERENV('LANG')
AND ASS.PAYROLL_ID = PAY.PAYROLL_ID
AND ASS.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND PAP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PAP.BUSINESS_GROUP_ID) WITH READ ONLY

Columns