View: PAY_JP_SOE_COST_ASSACTS_V

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

View Text

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.LEGISLATIVE_PARAMETERS
, ASSACT.MESSAGES_EXIST_FLAG
, ( SELECT PAY_JP_SOE_PKG.GET_LOCK_STATUS_VAL(ASSACT.ASSIGNMENT_ACTION_ID
, 'T'
, 'LOCK_STATUS')
FROM DUAL )
, ( SELECT PAY_JP_SOE_PKG.GET_LOCK_STATUS_VAL(ASSACT.ASSIGNMENT_ACTION_ID
, 'T'
, 'ACTION_STATUS')
FROM DUAL )
FROM PAY_JP_SOE_ASSACTS_V ASSACT
WHERE ASSACT.ACTION_TYPE = 'C'

Columns