eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_DK_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 2046: FROM pay_run_result_values rrv

2042: CURSOR csr_result_value(p_iv_id NUMBER
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

Line 2067: FROM pay_run_result_values rrv

2063: ,p_ele_type_id NUMBER
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

Line 2101: FROM pay_run_result_values rrv

2097: ) IS
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

Line 2128: FROM pay_run_result_values rrv1

2124: ) IS
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

Line 2132: ,pay_run_result_values rrv2

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
2134: ,pay_run_result_values rrv3
2135: ,pay_run_results rr3
2136: WHERE rrv1.input_value_id = p_iv_id_UNIT

Line 2134: ,pay_run_result_values rrv3

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
2138: AND rr1.run_result_id = rrv1.run_result_id

Line 2163: FROM pay_run_result_values rrv1

2159: ,p_ele_type_id NUMBER
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

Line 2167: ,pay_run_result_values rrv2

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
2169: ,pay_run_result_values rrv3
2170: ,pay_run_results rr3
2171: WHERE rrv1.input_value_id = p_iv_id_UNIT

Line 2169: ,pay_run_result_values rrv3

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
2173: AND rr1.run_result_id = rrv1.run_result_id

Line 2194: -- l_result_value pay_run_result_values.result_value%TYPE := 0;

2190: -- End Changes for Payslip w.r.t bug - 7229247
2191:
2192: rec_get_element csr_get_element%ROWTYPE;
2193: /*Bug fix 6193177*/
2194: -- l_result_value pay_run_result_values.result_value%TYPE := 0;
2195: l_result_value pay_run_result_values.result_value%TYPE ;
2196: l_action_info_id NUMBER;
2197: l_ovn NUMBER;
2198: l_element_context VARCHAR2(10);

Line 2195: l_result_value pay_run_result_values.result_value%TYPE ;

2191:
2192: rec_get_element csr_get_element%ROWTYPE;
2193: /*Bug fix 6193177*/
2194: -- l_result_value pay_run_result_values.result_value%TYPE := 0;
2195: l_result_value pay_run_result_values.result_value%TYPE ;
2196: l_action_info_id NUMBER;
2197: l_ovn NUMBER;
2198: l_element_context VARCHAR2(10);
2199: l_index NUMBER := 0;

Line 3711: FROM pay_run_result_values rrv

3707: SELECT rrv.result_value result_value,
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

Line 3752: pay_run_result_values rrv

3748: CURSOR csr_get_pp_name(p_effective_date DATE ,
3749: p_run_result_id NUMBER) IS
3750: SELECT hou.name
3751: FROM
3752: pay_run_result_values rrv
3753: , pay_input_values_f iv
3754: , hr_organization_units hou
3755: WHERE rrv.run_result_id = p_run_result_id
3756: AND rrv.input_value_id = iv.input_value_id

Line 3785: FROM pay_run_result_values rrv

3781: ,p_ele_type_id NUMBER
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

Line 3808: FROM pay_run_result_values rrv

3804: ) IS
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

Line 3835: FROM pay_run_result_values rrv1

3831: ) IS
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

Line 3839: ,pay_run_result_values rrv2

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
3841: ,pay_run_result_values rrv3
3842: ,pay_run_results rr3
3843: WHERE rrv1.input_value_id = p_iv_id_UNIT

Line 3841: ,pay_run_result_values rrv3

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
3845: AND rr1.run_result_id = rrv1.run_result_id

Line 3871: FROM pay_run_result_values rrv1

3867: ) IS
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

Line 3875: ,pay_run_result_values rrv2

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
3877: ,pay_run_result_values rrv3
3878: ,pay_run_results rr3
3879: WHERE rrv1.input_value_id = p_iv_id_UNIT

Line 3877: ,pay_run_result_values rrv3

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
3881: AND rr1.run_result_id = rrv1.run_result_id

Line 3902: l_result_value pay_run_result_values.result_value%TYPE :=0 ;

3898:
3899:
3900:
3901:
3902: l_result_value pay_run_result_values.result_value%TYPE :=0 ;
3903: l_action_info_id NUMBER;
3904: l_ovn NUMBER;
3905: l_element_context VARCHAR2(10);
3906: l_index NUMBER := 0;