Product: | PAY - Payroll |
---|---|
Description: | This view is used for Japanese localization only. |
Implementation/DBA Data: | APPS.PAY_JP_SOE_ADV_RETRO_ASSACTS_V |
SELECT ASSACT.ASSIGNMENT_ID
, ASSACT.ASSIGNMENT_ACTION_ID
, ASSACT.OBJECT_VERSION_NUMBER
, ASSACT.ACTION_STATUS
, ASSACT.D_ACTION_STATUS
, ASSACT.MARKED_FOR_RETRY_FLAG
, ASSACT.ACTION_SEQUENCE
, ASSACT.PAYROLL_ACTION_ID
, ASSACT.REQUEST_ID
, ASSACT.START_DATE
, ASSACT.EFFECTIVE_DATE
, ASSACT.DATE_EARNED
, ASSACT.ACTION_TYPE
, ASSACT.D_ACTION_TYPE
, ASSACT.BACKPAY_SET_ID
, ASSACT.BACKPAY_SET_NAME
, ASSACT.ASSIGNMENT_SET_ID
, ASSACT.ASSIGNMENT_SET_NAME
, ASSACT.LEGISLATIVE_PARAMETERS
, ASSACT.MESSAGES_EXIST_FLAG
, SUBSTRB(PAY_JP_SOE_PKG.RETRO_ENTRIES_PROCESSED_FLAG(ASSACT.ASSIGNMENT_ACTION_ID)
, 1
, 1)
FROM PAY_JP_SOE_ASSACTS_V ASSACT
WHERE ASSACT.ACTION_TYPE = 'L'