VIEW: APPS.PAY_NZ_BALANCES_V

Source

View Text - Preformatted

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_nzbal.balance ( bal_assact.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

View Text - HTML Formatted

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_NZBAL.BALANCE ( BAL_ASSACT.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