View: PAY_GB_BALANCES_V

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

View Text

SELECT BAL_ASSACT.ASSIGNMENT_ID
, BAL_ASSACT.ASSIGNMENT_ACTION_ID
, BAL_ASSACT.ACTION_SEQUENCE
, BACT.EFFECTIVE_DATE
, BACT.BUSINESS_GROUP_ID
, DB.BALANCE_TYPE_ID
, DB.DEFINED_BALANCE_ID
, DIM.DIMENSION_NAME
, DIM.BALANCE_DIMENSION_ID
, DBI.USER_NAME ITEM_NAME
, HR_GBBAL.BALANCE(ASSIGNMENT_ACTION_ID
, DB.DEFINED_BALANCE_ID) RESULT_VALUE
FROM PAY_ASSIGNMENT_ACTIONS BAL_ASSACT
, PAY_PAYROLL_ACTIONS BACT
, FF_DATABASE_ITEMS DBI
, FF_USER_ENTITIES UE
, PAY_DEFINED_BALANCES DB
, PAY_BALANCE_DIMENSIONS DIM
WHERE UE.USER_ENTITY_ID = DBI.USER_ENTITY_ID AND UE.CREATOR_TYPE = 'B' AND BACT.BUSINESS_GROUP_ID = NVL(UE.BUSINESS_GROUP_ID
, BACT.BUSINESS_GROUP_ID) AND UE.CREATOR_ID = DB.DEFINED_BALANCE_ID AND DIM.BALANCE_DIMENSION_ID = DB.BALANCE_DIMENSION_ID AND BACT.PAYROLL_ACTION_ID = BAL_ASSACT.PAYROLL_ACTION_ID

Columns