View: PAY_JP_SOE_RETRO_ENTRIES_V

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

View Text

SELECT V.CREATOR_ACTION_ID
, V.ASSIGNMENT_ACTION_ID
, V.ELEMENT_TYPE_ID
, V.INPUT_CURRENCY_CODE
, V.ELEMENT_ENTRY_ID
, V.EFFECTIVE_START_DATE
, V.EFFECTIVE_END_DATE
, V.REPORTING_NAME
, V.PROCESSING_PRIORITY
, V.SUBPRIORITY
, PEEV.SCREEN_ENTRY_VALUE
, SUBSTRB(TO_CHAR(TO_NUMBER(PEEV.SCREEN_ENTRY_VALUE)
, FND_CURRENCY.GET_FORMAT_MASK(V.INPUT_CURRENCY_CODE
, 60))
, 1
, 80)
, SUBSTRB(PAY_JP_SOE_PKG.ENTRY_PROCESSED_FLAG(V.ELEMENT_ENTRY_ID
, V.EFFECTIVE_START_DATE
, V.EFFECTIVE_END_DATE)
, 1
, 1) FROM PAY_ELEMENT_ENTRY_VALUES_F PEEV
, ( SELECT PAA.ASSIGNMENT_ACTION_ID CREATOR_ACTION_ID
, PEE.SOURCE_ID ASSIGNMENT_ACTION_ID
, PIV.ELEMENT_TYPE_ID
, PET.INPUT_CURRENCY_CODE
, PEE.ELEMENT_ENTRY_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PIV.INPUT_VALUE_ID
, NVL(PETTL.REPORTING_NAME
, PETTL.ELEMENT_NAME) REPORTING_NAME
, PET.PROCESSING_PRIORITY
, PEE.SUBPRIORITY FROM PAY_INPUT_VALUES_F PIV
, PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_ENTRIES_F PEE
, /* RETRO ENTRIES */ PAY_PAYROLL_ACTIONS PPA
, /* RETRO PACT */ PAY_ASSIGNMENT_ACTIONS PAA /* RETRO ASSACT */ WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID AND PPA.ACTION_TYPE = 'G' AND PEE.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID AND PEE.ENTRY_TYPE = 'E' AND PPA.EFFECTIVE_DATE BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE AND PEE.CREATOR_ID = PAA.ASSIGNMENT_ACTION_ID AND PEE.CREATOR_TYPE = 'R' AND PEL.ELEMENT_LINK_ID = PEE.ELEMENT_LINK_ID AND PPA.EFFECTIVE_DATE BETWEEN PEL.EFFECTIVE_START_DATE
AND PEL.EFFECTIVE_END_DATE AND PET.ELEMENT_TYPE_ID = PEL.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 PIV.ELEMENT_TYPE_ID(+) = PET.ELEMENT_TYPE_ID AND PIV.NAME(+) = 'PAY VALUE' AND PET.EFFECTIVE_START_DATE BETWEEN PIV.EFFECTIVE_START_DATE(+)
AND PIV.EFFECTIVE_END_DATE(+) ) V WHERE PEEV.ELEMENT_ENTRY_ID(+) = V.ELEMENT_ENTRY_ID AND PEEV.EFFECTIVE_START_DATE(+) = V.EFFECTIVE_START_DATE AND PEEV.EFFECTIVE_END_DATE(+) = V.EFFECTIVE_END_DATE AND PEEV.INPUT_VALUE_ID(+) = V.INPUT_VALUE_ID

Columns