VIEW: APPS.PAY_BALANCE_CLASSIFICATIONS_V

Source

View Text - Preformatted

SELECT BC.ROWID ROW_ID , BC.BALANCE_CLASSIFICATION_ID , BC.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID , BC.LEGISLATION_CODE , BC.BALANCE_TYPE_ID , BC.CLASSIFICATION_ID , BC.SCALE , BC.LEGISLATION_SUBGROUP , BC.LAST_UPDATE_DATE , BC.LAST_UPDATED_BY , BC.LAST_UPDATE_LOGIN , BC.CREATED_BY , BC.CREATION_DATE , ECTL.CLASSIFICATION_NAME CLASSIFICATION , HL.MEANING ADD_OR_SUBTRACT FROM PAY_BALANCE_CLASSIFICATIONS BC, PAY_ELEMENT_CLASSIFICATIONS_TL ECTL, PAY_ELEMENT_CLASSIFICATIONS EC, HR_LOOKUPS HL WHERE EC.CLASSIFICATION_ID = ECTL.CLASSIFICATION_ID and ectl.language = userenv('LANG') and EC.CLASSIFICATION_ID = BC.CLASSIFICATION_ID AND HL.LOOKUP_TYPE = 'ADD_SUBTRACT' AND HL.LOOKUP_CODE = BC.SCALE

View Text - HTML Formatted

SELECT BC.ROWID ROW_ID
, BC.BALANCE_CLASSIFICATION_ID
, BC.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, BC.LEGISLATION_CODE
, BC.BALANCE_TYPE_ID
, BC.CLASSIFICATION_ID
, BC.SCALE
, BC.LEGISLATION_SUBGROUP
, BC.LAST_UPDATE_DATE
, BC.LAST_UPDATED_BY
, BC.LAST_UPDATE_LOGIN
, BC.CREATED_BY
, BC.CREATION_DATE
, ECTL.CLASSIFICATION_NAME CLASSIFICATION
, HL.MEANING ADD_OR_SUBTRACT
FROM PAY_BALANCE_CLASSIFICATIONS BC
, PAY_ELEMENT_CLASSIFICATIONS_TL ECTL
, PAY_ELEMENT_CLASSIFICATIONS EC
, HR_LOOKUPS HL
WHERE EC.CLASSIFICATION_ID = ECTL.CLASSIFICATION_ID
AND ECTL.LANGUAGE = USERENV('LANG')
AND EC.CLASSIFICATION_ID = BC.CLASSIFICATION_ID
AND HL.LOOKUP_TYPE = 'ADD_SUBTRACT'
AND HL.LOOKUP_CODE = BC.SCALE