[Home] [Help]
View: PAY_JP_BALANCES_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_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_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
Columns
Name |
ASSIGNMENT_ID |
ASSIGNMENT_ACTION_ID |
ACTION_SEQUENCE |
EFFECTIVE_DATE |
BUSINESS_GROUP_ID |
BALANCE_TYPE_ID |
DEFINED_BALANCE_ID |
DIMENSION_NAME |
BALANCE_DIMENSION_ID |
ITEM_NAME |
RESULT_VALUE |