VIEW: APPS.PAY_JP_SOE_RUN_ASSACTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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