View: PSBFV_PARAMETER_FORMULAS

Product:	PSB - Public Sector Budgeting
Description:
Implementation/DBA Data:	APPS.PSBFV_PARAMETER_FORMULAS

View Text

SELECT PE.NAME
, 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
, '_LA:PF.ASSIGNMENT_TYPE:FND_LOOKUPS:PSB_PARAMETER_ASSIGNMENT_TYPE:MEANING'
, PPE.NAME
, PEO.NAME
, PF.GRADE_STEP
, '_LA:PF.ELEMENT_VALUE_TYPE:FND_LOOKUPS:PSB_ELEMENT_VALUE_TYPE:MEANING'
, PF.ELEMENT_VALUE
, PA.NAME
, PF.ATTRIBUTE_VALUE
, PF.EFFECTIVE_END_DATE
, PF.EFFECTIVE_START_DATE
, 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'
, '_DF:PSB:PSB_PARAMETER_FORMULAS:PF'
, 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_PAY_ELEMENTS PPE
, PSB_PAY_ELEMENT_OPTIONS PEO
, PSB_ATTRIBUTES PA
, PSB_ENTITY PE
WHERE PF.PARAMETER_ID = PE.ENTITY_ID
AND PF.BUDGET_YEAR_TYPE_ID = BYT.BUDGET_YEAR_TYPE_ID(+)
AND PF.PAY_ELEMENT_ID = PPE.PAY_ELEMENT_ID(+)
AND PF.PAY_ELEMENT_OPTION_ID = PEO.PAY_ELEMENT_OPTION_ID(+)
AND PF.ATTRIBUTE_ID = PA.ATTRIBUTE_ID(+) WITH READ ONLY

Columns