[Home] [Help]
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
Name |
ASSIGNMENT_ID |
ASSIGNMENT_ACTION_ID |
BALANCE_TYPE_ID |
BALANCE_NAME |
DEFINED_BALANCE_ID |
DATABASE_ITEM_SUFFIX |
VALUE |