VIEW: APPS.PQH_POSITION_ELEMENT_TYPES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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