View: PSBFV_DEFAULT_ASSIGNMENTS

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

View Text

SELECT PDR.NAME
, '_LA:PDA.ASSIGNMENT_TYPE:FND_LOOKUPS:PSB_ASSIGNMENT_TYPE:MEANING'
, PA.NAME
, PDA.ATTRIBUTE_VALUE
, PE.NAME
, '_LA:PDA.PAY_BASIS:FND_LOOKUPS:PSB_PAY_BASIS:MEANING'
, '_LA:PE.ELEMENT_VALUE_TYPE:FND_LOOKUPS:PSB_ELEMENT_VALUE_TYPE:MEANING'
, PDA.ELEMENT_VALUE
, PDA.CURRENCY_CODE
, PEO.GRADE_STEP
, PDA.DEFAULT_ASSIGNMENT_ID
, PDA.DEFAULT_RULE_ID
, PDA.ATTRIBUTE_ID
, PDA.ATTRIBUTE_VALUE_ID
, PDA.PAY_ELEMENT_ID
, PDA.PAY_ELEMENT_OPTION_ID
, PDA.LAST_UPDATE_DATE
, PDA.LAST_UPDATED_BY
, PDA.CREATED_BY
, PDA.CREATION_DATE
FROM PSB_DEFAULT_ASSIGNMENTS PDA
, PSB_DEFAULTS PDR
, PSB_ATTRIBUTES PA
, PSB_PAY_ELEMENTS PE
, PSB_PAY_ELEMENT_OPTIONS PEO
WHERE PDA.DEFAULT_RULE_ID = PDR.DEFAULT_RULE_ID
AND PDA.ASSIGNMENT_TYPE = 'ATTRIBUTE'
AND PDA.ATTRIBUTE_ID = PA.ATTRIBUTE_ID
AND PDA.PAY_ELEMENT_ID = PE.PAY_ELEMENT_ID(+)
AND PDA.PAY_ELEMENT_OPTION_ID = PEO.PAY_ELEMENT_OPTION_ID(+) UNION SELECT PDR.NAME
, '_LA:PDA.ASSIGNMENT_TYPE:FND_LOOKUPS:PSB_ASSIGNMENT_TYPE:MEANING'
, PA.NAME
, PDA.ATTRIBUTE_VALUE
, PE.NAME
, '_LA:PDA.PAY_BASIS:FND_LOOKUPS:PSB_PAY_BASIS:MEANING'
, '_LA:PE.ELEMENT_VALUE_TYPE:FND_LOOKUPS:PSB_ELEMENT_VALUE_TYPE:MEANING'
, PDA.ELEMENT_VALUE
, PDA.CURRENCY_CODE
, PEO.GRADE_STEP
, PDA.DEFAULT_ASSIGNMENT_ID
, PDA.DEFAULT_RULE_ID
, PDA.ATTRIBUTE_ID
, PDA.ATTRIBUTE_VALUE_ID
, PDA.PAY_ELEMENT_ID
, PDA.PAY_ELEMENT_OPTION_ID
, PDA.LAST_UPDATE_DATE
, PDA.LAST_UPDATED_BY
, PDA.CREATED_BY
, PDA.CREATION_DATE
FROM PSB_DEFAULT_ASSIGNMENTS PDA
, PSB_DEFAULTS PDR
, PSB_ATTRIBUTES PA
, PSB_PAY_ELEMENTS PE
, PSB_PAY_ELEMENT_OPTIONS PEO
WHERE PDA.DEFAULT_RULE_ID = PDR.DEFAULT_RULE_ID
AND PDA.ASSIGNMENT_TYPE = 'ELEMENT'
AND PDA.PAY_ELEMENT_ID = PE.PAY_ELEMENT_ID
AND PDA.ATTRIBUTE_ID = PA.ATTRIBUTE_ID(+)
AND PDA.PAY_ELEMENT_OPTION_ID = PEO.PAY_ELEMENT_OPTION_ID(+) WITH READ ONLY

Columns