View: PAY_JP_BALANCES_BY_ACTION_V

Product:	PAY - Payroll
Description:	This is a balance view. This view is used for Japanese localization only.
Implementation/DBA Data:	APPS.PAY_JP_BALANCES_BY_ACTION_V

View Text

SELECT ASSACT.ASSIGNMENT_ID
, ASSACT.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID
, PBT.BALANCE_NAME
, PDB.DEFINED_BALANCE_ID
, PBD.DATABASE_ITEM_SUFFIX
, HR_JPBAL.CALC_ALL_BALANCES(ASSACT.ASSIGNMENT_ACTION_ID
, PDB.DEFINED_BALANCE_ID) VALUE
FROM PAY_BALANCE_DIMENSIONS PBD
, PAY_DEFINED_BALANCES PDB
, PAY_BALANCE_TYPES PBT
, PAY_BALANCE_FEEDS_F FEED
, PAY_RUN_RESULT_VALUES PRRV
, PAY_RUN_RESULTS PRR
, PAY_PAYROLL_ACTIONS PACT
, PAY_ASSIGNMENT_ACTIONS ASSACT
WHERE ASSACT.ACTION_STATUS = 'C'
AND PACT.PAYROLL_ACTION_ID = ASSACT.PAYROLL_ACTION_ID
AND PRR.ASSIGNMENT_ACTION_ID = ASSACT.ASSIGNMENT_ACTION_ID
AND PRRV.RUN_RESULT_ID = PRR.RUN_RESULT_ID
AND FEED.INPUT_VALUE_ID = PRRV.INPUT_VALUE_ID
AND PACT.EFFECTIVE_DATE BETWEEN FEED.EFFECTIVE_START_DATE
AND FEED.EFFECTIVE_END_DATE
AND PBT.BALANCE_TYPE_ID = FEED.BALANCE_TYPE_ID
AND NVL(PBT.LEGISLATION_CODE
, 'JP') = 'JP'
AND PDB.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID
AND PBD.BALANCE_DIMENSION_ID = PDB.BALANCE_DIMENSION_ID GROUP BY ASSACT.ASSIGNMENT_ID
, ASSACT.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID
, PBT.BALANCE_NAME
, PDB.DEFINED_BALANCE_ID
, PBD.DATABASE_ITEM_SUFFIX

Columns