VIEW: APPS.PSBBV_PARAMETER_FORMULAS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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