[Home] [Help]
2043: ,p_ele_type_id NUMBER
2044: ,p_assignment_action_id NUMBER) IS
2045: SELECT rrv.result_value,rr.element_entry_id
2046: FROM pay_run_result_values rrv
2047: ,pay_run_results rr
2048: ,pay_assignment_actions paa
2049: ,pay_payroll_actions ppa
2050: WHERE rrv.input_value_id = p_iv_id
2051: AND rr.element_type_id = p_ele_type_id
2064: ,p_assignment_action_id NUMBER
2065: ,p_EE_ID NUMBER) IS
2066: SELECT rrv.result_value
2067: FROM pay_run_result_values rrv
2068: ,pay_run_results rr
2069: ,pay_assignment_actions paa
2070: ,pay_payroll_actions ppa
2071: WHERE rrv.input_value_id = p_iv_id
2072: AND rr.element_type_id = p_ele_type_id
2098: SELECT sum(fnd_number.canonical_to_number(rrv.result_value)) result_value
2099: ,count(rrv.RUN_RESULT_ID) record_count
2100: ,rrv.result_value UNIT_PRICE
2101: FROM pay_run_result_values rrv
2102: ,pay_run_results rr
2103: ,pay_assignment_actions paa
2104: ,pay_payroll_actions ppa
2105: WHERE rrv.input_value_id = p_iv_id
2106: AND rr.element_type_id = p_ele_type_id
2125: SELECT rrv3.result_value UNIT_PRICE ,
2126: sum(fnd_number.canonical_to_number(rrv1.result_value)) UNIT,
2127: sum(fnd_number.canonical_to_number(rrv2.result_value)) AMOUNT
2128: FROM pay_run_result_values rrv1
2129: ,pay_run_results rr1
2130: ,pay_assignment_actions paa
2131: ,pay_payroll_actions ppa
2132: ,pay_run_result_values rrv2
2133: ,pay_run_results rr2
2129: ,pay_run_results rr1
2130: ,pay_assignment_actions paa
2131: ,pay_payroll_actions ppa
2132: ,pay_run_result_values rrv2
2133: ,pay_run_results rr2
2134: ,pay_run_result_values rrv3
2135: ,pay_run_results rr3
2136: WHERE rrv1.input_value_id = p_iv_id_UNIT
2137: AND rr1.element_type_id = p_ele_type_id
2131: ,pay_payroll_actions ppa
2132: ,pay_run_result_values rrv2
2133: ,pay_run_results rr2
2134: ,pay_run_result_values rrv3
2135: ,pay_run_results rr3
2136: WHERE rrv1.input_value_id = p_iv_id_UNIT
2137: AND rr1.element_type_id = p_ele_type_id
2138: AND rr1.run_result_id = rrv1.run_result_id
2139: AND rr1.assignment_action_id = paa.assignment_action_id
2160: ,p_assignment_action_id NUMBER
2161: ) IS
2162: SELECT rrv3.result_value UNIT_PRICE , rrv1.result_value UNIT, rrv2.result_value AMOUNT
2163: FROM pay_run_result_values rrv1
2164: ,pay_run_results rr1
2165: ,pay_assignment_actions paa
2166: ,pay_payroll_actions ppa
2167: ,pay_run_result_values rrv2
2168: ,pay_run_results rr2
2164: ,pay_run_results rr1
2165: ,pay_assignment_actions paa
2166: ,pay_payroll_actions ppa
2167: ,pay_run_result_values rrv2
2168: ,pay_run_results rr2
2169: ,pay_run_result_values rrv3
2170: ,pay_run_results rr3
2171: WHERE rrv1.input_value_id = p_iv_id_UNIT
2172: AND rr1.element_type_id = p_ele_type_id
2166: ,pay_payroll_actions ppa
2167: ,pay_run_result_values rrv2
2168: ,pay_run_results rr2
2169: ,pay_run_result_values rrv3
2170: ,pay_run_results rr3
2171: WHERE rrv1.input_value_id = p_iv_id_UNIT
2172: AND rr1.element_type_id = p_ele_type_id
2173: AND rr1.run_result_id = rrv1.run_result_id
2174: AND rr1.assignment_action_id = paa.assignment_action_id
3708: rr.element_entry_id element_entry_id
3709: /* Added for Pension changes */
3710: , rr.run_result_id run_result_id
3711: FROM pay_run_result_values rrv
3712: ,pay_run_results rr
3713: ,pay_assignment_actions paa
3714: ,pay_payroll_actions ppa
3715: WHERE rrv.input_value_id = p_iv_id
3716: AND rr.element_type_id = p_ele_type_id
3782: ,p_assignment_action_id NUMBER
3783: ,p_EE_ID NUMBER) IS
3784: SELECT rrv.result_value
3785: FROM pay_run_result_values rrv
3786: ,pay_run_results rr
3787: ,pay_assignment_actions paa
3788: ,pay_payroll_actions ppa
3789: WHERE rrv.input_value_id = p_iv_id
3790: AND rr.element_type_id = p_ele_type_id
3805: SELECT sum(fnd_number.canonical_to_number(rrv.result_value)) result_value
3806: ,count(rrv.RUN_RESULT_ID) record_count
3807: ,rrv.result_value UNIT_PRICE
3808: FROM pay_run_result_values rrv
3809: ,pay_run_results rr
3810: ,pay_assignment_actions paa
3811: ,pay_payroll_actions ppa
3812: WHERE rrv.input_value_id = p_iv_id
3813: AND rr.element_type_id = p_ele_type_id
3832: SELECT rrv3.result_value UNIT_PRICE ,
3833: sum(fnd_number.canonical_to_number(rrv1.result_value)) UNIT,
3834: sum(fnd_number.canonical_to_number(rrv2.result_value)) AMOUNT
3835: FROM pay_run_result_values rrv1
3836: ,pay_run_results rr1
3837: ,pay_assignment_actions paa
3838: ,pay_payroll_actions ppa
3839: ,pay_run_result_values rrv2
3840: ,pay_run_results rr2
3836: ,pay_run_results rr1
3837: ,pay_assignment_actions paa
3838: ,pay_payroll_actions ppa
3839: ,pay_run_result_values rrv2
3840: ,pay_run_results rr2
3841: ,pay_run_result_values rrv3
3842: ,pay_run_results rr3
3843: WHERE rrv1.input_value_id = p_iv_id_UNIT
3844: AND rr1.element_type_id = p_ele_type_id
3838: ,pay_payroll_actions ppa
3839: ,pay_run_result_values rrv2
3840: ,pay_run_results rr2
3841: ,pay_run_result_values rrv3
3842: ,pay_run_results rr3
3843: WHERE rrv1.input_value_id = p_iv_id_UNIT
3844: AND rr1.element_type_id = p_ele_type_id
3845: AND rr1.run_result_id = rrv1.run_result_id
3846: AND rr1.assignment_action_id = paa.assignment_action_id
3868: SELECT rrv3.result_value UNIT_PRICE ,
3869: rrv1.result_value UNIT,
3870: rrv2.result_value AMOUNT
3871: FROM pay_run_result_values rrv1
3872: ,pay_run_results rr1
3873: ,pay_assignment_actions paa
3874: ,pay_payroll_actions ppa
3875: ,pay_run_result_values rrv2
3876: ,pay_run_results rr2
3872: ,pay_run_results rr1
3873: ,pay_assignment_actions paa
3874: ,pay_payroll_actions ppa
3875: ,pay_run_result_values rrv2
3876: ,pay_run_results rr2
3877: ,pay_run_result_values rrv3
3878: ,pay_run_results rr3
3879: WHERE rrv1.input_value_id = p_iv_id_UNIT
3880: AND rr1.element_type_id = p_ele_type_id
3874: ,pay_payroll_actions ppa
3875: ,pay_run_result_values rrv2
3876: ,pay_run_results rr2
3877: ,pay_run_result_values rrv3
3878: ,pay_run_results rr3
3879: WHERE rrv1.input_value_id = p_iv_id_UNIT
3880: AND rr1.element_type_id = p_ele_type_id
3881: AND rr1.run_result_id = rrv1.run_result_id
3882: AND rr1.assignment_action_id = paa.assignment_action_id