Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSBBV_PARAMETER_FORMULAS |
SELECT PF.STEP_NUMBER
, '_LA:PF.PREFIX_OPERATOR:FND_LOOKUPS:PSB_PARAMETER_PREFIX_OPERATOR:MEANING'
, BYT.NAME
, '_LA:PF.BALANCE_TYPE:FND_LOOKUPS:PSB_BALANCE_TYPE:MEANING'
, PF.CONCATENATED_SEGMENTS
, PF.CURRENCY_CODE
, '_LA:PF.POSTFIX_OPERATOR:FND_LOOKUPS:PSB_POSTFIX_OPERATOR:MEANING'
, PF.AMOUNT
, PF.HIREDATE_BETWEEN_FROM
, PF.HIREDATE_BETWEEN_TO
, PF.ADJDATE_BETWEEN_FROM
, PF.ADJDATE_BETWEEN_TO
, PF.INCREMENT_BY
, '_LA:PF.INCREMENT_TYPE:FND_LOOKUPS:PSB_INCREMENT_TYPE:MEANING'
, '_LA:PF.ASSIGNMENT_TYPE:FND_LOOKUPS:PSB_PARAMETER_ASSIGNMENT_TYPE:MEANING'
, PF.ATTRIBUTE_VALUE
, PF.GRADE_STEP
, '_LA:PF.ELEMENT_VALUE_TYPE:FND_LOOKUPS:PSB_ELEMENT_VALUE_TYPE:MEANING'
, PF.ELEMENT_VALUE
, PF.EFFECTIVE_START_DATE
, PF.EFFECTIVE_END_DATE
, PF.PARAMETER_FORMULA_ID
, PF.PARAMETER_ID
, PF.ATTRIBUTE_ID
, PF.PAY_ELEMENT_ID
, PF.PAY_ELEMENT_OPTION_ID
, PF.LAST_UPDATE_DATE
, PF.LAST_UPDATED_BY
, PF.CREATED_BY
, PF.CREATION_DATE
FROM PSB_PARAMETER_FORMULAS PF
, PSB_BUDGET_YEAR_TYPES BYT
, PSB_ENTITY PE
WHERE PF.PARAMETER_ID = PE.ENTITY_ID
AND PF.BUDGET_YEAR_TYPE_ID = BYT.BUDGET_YEAR_TYPE_ID(+) WITH READ ONLY