View: PQH_POSITION_ELEMENT_TYPES_V

Product:	PQH - Public Sector HR
Description:	Position, Elements, Element Types
Implementation/DBA Data:	APPS.PQH_POSITION_ELEMENT_TYPES_V

View Text

SELECT PET.ELEMENT_NAME ELEMENT_NAME
, BEL.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(BDT.POSITION_ID) POSITION_NAME
, BDT.POSITION_ID POSITION_ID
, BGT.BUDGET_UNIT1 BUDGET_MEASUREMENT_TYPE
, BGT.BUDGET_UNIT1_ID BUDGET_UNIT_ID
FROM PQH_BUDGETS_V BGT
, PQH_BUDGET_VERSIONS BVR
, PQH_BUDGET_DETAILS BDT
, PQH_BUDGET_PERIODS BPR
, PQH_BUDGET_SETS BST
, PQH_BUDGET_ELEMENTS BEL
, PAY_ELEMENT_TYPES PET
WHERE BGT.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, BGT.BUSINESS_GROUP_ID )
AND HR_GENERAL.EFFECTIVE_DATE BETWEEN BVR.DATE_FROM
AND BVR.DATE_TO
AND BGT.BUDGET_ID = BVR.BUDGET_ID
AND BPR.BUDGET_UNIT1_VALUE IS NOT NULL
AND BVR.BUDGET_VERSION_ID = BDT.BUDGET_VERSION_ID
AND BGT.BUDGETED_ENTITY_CD='POSITION'
AND BDT.BUDGET_DETAIL_ID = BPR.BUDGET_DETAIL_ID
AND BPR.BUDGET_PERIOD_ID = BST.BUDGET_PERIOD_ID
AND BST.BUDGET_SET_ID = BEL.BUDGET_SET_ID
AND BEL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID GROUP BY PET.ELEMENT_NAME
, BEL.ELEMENT_TYPE_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(BDT.POSITION_ID)
, BDT.POSITION_ID
, BGT.BUDGET_UNIT1
, BGT.BUDGET_UNIT1_ID UNION SELECT PET.ELEMENT_NAME ELEMENT_NAME
, BEL.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(BDT.POSITION_ID) POSITION_NAME
, BDT.POSITION_ID POSITION_ID
, BGT.BUDGET_UNIT2 BUDGET_MEASUREMENT_TYPE
, BGT.BUDGET_UNIT2_ID BUDGET_UNIT_ID
FROM PQH_BUDGETS_V BGT
, PQH_BUDGET_VERSIONS BVR
, PQH_BUDGET_DETAILS BDT
, PQH_BUDGET_PERIODS BPR
, PQH_BUDGET_SETS BST
, PQH_BUDGET_ELEMENTS BEL
, PAY_ELEMENT_TYPES PET
WHERE BGT.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, BGT.BUSINESS_GROUP_ID )
AND HR_GENERAL.EFFECTIVE_DATE BETWEEN BVR.DATE_FROM
AND BVR.DATE_TO
AND BGT.BUDGET_ID = BVR.BUDGET_ID
AND BPR.BUDGET_UNIT2_VALUE IS NOT NULL
AND BVR.BUDGET_VERSION_ID = BDT.BUDGET_VERSION_ID
AND BDT.POSITION_ID IS NOT NULL
AND BGT.BUDGETED_ENTITY_CD='POSITION'
AND BDT.BUDGET_DETAIL_ID = BPR.BUDGET_DETAIL_ID
AND BPR.BUDGET_PERIOD_ID = BST.BUDGET_PERIOD_ID
AND BST.BUDGET_SET_ID = BEL.BUDGET_SET_ID
AND BEL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID GROUP BY PET.ELEMENT_NAME
, BEL.ELEMENT_TYPE_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(BDT.POSITION_ID)
, BDT.POSITION_ID
, BGT.BUDGET_UNIT2
, BGT.BUDGET_UNIT2_ID UNION SELECT PET.ELEMENT_NAME ELEMENT_NAME
, BEL.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(BDT.POSITION_ID) POSITION_NAME
, BDT.POSITION_ID POSITION_ID
, BGT.BUDGET_UNIT3 BUDGET_MEASUREMENT_TYPE
, BGT.BUDGET_UNIT3_ID BUDGET_UNIT_ID
FROM PQH_BUDGETS_V BGT
, PQH_BUDGET_VERSIONS BVR
, PQH_BUDGET_DETAILS BDT
, PQH_BUDGET_PERIODS BPR
, PQH_BUDGET_SETS BST
, PQH_BUDGET_ELEMENTS BEL
, PAY_ELEMENT_TYPES PET
WHERE BGT.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, BGT.BUSINESS_GROUP_ID )
AND HR_GENERAL.EFFECTIVE_DATE BETWEEN BVR.DATE_FROM
AND BVR.DATE_TO
AND BGT.BUDGET_ID = BVR.BUDGET_ID
AND BPR.BUDGET_UNIT3_VALUE IS NOT NULL
AND BVR.BUDGET_VERSION_ID = BDT.BUDGET_VERSION_ID
AND BDT.POSITION_ID IS NOT NULL
AND BGT.BUDGETED_ENTITY_CD='POSITION'
AND BDT.BUDGET_DETAIL_ID = BPR.BUDGET_DETAIL_ID
AND BPR.BUDGET_PERIOD_ID = BST.BUDGET_PERIOD_ID
AND BST.BUDGET_SET_ID = BEL.BUDGET_SET_ID
AND BEL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID GROUP BY PET.ELEMENT_NAME
, BEL.ELEMENT_TYPE_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(BDT.POSITION_ID)
, BDT.POSITION_ID
, BGT.BUDGET_UNIT3
, BGT.BUDGET_UNIT3_ID

Columns