VIEW: APPS.PAY_JP_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_jpbal.balance(BAL_ASSACT.assignment_action_id, DB.defined_balance_id) result_value FROM ff_database_items DBI, pay_balance_dimensions DIM, pay_defined_balances DB, ff_user_entities UE, pay_payroll_actions BACT, pay_assignment_actions BAL_ASSACT WHERE BACT.payroll_action_id = BAL_ASSACT.payroll_action_id AND NVL(UE.business_group_id, BACT.business_group_id) = BACT.business_group_id AND UE.creator_type = 'B' AND DB.defined_balance_id = UE.creator_id AND DIM.balance_dimension_id = DB.balance_dimension_id AND DBI.user_entity_id = UE.user_entity_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_JPBAL.BALANCE(BAL_ASSACT.ASSIGNMENT_ACTION_ID
, DB.DEFINED_BALANCE_ID) RESULT_VALUE
FROM FF_DATABASE_ITEMS DBI
, PAY_BALANCE_DIMENSIONS DIM
, PAY_DEFINED_BALANCES DB
, FF_USER_ENTITIES UE
, PAY_PAYROLL_ACTIONS BACT
, PAY_ASSIGNMENT_ACTIONS BAL_ASSACT
WHERE BACT.PAYROLL_ACTION_ID = BAL_ASSACT.PAYROLL_ACTION_ID
AND NVL(UE.BUSINESS_GROUP_ID
, BACT.BUSINESS_GROUP_ID) = BACT.BUSINESS_GROUP_ID
AND UE.CREATOR_TYPE = 'B'
AND DB.DEFINED_BALANCE_ID = UE.CREATOR_ID
AND DIM.BALANCE_DIMENSION_ID = DB.BALANCE_DIMENSION_ID
AND DBI.USER_ENTITY_ID = UE.USER_ENTITY_ID