View: PAY_JP_SOE_ASSACTS_V

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

View Text

SELECT PAA.ASSIGNMENT_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.OBJECT_VERSION_NUMBER
, PAA.ACTION_STATUS
, HRL1.MEANING
, DECODE(PAA.ACTION_STATUS
, 'M'
, 'Y'
, 'N')
, PAA.ACTION_SEQUENCE
, PAA.PAYROLL_ACTION_ID
, PPA.REQUEST_ID
, PPA.START_DATE
, PPA.EFFECTIVE_DATE
, PPA.DATE_EARNED
, PPA.ACTION_TYPE
, HRL2.MEANING
, PPA.PAYROLL_ID
, PP.PAYROLL_NAME
, PPA.CONSOLIDATION_SET_ID
, PCS.CONSOLIDATION_SET_NAME
, PPA.ELEMENT_SET_ID
, PES.BASE_ELEMENT_SET_NAME
, PES.ELEMENT_SET_NAME
, PPA.BACKPAY_SET_ID
, PBS.BACKPAY_SET_NAME
, PPA.ASSIGNMENT_SET_ID
, HAS.ASSIGNMENT_SET_NAME
, PPA.ORG_PAYMENT_METHOD_ID
, OPMTL.ORG_PAYMENT_METHOD_NAME
, PPA.LEGISLATIVE_PARAMETERS
, SUBSTRB(PAY_JP_SOE_PKG.MESSAGES_EXIST_FLAG(PAA.ASSIGNMENT_ACTION_ID
, 'A')
, 1
, 1) FROM PAY_ORG_PAYMENT_METHODS_F_TL OPMTL
, PAY_PAYROLLS_F PP
, HR_ASSIGNMENT_SETS HAS
, PAY_BACKPAY_SETS PBS
, PAY_ELEMENT_SETS_VL PES
, PAY_CONSOLIDATION_SETS PCS
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
, HR_LOOKUPS HRL2
, HR_LOOKUPS HRL1 WHERE HRL1.LOOKUP_TYPE = 'ACTION_STATUS' AND HRL2.LOOKUP_TYPE = 'ACTION_TYPE' AND HRL1.LOOKUP_CODE = PAA.ACTION_STATUS AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID AND HRL2.LOOKUP_CODE = PPA.ACTION_TYPE AND PCS.CONSOLIDATION_SET_ID(+) = PPA.CONSOLIDATION_SET_ID AND PES.ELEMENT_SET_ID(+) = PPA.ELEMENT_SET_ID AND PBS.BACKPAY_SET_ID(+) = PPA.BACKPAY_SET_ID AND HAS.ASSIGNMENT_SET_ID(+) = PPA.ASSIGNMENT_SET_ID AND PP.PAYROLL_ID(+) = PPA.PAYROLL_ID AND PPA.EFFECTIVE_DATE BETWEEN PP.EFFECTIVE_START_DATE(+)
AND PP.EFFECTIVE_END_DATE(+) AND OPMTL.ORG_PAYMENT_METHOD_ID(+) = PPA.ORG_PAYMENT_METHOD_ID AND OPMTL.LANGUAGE(+) = USERENV('LANG')

Columns