View: PAY_JP_BAL_MATRIX_BY_ACT_V

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

View Text

SELECT /*+ ORDERED USE_NL((PPA PRR PRRV FEED PBTTL) */ PAA.ASSIGNMENT_ACTION_ID
, PBTTL.BALANCE_TYPE_ID
, PBTTL.BALANCE_NAME
, PBT.BALANCE_UOM
, SUBSTRB(HR_GENERAL.DECODE_LOOKUP('UNITS'
, PBT.BALANCE_UOM)
, 1
, 80) D_BALANCE_UOM
, PBT.CURRENCY_CODE
, PAY_JP_BALANCE_VIEW_PKG.GET_VALUE(PAA.ASSIGNMENT_ACTION_ID
, PBTTL.BALANCE_TYPE_ID
, '_ASG_RUN'
, PPA.BUSINESS_GROUP_ID) ASG_RUN_BAL
, PAY_JP_BALANCE_VIEW_PKG.GET_VALUE(PAA.ASSIGNMENT_ACTION_ID
, PBTTL.BALANCE_TYPE_ID
, '_ASG_PTD'
, PPA.BUSINESS_GROUP_ID) ASG_PROC_PTD_BAL
, PAY_JP_BALANCE_VIEW_PKG.GET_VALUE(PAA.ASSIGNMENT_ACTION_ID
, PBTTL.BALANCE_TYPE_ID
, '_ASG_MTD EFFECTIVE_DATE 01-01 RESET 12'
, PPA.BUSINESS_GROUP_ID) ASG_MTD_JP_BAL
, PAY_JP_BALANCE_VIEW_PKG.GET_VALUE(PAA.ASSIGNMENT_ACTION_ID
, PBTTL.BALANCE_TYPE_ID
, '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01'
, PPA.BUSINESS_GROUP_ID) ASG_YTD_JP_BAL
, PAY_JP_BALANCE_VIEW_PKG.GET_VALUE(PAA.ASSIGNMENT_ACTION_ID
, PBTTL.BALANCE_TYPE_ID
, '_ASG_FYTD DATE_EARNED RESET 01'
, PPA.BUSINESS_GROUP_ID) ASG_FYTD_JP_BAL
, PAY_JP_BALANCE_VIEW_PKG.GET_VALUE(PAA.ASSIGNMENT_ACTION_ID
, PBTTL.BALANCE_TYPE_ID
, '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01'
, PPA.BUSINESS_GROUP_ID) ASG_AUG2JUL_JP_BAL
, PAY_JP_BALANCE_VIEW_PKG.GET_VALUE(PAA.ASSIGNMENT_ACTION_ID
, PBTTL.BALANCE_TYPE_ID
, '_ASG_LTD'
, PPA.BUSINESS_GROUP_ID) ASG_ITD_BAL
, PAY_JP_BALANCE_VIEW_PKG.GET_VALUE(PAA.ASSIGNMENT_ACTION_ID
, PBTTL.BALANCE_TYPE_ID
, '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01'
, PPA.BUSINESS_GROUP_ID) ASG_JUL2JUN_JP_BAL
, PAY_JP_BALANCE_VIEW_PKG.GET_VALUE(PAA.ASSIGNMENT_ACTION_ID
, PBTTL.BALANCE_TYPE_ID
, '_ASG_BYTD'
, PPA.BUSINESS_GROUP_ID) ASG_FYTD2_JP_BAL
, PAY_JP_BALANCE_VIEW_PKG.GET_VALUE(PAA.ASSIGNMENT_ACTION_ID
, PBTTL.BALANCE_TYPE_ID
, '_ASG_APRTD EFFECTIVE_DATE 01-04 RESET 01'
, PPA.BUSINESS_GROUP_ID) ASG_APR2MAR_JP_BAL FROM PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
, PAY_RUN_RESULTS PRR
, PAY_RUN_RESULT_VALUES PRRV
, PAY_BALANCE_FEEDS_F FEED
, PAY_BALANCE_TYPES PBT
, PAY_BALANCE_TYPES_TL PBTTL WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID AND PRR.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID AND PRR.STATUS IN ('P'
, 'PA') AND PRRV.RUN_RESULT_ID = PRR.RUN_RESULT_ID AND FEED.INPUT_VALUE_ID = PRRV.INPUT_VALUE_ID AND PPA.EFFECTIVE_DATE BETWEEN FEED.EFFECTIVE_START_DATE
AND FEED.EFFECTIVE_END_DATE AND PBT.BALANCE_TYPE_ID = FEED.BALANCE_TYPE_ID AND PBTTL.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID AND PBTTL.LANGUAGE = USERENV('LANG') GROUP BY PAA.ASSIGNMENT_ACTION_ID
, PBTTL.BALANCE_TYPE_ID
, PBTTL.BALANCE_NAME
, PBT.BALANCE_UOM
, PBT.CURRENCY_CODE
, PPA.BUSINESS_GROUP_ID

Columns