Product: | PQH - Public Sector HR |
---|---|
Description: | Budget Commitment Elements View |
Implementation/DBA Data: | APPS.PQH_BDGT_CMMTMNT_ELMNTS_V |
SELECT BCE.BDGT_CMMTMNT_ELMNT_ID
, BGT.BUDGET_NAME
, BCE.BUDGET_ID
, PET.ELEMENT_NAME
, BCE.ELEMENT_TYPE_ID
, BCE.SALARY_BASIS_FLAG
, PIV1.NAME ELEMENT_INPUT_VALUE
, BCE.ELEMENT_INPUT_VALUE_ID
, PIV2.NAME FREQUENCY_INPUT_VALUE
, BCE.FREQUENCY_INPUT_VALUE_ID
, FML.FORMULA_NAME
, BCE.FORMULA_ID
, BCE.DFLT_ELMNT_FREQUENCY
, BCE.OVERHEAD_PERCENTAGE
, BCE.CREATED_BY
, BCE.CREATION_DATE
, BCE.LAST_UPDATED_BY
, BCE.LAST_UPDATE_DATE
, BCE.LAST_UPDATE_LOGIN
, BCE.OBJECT_VERSION_NUMBER
FROM PQH_BDGT_CMMTMNT_ELMNTS BCE
, PQH_BUDGETS BGT
, PAY_ELEMENT_TYPES_V PET
, PAY_INPUT_VALUES_V PIV1
, PAY_INPUT_VALUES_V PIV2
, FF_FORMULAS_F_V FML
WHERE BCE.BUDGET_ID = BGT.BUDGET_ID
AND BCE.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID(+)
AND BCE.ELEMENT_INPUT_VALUE_ID = PIV1.INPUT_VALUE_ID(+)
AND BCE.FREQUENCY_INPUT_VALUE_ID = PIV2.INPUT_VALUE_ID(+)
AND BCE.FORMULA_ID = FML.FORMULA_ID(+)