VIEW: APPS.PAY_JP_SOE_COST_ASSACTS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'