View: PAY_VIEW_ACCRUAL_PLANS_V

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_VIEW_ACCRUAL_PLANS_V

View Text

SELECT PAP.ACCRUAL_PLAN_ID
, PAP.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_INPUT_VALUES_F PIV
WHERE 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 PIV.INPUT_VALUE_ID = PAP.PTO_INPUT_VALUE_ID

Columns