View: PAY_JP_SOE_RUN_ALLOWANCES_V

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

View Text

SELECT PAA.ASSIGNMENT_ACTION_ID
, NVL(PETTL.REPORTING_NAME
, PETTL.ELEMENT_NAME)
, PRR.RUN_RESULT_ID
, NVL(TO_NUMBER(PRRV.RESULT_VALUE)
, 0)
FROM PAY_RUN_RESULT_VALUES PRRV
, HR_LOOKUPS HRL
, PAY_INPUT_VALUES_F PIV
, HR_JP_PARAMETERS HJP
, PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_ELEMENT_TYPES_F PET
, PAY_RUN_RESULTS PRR
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
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 PET.ELEMENT_TYPE_ID=PRR.ELEMENT_TYPE_ID
AND PPA.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PETTL.ELEMENT_TYPE_ID=PET.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE=USERENV('LANG')
AND HJP.OWNER='PAYJPSOE'
AND HJP.PARAMETER_VALUE=TO_CHAR(PET.CLASSIFICATION_ID)
AND HJP.PARAMETER_NAME || '' IN ( 'SAL_ALLOWANCE_CLASS_ID'
, 'SAL_MAT_ALLOWANCE_CLASS_ID'
, 'BON_ALLOWANCE_CLASS_ID'
, 'BON_MAT_ALLOWANCE_CLASS_ID'
, 'SP_BON_ALLOWANCE_CLASS_ID'
, 'SP_BON_MAT_ALLOWANCE_CLASS_ID'
, 'TERM_ALLOWANCE_CLASS_ID'
, 'TERM_MAT_ALLOWANCE_CLASS_ID')
AND PIV.ELEMENT_TYPE_ID=NVL(PET.ELEMENT_TYPE_ID
, TO_NUMBER(HJP.PARAMETER_VALUE))
AND PIV.UOM='M'
AND PPA.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND HRL.LOOKUP_TYPE='NAME_TRANSLATIONS'
AND UPPER(HRL.LOOKUP_CODE)='PAY VALUE'
AND HRL.MEANING=PIV.NAME
AND PRRV.RUN_RESULT_ID=NVL(PRR.RUN_RESULT_ID
, PIV.INPUT_VALUE_ID)
AND PRRV.INPUT_VALUE_ID=PIV.INPUT_VALUE_ID

Columns