View: PAY_ACCRUAL_PLANS_V

Product:	PAY - Payroll
Description:	Paid time off accrual plans.
Implementation/DBA Data:	APPS.PAY_ACCRUAL_PLANS_V

View Text

SELECT PAP.ROWID
, PAP.ACCRUAL_PLAN_ID
, PAP.BUSINESS_GROUP_ID
, PAP.OBJECT_VERSION_NUMBER
, PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID
, PAP.ACCRUAL_FORMULA_ID
, PET.ELEMENT_TYPE_ID
, PAP.PTO_INPUT_VALUE_ID
, PETTL.ELEMENT_NAME
, PIV1TL.NAME
, PAP.CO_FORMULA_ID
, PAP.CO_INPUT_VALUE_ID
, PAP.CO_DATE_INPUT_VALUE_ID
, PAP.CO_EXP_DATE_INPUT_VALUE_ID
, PIV2.ELEMENT_TYPE_ID
, PAP.RESIDUAL_INPUT_VALUE_ID
, PAP.RESIDUAL_DATE_INPUT_VALUE_ID
, PIV3.ELEMENT_TYPE_ID
, PAP.ACCRUAL_CATEGORY
, HRL1.MEANING
, PAP.ACCRUAL_PLAN_NAME
, PAP.ACCRUAL_START
, HRL2.MEANING
, PAP.ACCRUAL_UNITS_OF_MEASURE
, HRL3.MEANING
, PAP.INELIGIBLE_PERIOD_LENGTH
, PAP.INELIGIBLE_PERIOD_TYPE
, HRL4.MEANING
, PAP.DESCRIPTION
, FF1.FORMULA_NAME
, FF2.FORMULA_NAME
, PAP.INELIGIBILITY_FORMULA_ID
, FF3.FORMULA_NAME
, FF4.FORMULA_ID
, FF4.FORMULA_NAME
, PAP.DEFINED_BALANCE_ID
, PAP.TAGGING_ELEMENT_TYPE_ID
, PAP.BALANCE_ELEMENT_TYPE_ID
, PAP.INFORMATION_CATEGORY
, PAP.INFORMATION1
, PAP.INFORMATION2
, PAP.INFORMATION3
, PAP.INFORMATION4
, PAP.INFORMATION5
, PAP.INFORMATION6
, PAP.INFORMATION7
, PAP.INFORMATION8
, PAP.INFORMATION9
, PAP.INFORMATION10
, PAP.INFORMATION11
, PAP.INFORMATION12
, PAP.INFORMATION13
, PAP.INFORMATION14
, PAP.INFORMATION15
, PAP.INFORMATION16
, PAP.INFORMATION17
, PAP.INFORMATION18
, PAP.INFORMATION19
, PAP.INFORMATION20
, PAP.INFORMATION21
, PAP.INFORMATION22
, PAP.INFORMATION23
, PAP.INFORMATION24
, PAP.INFORMATION25
, PAP.INFORMATION26
, PAP.INFORMATION27
, PAP.INFORMATION28
, PAP.INFORMATION29
, PAP.INFORMATION30
FROM HR_LOOKUPS HRL1
, HR_LOOKUPS HRL2
, HR_LOOKUPS HRL3
, HR_LOOKUPS HRL4
, PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_ELEMENT_TYPES_F PET
, PAY_INPUT_VALUES_F_TL PIV1TL
, PAY_INPUT_VALUES_F PIV1
, PAY_INPUT_VALUES_F PIV2
, PAY_INPUT_VALUES_F PIV3
, FND_SESSIONS SES
, FF_FORMULAS_F FF1
, FF_FORMULAS_F FF2
, FF_FORMULAS_F FF3
, FF_FORMULAS_F FF4
, PAY_ACCRUAL_PLANS PAP
WHERE PET.ELEMENT_TYPE_ID = PETTL.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE = USERENV('LANG')
AND PIV1.INPUT_VALUE_ID = PIV1TL.INPUT_VALUE_ID
AND PIV1TL.LANGUAGE = USERENV('LANG')
AND HRL1.LOOKUP_CODE = PAP.ACCRUAL_CATEGORY
AND HRL1.LOOKUP_TYPE = 'US_PTO_ACCRUAL'
AND HRL2.LOOKUP_CODE (+) = PAP.ACCRUAL_START
AND HRL2.LOOKUP_TYPE (+) = 'US_ACCRUAL_START_TYPE'
AND HRL3.LOOKUP_CODE = PAP.ACCRUAL_UNITS_OF_MEASURE
AND HRL3.LOOKUP_TYPE = 'HOURS_OR_DAYS'
AND HRL4.LOOKUP_CODE (+) = PAP.INELIGIBLE_PERIOD_TYPE
AND HRL4.LOOKUP_TYPE (+) = 'PROC_PERIOD_TYPE'
AND FF1.FORMULA_ID = PAP.ACCRUAL_FORMULA_ID
AND SES.EFFECTIVE_DATE BETWEEN FF1.EFFECTIVE_START_DATE
AND FF1.EFFECTIVE_END_DATE
AND FF2.FORMULA_ID = PAP.CO_FORMULA_ID
AND SES.EFFECTIVE_DATE BETWEEN FF2.EFFECTIVE_START_DATE
AND FF2.EFFECTIVE_END_DATE
AND FF3.FORMULA_ID(+) = PAP.INELIGIBILITY_FORMULA_ID
AND SES.EFFECTIVE_DATE BETWEEN NVL(FF3.EFFECTIVE_START_DATE
, SES.EFFECTIVE_DATE)
AND NVL(FF3.EFFECTIVE_END_DATE
, SES.EFFECTIVE_DATE)
AND FF4.FORMULA_ID(+) = PAP.PAYROLL_FORMULA_ID
AND SES.EFFECTIVE_DATE BETWEEN NVL(FF4.EFFECTIVE_START_DATE
, SES.EFFECTIVE_DATE)
AND NVL(FF4.EFFECTIVE_END_DATE
, SES.EFFECTIVE_DATE)
AND SES.EFFECTIVE_DATE BETWEEN PIV3.EFFECTIVE_START_DATE
AND PIV3.EFFECTIVE_END_DATE
AND PIV3.INPUT_VALUE_ID = PAP.RESIDUAL_INPUT_VALUE_ID
AND SES.EFFECTIVE_DATE BETWEEN PIV2.EFFECTIVE_START_DATE
AND PIV2.EFFECTIVE_END_DATE
AND PIV2.INPUT_VALUE_ID = PAP.CO_INPUT_VALUE_ID
AND SES.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PET.ELEMENT_TYPE_ID = PIV1.ELEMENT_TYPE_ID
AND SES.EFFECTIVE_DATE BETWEEN PIV1.EFFECTIVE_START_DATE
AND PIV1.EFFECTIVE_END_DATE
AND PIV1.INPUT_VALUE_ID = PAP.PTO_INPUT_VALUE_ID
AND SES.SESSION_ID = USERENV('SESSIONID')

Columns