VIEW: APPS.HRBV_ACCRUAL_PLANS_V

Source

View Text - Preformatted

SELECT PAP.ACCRUAL_PLAN_NAME, PAP.ACCRUAL_CATEGORY, HR_BIS.BIS_DECODE_LOOKUP('US_PTO_ACCRUAL',PAP.ACCRUAL_CATEGORY), PAP.ACCRUAL_START, HR_BIS.BIS_DECODE_LOOKUP('US_ACCRUAL_START_TYPE',PAP.ACCRUAL_START), PAP.ACCRUAL_UNITS_OF_MEASURE, HR_BIS.BIS_DECODE_LOOKUP('HOURS_OR_DAYS',PAP.ACCRUAL_UNITS_OF_MEASURE), PAP.INELIGIBLE_PERIOD_LENGTH, PAP.INELIGIBLE_PERIOD_TYPE, HR_BIS.BIS_DECODE_LOOKUP('PROC_PERIOD_TYPE',PAP.INELIGIBLE_PERIOD_TYPE), PAP.DESCRIPTION, 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, HR_API.RETURN_LEGISLATION_CODE(PAP.BUSINESS_GROUP_ID), PAP.ACCRUAL_PLAN_ID, PAP.BUSINESS_GROUP_ID, PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID, PAP.PTO_INPUT_VALUE_ID, PAP.CO_FORMULA_ID, PAP.CO_INPUT_VALUE_ID, PAP.CO_DATE_INPUT_VALUE_ID, PAP.CO_EXP_DATE_INPUT_VALUE_ID, PAP.RESIDUAL_INPUT_VALUE_ID, PAP.RESIDUAL_DATE_INPUT_VALUE_ID, PAP.ACCRUAL_FORMULA_ID, PAP.INELIGIBILITY_FORMULA_ID, PAP.PAYROLL_FORMULA_ID, PAP.DEFINED_BALANCE_ID, PAP.TAGGING_ELEMENT_TYPE_ID, PAP.BALANCE_ELEMENT_TYPE_ID, PAP.LAST_UPDATE_DATE, PAP.LAST_UPDATED_BY, PAP.CREATED_BY, PAP.CREATION_DATE, CASE WHEN PAP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PAP.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PAY_ACCRUAL_PLANS PAP WITH READ ONLY

View Text - HTML Formatted

SELECT PAP.ACCRUAL_PLAN_NAME
, PAP.ACCRUAL_CATEGORY
, HR_BIS.BIS_DECODE_LOOKUP('US_PTO_ACCRUAL'
, PAP.ACCRUAL_CATEGORY)
, PAP.ACCRUAL_START
, HR_BIS.BIS_DECODE_LOOKUP('US_ACCRUAL_START_TYPE'
, PAP.ACCRUAL_START)
, PAP.ACCRUAL_UNITS_OF_MEASURE
, HR_BIS.BIS_DECODE_LOOKUP('HOURS_OR_DAYS'
, PAP.ACCRUAL_UNITS_OF_MEASURE)
, PAP.INELIGIBLE_PERIOD_LENGTH
, PAP.INELIGIBLE_PERIOD_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('PROC_PERIOD_TYPE'
, PAP.INELIGIBLE_PERIOD_TYPE)
, PAP.DESCRIPTION
, 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
, HR_API.RETURN_LEGISLATION_CODE(PAP.BUSINESS_GROUP_ID)
, PAP.ACCRUAL_PLAN_ID
, PAP.BUSINESS_GROUP_ID
, PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID
, PAP.PTO_INPUT_VALUE_ID
, PAP.CO_FORMULA_ID
, PAP.CO_INPUT_VALUE_ID
, PAP.CO_DATE_INPUT_VALUE_ID
, PAP.CO_EXP_DATE_INPUT_VALUE_ID
, PAP.RESIDUAL_INPUT_VALUE_ID
, PAP.RESIDUAL_DATE_INPUT_VALUE_ID
, PAP.ACCRUAL_FORMULA_ID
, PAP.INELIGIBILITY_FORMULA_ID
, PAP.PAYROLL_FORMULA_ID
, PAP.DEFINED_BALANCE_ID
, PAP.TAGGING_ELEMENT_TYPE_ID
, PAP.BALANCE_ELEMENT_TYPE_ID
, PAP.LAST_UPDATE_DATE
, PAP.LAST_UPDATED_BY
, PAP.CREATED_BY
, PAP.CREATION_DATE
, CASE WHEN PAP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PAP.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_ACCRUAL_PLANS PAP WITH READ ONLY