eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PAY_BALANCE_CLASSIFICATIONS_V

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_BALANCE_CLASSIFICATIONS_V

View Text

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

Columns

Name
ROW_ID
BALANCE_CLASSIFICATION_ID
BUSINESS_GROUP_ID
LEGISLATION_CODE
BALANCE_TYPE_ID
CLASSIFICATION_ID
SCALE
LEGISLATION_SUBGROUP
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
CLASSIFICATION
ADD_OR_SUBTRACT