VIEW: APPS.PSBFV_PARAMETER_FORMULAS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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