VIEW: APPS.PAY_ACCRUAL_PLANS_V

Source

View Text - Preformatted

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 , PAPT.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 , PAPT.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 , PAY_ACCRUAL_PLANS_TL PAPT WHERE PAP.ACCRUAL_PLAN_ID = PAPT.ACCRUAL_PLAN_ID (+) AND PAPT.LANGUAGE (+) = USERENV('LANG') AND 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 NVL( PET.EFFECTIVE_START_DATE,SES.EFFECTIVE_DATE) AND NVL(PET.EFFECTIVE_END_DATE,SES.EFFECTIVE_DATE) AND PET.ELEMENT_TYPE_ID(+) = PIV1.ELEMENT_TYPE_ID AND SES.EFFECTIVE_DATE BETWEEN NVL(PIV1.EFFECTIVE_START_DATE,SES.EFFECTIVE_DATE) AND NVL(PIV1.EFFECTIVE_END_DATE,SES.EFFECTIVE_DATE) AND PIV1.INPUT_VALUE_ID(+) = PAP.PTO_INPUT_VALUE_ID AND SES.SESSION_ID = USERENV('SESSIONID')

View Text - HTML Formatted

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
, PAPT.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
, PAPT.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
, PAY_ACCRUAL_PLANS_TL PAPT
WHERE PAP.ACCRUAL_PLAN_ID = PAPT.ACCRUAL_PLAN_ID (+)
AND PAPT.LANGUAGE (+) = USERENV('LANG')
AND 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 NVL( PET.EFFECTIVE_START_DATE
, SES.EFFECTIVE_DATE)
AND NVL(PET.EFFECTIVE_END_DATE
, SES.EFFECTIVE_DATE)
AND PET.ELEMENT_TYPE_ID(+) = PIV1.ELEMENT_TYPE_ID
AND SES.EFFECTIVE_DATE BETWEEN NVL(PIV1.EFFECTIVE_START_DATE
, SES.EFFECTIVE_DATE)
AND NVL(PIV1.EFFECTIVE_END_DATE
, SES.EFFECTIVE_DATE)
AND PIV1.INPUT_VALUE_ID(+) = PAP.PTO_INPUT_VALUE_ID
AND SES.SESSION_ID = USERENV('SESSIONID')