View: PAY_JP_PAYJPBAL_VALUES_V

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

View Text

SELECT /*+ ORDERED USE_NL(PPA DEF DIM) */ PAA.ASSIGNMENT_ACTION_ID
, DEF.BALANCE_TYPE_ID
, DEF.DEFINED_BALANCE_ID
, DIM.DATABASE_ITEM_SUFFIX
, PAY_BALANCE_PKG.GET_VALUE(DEF.DEFINED_BALANCE_ID
, PAA.ASSIGNMENT_ACTION_ID) VALUE
, NULL ELEMENT_NAME
, NULL SOURCE_ID
, 1 DISPLAY_ORDER FROM PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
, PAY_DEFINED_BALANCES DEF
, PAY_BALANCE_DIMENSIONS_VL DIM WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID AND NVL(DEF.BUSINESS_GROUP_ID
, PPA.BUSINESS_GROUP_ID) = PPA.BUSINESS_GROUP_ID AND NVL(DEF.LEGISLATION_CODE
, 'JP') = 'JP' AND DIM.BALANCE_DIMENSION_ID = DEF.BALANCE_DIMENSION_ID AND NVL(DIM.DIMENSION_LEVEL
, 'ASG') <> 'GRP' AND NVL(DIM.PERIOD_TYPE
, 'RUN') <> 'PAYMENT' AND DIM.DIMENSION_NAME NOT IN ('_ELM_PTD'
, '_ELM_LTD') UNION ALL SELECT /*+ ORDERED NO_MERGE(V) USE_NL(PPA2 DEF DIM V) */ PAA2.ASSIGNMENT_ACTION_ID
, DEF.BALANCE_TYPE_ID
, DEF.DEFINED_BALANCE_ID
, DIM.DATABASE_ITEM_SUFFIX
, PAY_BALANCE_PKG.GET_VALUE( DEF.DEFINED_BALANCE_ID
, PAA2.ASSIGNMENT_ACTION_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, V.SOURCE_ID
, NULL) VALUE
, ( SELECT MIN(PETTL.ELEMENT_NAME) FROM PAY_ELEMENT_ENTRIES_F PEE
, PAY_ELEMENT_TYPES_F_TL PETTL WHERE PEE.ELEMENT_ENTRY_ID = V.SOURCE_ID AND PETTL.ELEMENT_TYPE_ID = PEE.ELEMENT_TYPE_ID AND PETTL.LANGUAGE = USERENV('LANG') ) ELEMENT_NAME
, V.SOURCE_ID
, 0 DISPLAY_ORDER FROM PAY_ASSIGNMENT_ACTIONS PAA2
, PAY_PAYROLL_ACTIONS PPA2
, PAY_DEFINED_BALANCES DEF
, PAY_BALANCE_DIMENSIONS_VL DIM
, ( SELECT /*+ ORDERED PUSH_SUBQ USE_NL(PAA PPA PAC PRR PIV FEED) */ PAA.ASSIGNMENT_ACTION_ID
, FEED.BALANCE_TYPE_ID
, FND_NUMBER.CANONICAL_TO_NUMBER(PAC.CONTEXT_VALUE) SOURCE_ID FROM FF_CONTEXTS CON
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
, PAY_ACTION_CONTEXTS PAC
, PAY_RUN_RESULTS PRR
, PAY_INPUT_VALUES_F PIV
, PAY_BALANCE_FEEDS_F FEED WHERE CON.CONTEXT_NAME = 'ORIGINAL_ENTRY_ID' AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID AND PAC.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID AND PAC.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID AND PAC.CONTEXT_ID = CON.CONTEXT_ID AND PRR.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID AND PRR.STATUS IN ('P'
, 'PA') /* IN CASE OF ADDITIVE ENTRY
, BOTH P/PA CAN EXIST FOR A SAME SOURCE_ID. CHECK LEGISLATION_RULE ADJUSTMENT_EE_SOURCE = "T"(TARGET_ENTRY_ID). */ AND DECODE(DECODE(PRR.SOURCE_TYPE
, 'R'
, 'V'
, PRR.SOURCE_TYPE)
, 'V'
, ( SELECT PRR2.SOURCE_ID FROM PAY_RUN_RESULTS PRR2 WHERE PRR2.RUN_RESULT_ID = PRR.SOURCE_ID )
, PRR.SOURCE_ID) = FND_NUMBER.CANONICAL_TO_NUMBER(PAC.CONTEXT_VALUE) /* DO NOT JOIN PRRV WHICH CAN BE NO_DATA_FOUND BY SPARSE MATRIX. NOTE PRR.ELEMENT_TYPE_ID DOES NOT POINT THE SAME ELEMENT AS FOLLOWS. 1) BALANCE INITIALIZATION POINTS BALANCE INITIALIZATION ELEMENT. 2) BALANCE ADJUSTMENT POINTS BALANCE ADJUSTED ELEMENT. 3) OTHER ACTIONS POINTS THE SAME ELEMENT.(STRICTLY SPEAKING
, ELEMENT_LINK_ID MUST BE THE SAME). 4) IN CASE OF INDIRECT RESULT
, MULTIPLE RESULTS CAN EXIST FOR THE SAME SOURCE_ID. */ AND PIV.ELEMENT_TYPE_ID = PRR.ELEMENT_TYPE_ID AND PPA.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE AND FEED.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID AND PPA.EFFECTIVE_DATE BETWEEN FEED.EFFECTIVE_START_DATE
AND FEED.EFFECTIVE_END_DATE GROUP BY PAA.ASSIGNMENT_ACTION_ID
, FEED.BALANCE_TYPE_ID
, PAC.CONTEXT_VALUE ) V WHERE PPA2.PAYROLL_ACTION_ID = PAA2.PAYROLL_ACTION_ID AND NVL(DEF.BUSINESS_GROUP_ID
, PPA2.BUSINESS_GROUP_ID) = PPA2.BUSINESS_GROUP_ID AND NVL(DEF.LEGISLATION_CODE
, 'JP') = 'JP' AND DIM.BALANCE_DIMENSION_ID = DEF.BALANCE_DIMENSION_ID AND DIM.DIMENSION_NAME IN ('_ELM_PTD'
, '_ELM_LTD') AND V.ASSIGNMENT_ACTION_ID = PAA2.ASSIGNMENT_ACTION_ID AND V.BALANCE_TYPE_ID = DEF.BALANCE_TYPE_ID

Columns