Product: | PAY - Payroll |
---|---|
Description: | This view is used for Japanese localization only. |
Implementation/DBA Data: | APPS.PAY_JP_SOE_PREPAY_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.PAYROLL_ID
, ASSACT.PAYROLL_NAME
, ASSACT.CONSOLIDATION_SET_ID
, ASSACT.CONSOLIDATION_SET_NAME
, ASSACT.ORG_PAYMENT_METHOD_ID
, ASSACT.ORG_PAYMENT_METHOD_NAME
, ASSACT.LEGISLATIVE_PARAMETERS
, ASSACT.MESSAGES_EXIST_FLAG
, /* NEVER CALL THE FOLLOWING FUNCTION DIRECTLY WHICH WILL CAUSE SEVERE LOSS OF PERFORMANCE. */ ( SELECT PAY_JP_SOE_PKG.GET_LOCK_STATUS_VAL(ASSACT.ASSIGNMENT_ACTION_ID
, 'M'
, 'LOCK_STATUS')
FROM DUAL ) M_LOCK_STATUS
, ( SELECT PAY_JP_SOE_PKG.GET_LOCK_STATUS_VAL(ASSACT.ASSIGNMENT_ACTION_ID
, 'M'
, 'ACTION_STATUS')
FROM DUAL ) M_ACTION_STATUS
FROM PAY_JP_SOE_ASSACTS_V ASSACT
WHERE ASSACT.ACTION_TYPE IN ('P'
, 'U')