VIEW: APPS.PAY_VIEW_ACCRUAL_PLANS_V

Source

View Text - Preformatted

SELECT PAP.ACCRUAL_PLAN_ID ,PAP.INFORMATION1 ,PAP.INFORMATION_CATEGORY , PAPT.ACCRUAL_PLAN_NAME , PAP.ACCRUAL_CATEGORY , HRL.MEANING , PAP.ACCRUAL_UNITS_OF_MEASURE , HRL1.MEANING , ASS.PAYROLL_ID , PAP.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID , PEE.ASSIGNMENT_ID , PEE.ELEMENT_ENTRY_ID , ASS.PERSON_ID , PIV.ELEMENT_TYPE_ID , ASS.EFFECTIVE_START_DATE , ASS.EFFECTIVE_END_DATE , PIV.EFFECTIVE_START_DATE , PIV.EFFECTIVE_END_DATE , PEE.EFFECTIVE_START_DATE , PEE.EFFECTIVE_END_DATE , PET.EFFECTIVE_START_DATE , PET.EFFECTIVE_END_DATE , PEL.EFFECTIVE_START_DATE , PEL.EFFECTIVE_END_DATE FROM HR_LOOKUPS HRL, HR_LOOKUPS HRL1, PER_ALL_ASSIGNMENTS_F ASS, PAY_ELEMENT_ENTRIES_F PEE, PAY_ELEMENT_LINKS_F PEL, PAY_ELEMENT_TYPES_F PET, PAY_ACCRUAL_PLANS PAP, PAY_ACCRUAL_PLANS_TL PAPT, PAY_INPUT_VALUES_F PIV WHERE PAP.ACCRUAL_PLAN_ID = PAPT.ACCRUAL_PLAN_ID (+) AND PAPT.LANGUAGE (+) = USERENV ('LANG') AND HRL.LOOKUP_CODE = PAP.ACCRUAL_CATEGORY AND HRL.LOOKUP_TYPE = 'US_PTO_ACCRUAL' AND HRL1.LOOKUP_CODE = PAP.ACCRUAL_UNITS_OF_MEASURE AND HRL1.LOOKUP_TYPE = 'HOURS_OR_DAYS' AND ASS.ASSIGNMENT_ID = PEE.ASSIGNMENT_ID AND PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID AND PEL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID AND PET.ELEMENT_TYPE_ID = PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID AND EXISTS ( select 'Y' from pay_net_calculation_rules NCR where NCR.accrual_plan_id = PAP.accrual_plan_id and ((ncr.absence_attendance_type_id is null and ncr.input_value_id = pap.pto_input_value_id) or (ncr.absence_attendance_type_id is not null)) AND PIV.INPUT_VALUE_ID = NCR.INPUT_VALUE_ID)

View Text - HTML Formatted

SELECT PAP.ACCRUAL_PLAN_ID
, PAP.INFORMATION1
, PAP.INFORMATION_CATEGORY
, PAPT.ACCRUAL_PLAN_NAME
, PAP.ACCRUAL_CATEGORY
, HRL.MEANING
, PAP.ACCRUAL_UNITS_OF_MEASURE
, HRL1.MEANING
, ASS.PAYROLL_ID
, PAP.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, PEE.ASSIGNMENT_ID
, PEE.ELEMENT_ENTRY_ID
, ASS.PERSON_ID
, PIV.ELEMENT_TYPE_ID
, ASS.EFFECTIVE_START_DATE
, ASS.EFFECTIVE_END_DATE
, PIV.EFFECTIVE_START_DATE
, PIV.EFFECTIVE_END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PET.EFFECTIVE_START_DATE
, PET.EFFECTIVE_END_DATE
, PEL.EFFECTIVE_START_DATE
, PEL.EFFECTIVE_END_DATE
FROM HR_LOOKUPS HRL
, HR_LOOKUPS HRL1
, PER_ALL_ASSIGNMENTS_F ASS
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_TYPES_F PET
, PAY_ACCRUAL_PLANS PAP
, PAY_ACCRUAL_PLANS_TL PAPT
, PAY_INPUT_VALUES_F PIV
WHERE PAP.ACCRUAL_PLAN_ID = PAPT.ACCRUAL_PLAN_ID (+)
AND PAPT.LANGUAGE (+) = USERENV ('LANG')
AND HRL.LOOKUP_CODE = PAP.ACCRUAL_CATEGORY
AND HRL.LOOKUP_TYPE = 'US_PTO_ACCRUAL'
AND HRL1.LOOKUP_CODE = PAP.ACCRUAL_UNITS_OF_MEASURE
AND HRL1.LOOKUP_TYPE = 'HOURS_OR_DAYS'
AND ASS.ASSIGNMENT_ID = PEE.ASSIGNMENT_ID
AND PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID
AND PEL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PET.ELEMENT_TYPE_ID = PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID
AND EXISTS ( SELECT 'Y'
FROM PAY_NET_CALCULATION_RULES NCR
WHERE NCR.ACCRUAL_PLAN_ID = PAP.ACCRUAL_PLAN_ID
AND ((NCR.ABSENCE_ATTENDANCE_TYPE_ID IS NULL
AND NCR.INPUT_VALUE_ID = PAP.PTO_INPUT_VALUE_ID) OR (NCR.ABSENCE_ATTENDANCE_TYPE_ID IS NOT NULL))
AND PIV.INPUT_VALUE_ID = NCR.INPUT_VALUE_ID)