View: PAY_JP_SOE_PREPAY_PAYMENTS_V

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

View Text

SELECT V.ASSIGNMENT_ACTION_ID
, V.PRE_PAYMENT_ID
, V.M_ASSIGNMENT_ACTION_ID
, V.M_OBJECT_VERSION_NUMBER
, V.M_PAYROLL_ACTION_ID
, V.M_ACTION_TYPE
, SUBSTRB(HR_GENERAL.DECODE_LOOKUP('ACTION_TYPE'
, V.M_ACTION_TYPE)
, 1
, 80)
, V.M_ACTION_STATUS
, DECODE(V.M_ACTION_STATUS
, 'M'
, 'Y'
, 'N')
, V.CATEGORY
, V.PAYMENT_TYPE_NAME
, V.ORG_PAYMENT_METHOD_NAME
, V.PRIORITY
, V.VALUE
, SUBSTRB(TO_CHAR(V.VALUE
, FND_CURRENCY.GET_FORMAT_MASK(V.CURRENCY_CODE
, 40))
, 1
, 40)
, V.CURRENCY_CODE
, V.EXTERNAL_ACCOUNT_ID
, SUBSTRB(PAY_JP_SOE_PKG.MESSAGES_EXIST_FLAG(V.ASSIGNMENT_ACTION_ID
, 'A')
, 1
, 1)
FROM ( SELECT PAA.ASSIGNMENT_ACTION_ID
, PPP.PRE_PAYMENT_ID
, PPT.CATEGORY
, PPTTL.PAYMENT_TYPE_NAME
, OPM.CURRENCY_CODE
, OPMTL.ORG_PAYMENT_METHOD_NAME
, PPM.PRIORITY
, PPP.VALUE
, PPM.EXTERNAL_ACCOUNT_ID
, ( SELECT PAY_JP_SOE_PKG.GET_LOCK_ACTION_NUM(PPP.PRE_PAYMENT_ID
, 'M'
, 'ASSIGNMENT_ACTION_ID')
FROM DUAL ) M_ASSIGNMENT_ACTION_ID
, ( SELECT PAY_JP_SOE_PKG.GET_LOCK_ACTION_NUM(PPP.PRE_PAYMENT_ID
, 'M'
, 'OBJECT_VERSION_NUMBER')
FROM DUAL ) M_OBJECT_VERSION_NUMBER
, ( SELECT PAY_JP_SOE_PKG.GET_LOCK_ACTION_NUM(PPP.PRE_PAYMENT_ID
, 'M'
, 'PAYROLL_ACTION_ID')
FROM DUAL ) M_PAYROLL_ACTION_ID
, ( SELECT PAY_JP_SOE_PKG.GET_LOCK_ACTION_VAL(PPP.PRE_PAYMENT_ID
, 'M'
, 'ACTION_TYPE')
FROM DUAL ) M_ACTION_TYPE
, ( SELECT PAY_JP_SOE_PKG.GET_LOCK_ACTION_VAL(PPP.PRE_PAYMENT_ID
, 'M'
, 'ACTION_STATUS')
FROM DUAL ) M_ACTION_STATUS
FROM PAY_PERSONAL_PAYMENT_METHODS_F PPM
, PAY_PAYMENT_TYPES_TL PPTTL
, PAY_PAYMENT_TYPES PPT
, PAY_ORG_PAYMENT_METHODS_F_TL OPMTL
, PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_PRE_PAYMENTS PPP
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PPP.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND OPM.ORG_PAYMENT_METHOD_ID = PPP.ORG_PAYMENT_METHOD_ID
AND PPA.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE
AND OPM.EFFECTIVE_END_DATE
AND OPMTL.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID
AND OPMTL.LANGUAGE = USERENV('LANG')
AND PPT.PAYMENT_TYPE_ID = OPM.PAYMENT_TYPE_ID
AND PPTTL.PAYMENT_TYPE_ID = PPT.PAYMENT_TYPE_ID
AND PPTTL.LANGUAGE = USERENV('LANG')
AND PPM.PERSONAL_PAYMENT_METHOD_ID(+) = PPP.PERSONAL_PAYMENT_METHOD_ID
AND PPA.EFFECTIVE_DATE BETWEEN NVL(PPM.EFFECTIVE_START_DATE
, PPA.EFFECTIVE_DATE)
AND NVL(PPM.EFFECTIVE_END_DATE
, PPA.EFFECTIVE_DATE) ) V

Columns