Product: | PAY - Payroll |
---|---|
Description: | This view is used for Japanese localization only. |
Implementation/DBA Data: | APPS.PAY_JP_SOE_RUN_ASSACTS_V |
SELECT V.ASSIGNMENT_ID
, V.ASSIGNMENT_ACTION_ID
, V.OBJECT_VERSION_NUMBER
, V.ACTION_STATUS
, V.D_ACTION_STATUS
, V.MARKED_FOR_RETRY_FLAG
, V.ACTION_SEQUENCE
, V.PAYROLL_ACTION_ID
, V.REQUEST_ID
, V.START_DATE
, V.EFFECTIVE_DATE
, V.DATE_EARNED
, V.ACTION_TYPE
, V.D_ACTION_TYPE
, V.PAYROLL_ID
, V.PAYROLL_NAME
, V.CONSOLIDATION_SET_ID
, V.CONSOLIDATION_SET_NAME
, V.ELEMENT_SET_ID
, V.ELEMENT_SET_NAME
, V.D_ELEMENT_SET_NAME
, V.ASSIGNMENT_SET_ID
, V.ASSIGNMENT_SET_NAME
, V.LEGISLATIVE_PARAMETERS
, V.MESSAGES_EXIST_FLAG
, V.P_ASSIGNMENT_ACTION_ID
, V.P_ACTION_STATUS
, /* NEVER CALL THE FOLLOWING FUNCTIONS DIRECTLY WHICH WILL CAUSE SEVERE LOSS OF PERFORMANCE. */ ( SELECT PAY_JP_SOE_PKG.GET_LOCK_STATUS_VAL(V.P_ASSIGNMENT_ACTION_ID
, 'M'
, 'LOCK_STATUS')
FROM DUAL ) M_LOCK_STATUS
, ( SELECT PAY_JP_SOE_PKG.GET_LOCK_STATUS_VAL(V.P_ASSIGNMENT_ACTION_ID
, 'M'
, 'ACTION_STATUS')
FROM DUAL ) M_ACTION_STATUS
, V.C_ASSIGNMENT_ACTION_ID
, V.C_ACTION_STATUS
, V.T_ASSIGNMENT_ACTION_ID
, V.T_ACTION_STATUS
, V.V_ASSIGNMENT_ACTION_ID
, V.V_ACTION_STATUS
FROM ( 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.ELEMENT_SET_ID
, ASSACT.ELEMENT_SET_NAME
, ASSACT.D_ELEMENT_SET_NAME
, ASSACT.ASSIGNMENT_SET_ID
, ASSACT.ASSIGNMENT_SET_NAME
, ASSACT.LEGISLATIVE_PARAMETERS
, ASSACT.MESSAGES_EXIST_FLAG
, ( SELECT PAY_JP_SOE_PKG.GET_LOCK_ACTION_NUM(ASSACT.ASSIGNMENT_ACTION_ID
, 'P'
, 'ASSIGNMENT_ACTION_ID')
FROM DUAL ) P_ASSIGNMENT_ACTION_ID
, ( SELECT PAY_JP_SOE_PKG.GET_LOCK_ACTION_VAL(ASSACT.ASSIGNMENT_ACTION_ID
, 'P'
, 'ACTION_STATUS')
FROM DUAL ) P_ACTION_STATUS
, ( SELECT PAY_JP_SOE_PKG.GET_LOCK_ACTION_NUM(ASSACT.ASSIGNMENT_ACTION_ID
, 'C'
, 'ASSIGNMENT_ACTION_ID')
FROM DUAL ) C_ASSIGNMENT_ACTION_ID
, ( SELECT PAY_JP_SOE_PKG.GET_LOCK_ACTION_VAL(ASSACT.ASSIGNMENT_ACTION_ID
, 'C'
, 'ACTION_STATUS')
FROM DUAL ) C_ACTION_STATUS
, ( SELECT PAY_JP_SOE_PKG.GET_LOCK_ACTION_NUM(ASSACT.ASSIGNMENT_ACTION_ID
, 'T'
, 'ASSIGNMENT_ACTION_ID')
FROM DUAL ) T_ASSIGNMENT_ACTION_ID
, ( SELECT PAY_JP_SOE_PKG.GET_LOCK_ACTION_VAL(ASSACT.ASSIGNMENT_ACTION_ID
, 'T'
, 'ACTION_STATUS')
FROM DUAL ) T_ACTION_STATUS
, ( SELECT PAY_JP_SOE_PKG.GET_LOCK_ACTION_NUM(ASSACT.ASSIGNMENT_ACTION_ID
, 'V'
, 'ASSIGNMENT_ACTION_ID')
FROM DUAL ) V_ASSIGNMENT_ACTION_ID
, ( SELECT PAY_JP_SOE_PKG.GET_LOCK_ACTION_VAL(ASSACT.ASSIGNMENT_ACTION_ID
, 'V'
, 'ACTION_STATUS')
FROM DUAL ) V_ACTION_STATUS
FROM PAY_JP_SOE_ASSACTS_V ASSACT
WHERE ASSACT.ACTION_TYPE IN ('R'
, 'Q'
, 'B'
, 'I'
, 'V') ) V