PAY_RUN_RESULT_SPL_OUT

Details

Schema: FUSION
Object owner: PAY
Object type: VIEW

Columns

Name
OBJECT_ACTION_ID RUN_RESULT_ID INPUT_VALUE_ID ELEMENT_TYPE_ID ELEMENT_NAME OUTPUT_CURRENCY_CODE RESULT_VALUE INPUT_VALUE_NAME PRORATION_START_DATE PRORATION_END_DATE TAX_UNIT_ID TAX_REPORTING_NAME UOM PROCESSING_PRIORITY

Name

OBJECT_ACTION_ID

RUN_RESULT_ID

INPUT_VALUE_ID

ELEMENT_TYPE_ID

ELEMENT_NAME

OUTPUT_CURRENCY_CODE

RESULT_VALUE

INPUT_VALUE_NAME

PRORATION_START_DATE

PRORATION_END_DATE

TAX_UNIT_ID

TAX_REPORTING_NAME

UOM

PROCESSING_PRIORITY

Query

SQL_Statement
select ppra.source_action_id object_action_id, rrv.run_result_id,rrv.input_value_id, rr.element_type_id,elt.element_name, elt.output_currency_code, rrv.result_value, inv.name as input_value_name, rr.start_date proration_start_date,rr.end_date proration_end_date, rr.tax_unit_id,org.name Tax_reporting_name, inv.uom,elt.processing_priority from pay_run_result_values rrv,pay_run_results rr,pay_element_types_vl elt, pay_input_values_vl inv, pay_payroll_rel_actions ppra, HR_ALL_ORGANIZATION_UNITS_F_VL org, pay_payroll_actions ppa where rr.run_result_id=rrv.run_result_id and elt.element_type_id=rr.element_type_id and inv.input_value_id=rrv.input_value_id and ppra.payroll_rel_action_id=rr.payroll_rel_action_id and org.organization_id(+)=rr.tax_unit_id AND ppa.action_type IN ('R','Q','B','V') and ppa.payroll_action_id=ppra.payroll_action_id and (ppa.effective_date between inv.effective_start_date and inv.effective_end_date) AND ( ppa.effective_date BETWEEN elt.effective_start_date AND elt.effective_end_date ) AND ( ppa.effective_date BETWEEN org.effective_start_date(+) AND org.effective_end_date(+)) and (inv.reserved_input_value in('RESERVED_INPUT_DAYS','RESERVED_INPUT_HOURS','RESERVED_INPUT_FACTOR','RESERVED_INPUT_RATE','RESERVED_INPUT_PERCENTAGE','SPECIAL_OUTPUT') or inv.base_name ='Not Taken' or inv.base_name like '%Arrears%' or inv.base_name like 'Reduce Regular Absence%' )

SQL_Statement

select ppra.source_action_id object_action_id,

rrv.run_result_id,rrv.input_value_id,

rr.element_type_id,elt.element_name,

elt.output_currency_code,

rrv.result_value,

inv.name as input_value_name,

rr.start_date proration_start_date,rr.end_date proration_end_date,

rr.tax_unit_id,org.name Tax_reporting_name,

inv.uom,elt.processing_priority

from pay_run_result_values rrv,pay_run_results rr,pay_element_types_vl elt, pay_input_values_vl inv,

pay_payroll_rel_actions ppra, HR_ALL_ORGANIZATION_UNITS_F_VL org, pay_payroll_actions ppa

where rr.run_result_id=rrv.run_result_id

and elt.element_type_id=rr.element_type_id

and inv.input_value_id=rrv.input_value_id

and ppra.payroll_rel_action_id=rr.payroll_rel_action_id

and org.organization_id(+)=rr.tax_unit_id

AND ppa.action_type IN ('R','Q','B','V')

and ppa.payroll_action_id=ppra.payroll_action_id

and (ppa.effective_date between inv.effective_start_date and inv.effective_end_date)

AND ( ppa.effective_date BETWEEN elt.effective_start_date AND elt.effective_end_date )

AND ( ppa.effective_date BETWEEN org.effective_start_date(+) AND org.effective_end_date(+))

and (inv.reserved_input_value in('RESERVED_INPUT_DAYS','RESERVED_INPUT_HOURS','RESERVED_INPUT_FACTOR','RESERVED_INPUT_RATE','RESERVED_INPUT_PERCENTAGE','SPECIAL_OUTPUT')

or inv.base_name ='Not Taken' or inv.base_name like '%Arrears%' or inv.base_name like 'Reduce Regular Absence%'

)