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.

APPS.PAY_IE_P35 dependencies on PAY_RUN_RESULT_VALUES

Line 22: l_initial_class pay_run_result_values.result_value%TYPE;

18: l_weeks_at_second_class NUMBER (4);
19: l_weeks_at_third_class NUMBER (4);
20: l_weeks_at_fourth_class NUMBER (4);
21: l_weeks_at_fifth_class NUMBER (4);
22: l_initial_class pay_run_result_values.result_value%TYPE;
23: l_second_class pay_run_result_values.result_value%TYPE;
24: l_third_class pay_run_result_values.result_value%TYPE;
25: l_fourth_class pay_run_result_values.result_value%TYPE;
26: l_fifth_class pay_run_result_values.result_value%TYPE;

Line 23: l_second_class pay_run_result_values.result_value%TYPE;

19: l_weeks_at_third_class NUMBER (4);
20: l_weeks_at_fourth_class NUMBER (4);
21: l_weeks_at_fifth_class NUMBER (4);
22: l_initial_class pay_run_result_values.result_value%TYPE;
23: l_second_class pay_run_result_values.result_value%TYPE;
24: l_third_class pay_run_result_values.result_value%TYPE;
25: l_fourth_class pay_run_result_values.result_value%TYPE;
26: l_fifth_class pay_run_result_values.result_value%TYPE;
27: l_context_value_counter NUMBER (2) := 0;

Line 24: l_third_class pay_run_result_values.result_value%TYPE;

20: l_weeks_at_fourth_class NUMBER (4);
21: l_weeks_at_fifth_class NUMBER (4);
22: l_initial_class pay_run_result_values.result_value%TYPE;
23: l_second_class pay_run_result_values.result_value%TYPE;
24: l_third_class pay_run_result_values.result_value%TYPE;
25: l_fourth_class pay_run_result_values.result_value%TYPE;
26: l_fifth_class pay_run_result_values.result_value%TYPE;
27: l_context_value_counter NUMBER (2) := 0;
28: l_start_date DATE;

Line 25: l_fourth_class pay_run_result_values.result_value%TYPE;

21: l_weeks_at_fifth_class NUMBER (4);
22: l_initial_class pay_run_result_values.result_value%TYPE;
23: l_second_class pay_run_result_values.result_value%TYPE;
24: l_third_class pay_run_result_values.result_value%TYPE;
25: l_fourth_class pay_run_result_values.result_value%TYPE;
26: l_fifth_class pay_run_result_values.result_value%TYPE;
27: l_context_value_counter NUMBER (2) := 0;
28: l_start_date DATE;
29: l_end_date DATE;

Line 26: l_fifth_class pay_run_result_values.result_value%TYPE;

22: l_initial_class pay_run_result_values.result_value%TYPE;
23: l_second_class pay_run_result_values.result_value%TYPE;
24: l_third_class pay_run_result_values.result_value%TYPE;
25: l_fourth_class pay_run_result_values.result_value%TYPE;
26: l_fifth_class pay_run_result_values.result_value%TYPE;
27: l_context_value_counter NUMBER (2) := 0;
28: l_start_date DATE;
29: l_end_date DATE;
30: l_bg_id NUMBER;

Line 37: TYPE type_context_value_tab IS TABLE OF pay_run_result_values.result_value%TYPE

33: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
34:
35:
36: -- declaring the pl/sql table for storing the first 5 contribution class values
37: TYPE type_context_value_tab IS TABLE OF pay_run_result_values.result_value%TYPE
38: INDEX BY BINARY_INTEGER;
39:
40: -- For 5 PRSI classes
41: TYPE prsi_class is record

Line 42: (prsi_class pay_run_result_values.result_value%TYPE,

38: INDEX BY BINARY_INTEGER;
39:
40: -- For 5 PRSI classes
41: TYPE prsi_class is record
42: (prsi_class pay_run_result_values.result_value%TYPE,
43: prsi_class_bal NUMBER(4));
44:
45: TYPE prsi_class_tab IS TABLE OF prsi_class INDEX BY BINARY_INTEGER;
46:

Line 248: pay_run_result_values rrv1

244: per_time_periods ptp,
245: pay_run_results prr,
246: pay_element_types_f pet,
247: pay_input_values_f piv1,
248: pay_run_result_values rrv1
249: WHERE per.person_id = p_person_id
250: AND per.current_employee_flag = 'Y'
251: AND per.effective_start_date =
252: (SELECT MIN (per2.effective_start_date)

Line 966: FROM pay_run_result_values prrv,

962:
963: -- Dont create action if the latest tax basis is exclusion 5867343
964: CURSOR csr_exclusion (p_action_id NUMBER) IS
965: SELECT 'Y', ppa.action_type
966: FROM pay_run_result_values prrv,
967: pay_run_results prr,
968: pay_input_values_f pivf,
969: pay_element_types_f pet,
970: pay_assignment_actions paa,

Line 1189: l_arch_totwks_insurble_emplmnt pay_run_result_values.result_value%TYPE;

1185: l_arch_payroll_action_id pay_assignment_actions.payroll_action_id%TYPE;
1186: l_arch_annual_tax_credit pay_action_information.action_information26%TYPE;
1187: l_arch_term_date pay_action_information.action_information25%TYPE;
1188: l_arch_mothers_name per_people_f.per_information1%TYPE;
1189: l_arch_totwks_insurble_emplmnt pay_run_result_values.result_value%TYPE;
1190: l_arch_initial_class pay_run_result_values.result_value%TYPE;
1191: l_arch_second_class pay_run_result_values.result_value%TYPE;
1192: l_arch_third_class pay_run_result_values.result_value%TYPE;
1193: l_arch_fourth_class pay_run_result_values.result_value%TYPE;

Line 1190: l_arch_initial_class pay_run_result_values.result_value%TYPE;

1186: l_arch_annual_tax_credit pay_action_information.action_information26%TYPE;
1187: l_arch_term_date pay_action_information.action_information25%TYPE;
1188: l_arch_mothers_name per_people_f.per_information1%TYPE;
1189: l_arch_totwks_insurble_emplmnt pay_run_result_values.result_value%TYPE;
1190: l_arch_initial_class pay_run_result_values.result_value%TYPE;
1191: l_arch_second_class pay_run_result_values.result_value%TYPE;
1192: l_arch_third_class pay_run_result_values.result_value%TYPE;
1193: l_arch_fourth_class pay_run_result_values.result_value%TYPE;
1194: l_arch_fifth_class pay_run_result_values.result_value%TYPE;

Line 1191: l_arch_second_class pay_run_result_values.result_value%TYPE;

1187: l_arch_term_date pay_action_information.action_information25%TYPE;
1188: l_arch_mothers_name per_people_f.per_information1%TYPE;
1189: l_arch_totwks_insurble_emplmnt pay_run_result_values.result_value%TYPE;
1190: l_arch_initial_class pay_run_result_values.result_value%TYPE;
1191: l_arch_second_class pay_run_result_values.result_value%TYPE;
1192: l_arch_third_class pay_run_result_values.result_value%TYPE;
1193: l_arch_fourth_class pay_run_result_values.result_value%TYPE;
1194: l_arch_fifth_class pay_run_result_values.result_value%TYPE;
1195: l_arch_weeks_at_initial_class pay_run_result_values.result_value%TYPE;

Line 1192: l_arch_third_class pay_run_result_values.result_value%TYPE;

1188: l_arch_mothers_name per_people_f.per_information1%TYPE;
1189: l_arch_totwks_insurble_emplmnt pay_run_result_values.result_value%TYPE;
1190: l_arch_initial_class pay_run_result_values.result_value%TYPE;
1191: l_arch_second_class pay_run_result_values.result_value%TYPE;
1192: l_arch_third_class pay_run_result_values.result_value%TYPE;
1193: l_arch_fourth_class pay_run_result_values.result_value%TYPE;
1194: l_arch_fifth_class pay_run_result_values.result_value%TYPE;
1195: l_arch_weeks_at_initial_class pay_run_result_values.result_value%TYPE;
1196: l_arch_weeks_at_second_class pay_run_result_values.result_value%TYPE;

Line 1193: l_arch_fourth_class pay_run_result_values.result_value%TYPE;

1189: l_arch_totwks_insurble_emplmnt pay_run_result_values.result_value%TYPE;
1190: l_arch_initial_class pay_run_result_values.result_value%TYPE;
1191: l_arch_second_class pay_run_result_values.result_value%TYPE;
1192: l_arch_third_class pay_run_result_values.result_value%TYPE;
1193: l_arch_fourth_class pay_run_result_values.result_value%TYPE;
1194: l_arch_fifth_class pay_run_result_values.result_value%TYPE;
1195: l_arch_weeks_at_initial_class pay_run_result_values.result_value%TYPE;
1196: l_arch_weeks_at_second_class pay_run_result_values.result_value%TYPE;
1197: l_arch_weeks_at_third_class pay_run_result_values.result_value%TYPE;

Line 1194: l_arch_fifth_class pay_run_result_values.result_value%TYPE;

1190: l_arch_initial_class pay_run_result_values.result_value%TYPE;
1191: l_arch_second_class pay_run_result_values.result_value%TYPE;
1192: l_arch_third_class pay_run_result_values.result_value%TYPE;
1193: l_arch_fourth_class pay_run_result_values.result_value%TYPE;
1194: l_arch_fifth_class pay_run_result_values.result_value%TYPE;
1195: l_arch_weeks_at_initial_class pay_run_result_values.result_value%TYPE;
1196: l_arch_weeks_at_second_class pay_run_result_values.result_value%TYPE;
1197: l_arch_weeks_at_third_class pay_run_result_values.result_value%TYPE;
1198: l_arch_weeks_at_fourth_class pay_run_result_values.result_value%TYPE;

Line 1195: l_arch_weeks_at_initial_class pay_run_result_values.result_value%TYPE;

1191: l_arch_second_class pay_run_result_values.result_value%TYPE;
1192: l_arch_third_class pay_run_result_values.result_value%TYPE;
1193: l_arch_fourth_class pay_run_result_values.result_value%TYPE;
1194: l_arch_fifth_class pay_run_result_values.result_value%TYPE;
1195: l_arch_weeks_at_initial_class pay_run_result_values.result_value%TYPE;
1196: l_arch_weeks_at_second_class pay_run_result_values.result_value%TYPE;
1197: l_arch_weeks_at_third_class pay_run_result_values.result_value%TYPE;
1198: l_arch_weeks_at_fourth_class pay_run_result_values.result_value%TYPE;
1199: l_arch_weeks_at_fifth_class pay_run_result_values.result_value%TYPE;

Line 1196: l_arch_weeks_at_second_class pay_run_result_values.result_value%TYPE;

1192: l_arch_third_class pay_run_result_values.result_value%TYPE;
1193: l_arch_fourth_class pay_run_result_values.result_value%TYPE;
1194: l_arch_fifth_class pay_run_result_values.result_value%TYPE;
1195: l_arch_weeks_at_initial_class pay_run_result_values.result_value%TYPE;
1196: l_arch_weeks_at_second_class pay_run_result_values.result_value%TYPE;
1197: l_arch_weeks_at_third_class pay_run_result_values.result_value%TYPE;
1198: l_arch_weeks_at_fourth_class pay_run_result_values.result_value%TYPE;
1199: l_arch_weeks_at_fifth_class pay_run_result_values.result_value%TYPE;
1200: l_arch_net_tax pay_action_information.action_information4%TYPE;

Line 1197: l_arch_weeks_at_third_class pay_run_result_values.result_value%TYPE;

1193: l_arch_fourth_class pay_run_result_values.result_value%TYPE;
1194: l_arch_fifth_class pay_run_result_values.result_value%TYPE;
1195: l_arch_weeks_at_initial_class pay_run_result_values.result_value%TYPE;
1196: l_arch_weeks_at_second_class pay_run_result_values.result_value%TYPE;
1197: l_arch_weeks_at_third_class pay_run_result_values.result_value%TYPE;
1198: l_arch_weeks_at_fourth_class pay_run_result_values.result_value%TYPE;
1199: l_arch_weeks_at_fifth_class pay_run_result_values.result_value%TYPE;
1200: l_arch_net_tax pay_action_information.action_information4%TYPE;
1201: l_arch_tax_or_refund pay_action_information.action_information4%TYPE;

Line 1198: l_arch_weeks_at_fourth_class pay_run_result_values.result_value%TYPE;

1194: l_arch_fifth_class pay_run_result_values.result_value%TYPE;
1195: l_arch_weeks_at_initial_class pay_run_result_values.result_value%TYPE;
1196: l_arch_weeks_at_second_class pay_run_result_values.result_value%TYPE;
1197: l_arch_weeks_at_third_class pay_run_result_values.result_value%TYPE;
1198: l_arch_weeks_at_fourth_class pay_run_result_values.result_value%TYPE;
1199: l_arch_weeks_at_fifth_class pay_run_result_values.result_value%TYPE;
1200: l_arch_net_tax pay_action_information.action_information4%TYPE;
1201: l_arch_tax_or_refund pay_action_information.action_information4%TYPE;
1202: l_arch_employees_prsi_cont pay_action_information.action_information4%TYPE;

Line 1199: l_arch_weeks_at_fifth_class pay_run_result_values.result_value%TYPE;

1195: l_arch_weeks_at_initial_class pay_run_result_values.result_value%TYPE;
1196: l_arch_weeks_at_second_class pay_run_result_values.result_value%TYPE;
1197: l_arch_weeks_at_third_class pay_run_result_values.result_value%TYPE;
1198: l_arch_weeks_at_fourth_class pay_run_result_values.result_value%TYPE;
1199: l_arch_weeks_at_fifth_class pay_run_result_values.result_value%TYPE;
1200: l_arch_net_tax pay_action_information.action_information4%TYPE;
1201: l_arch_tax_or_refund pay_action_information.action_information4%TYPE;
1202: l_arch_employees_prsi_cont pay_action_information.action_information4%TYPE;
1203: l_arch_total_prsi_cont pay_action_information.action_information4%TYPE;

Line 2108: l_this_insurable_weeks pay_run_result_values.result_value%TYPE;

2104: l_temp_tax pay_action_information.action_information4%TYPE;
2105:
2106: -- end P60
2107: -- For P60 changes to PRSI section
2108: l_this_insurable_weeks pay_run_result_values.result_value%TYPE;
2109: l_this_emp_prsi_cont pay_run_result_values.result_value%TYPE;
2110: l_this_tot_prsi pay_run_result_values.result_value%TYPE;
2111: l_this_initial_class pay_run_result_values.result_value%TYPE;
2112: l_this_sec_class pay_run_result_values.result_value%TYPE;

Line 2109: l_this_emp_prsi_cont pay_run_result_values.result_value%TYPE;

2105:
2106: -- end P60
2107: -- For P60 changes to PRSI section
2108: l_this_insurable_weeks pay_run_result_values.result_value%TYPE;
2109: l_this_emp_prsi_cont pay_run_result_values.result_value%TYPE;
2110: l_this_tot_prsi pay_run_result_values.result_value%TYPE;
2111: l_this_initial_class pay_run_result_values.result_value%TYPE;
2112: l_this_sec_class pay_run_result_values.result_value%TYPE;
2113: l_this_weeks_at_sec_class pay_run_result_values.result_value%TYPE;

Line 2110: l_this_tot_prsi pay_run_result_values.result_value%TYPE;

2106: -- end P60
2107: -- For P60 changes to PRSI section
2108: l_this_insurable_weeks pay_run_result_values.result_value%TYPE;
2109: l_this_emp_prsi_cont pay_run_result_values.result_value%TYPE;
2110: l_this_tot_prsi pay_run_result_values.result_value%TYPE;
2111: l_this_initial_class pay_run_result_values.result_value%TYPE;
2112: l_this_sec_class pay_run_result_values.result_value%TYPE;
2113: l_this_weeks_at_sec_class pay_run_result_values.result_value%TYPE;
2114: -- end P60 changes to PRSI section

Line 2111: l_this_initial_class pay_run_result_values.result_value%TYPE;

2107: -- For P60 changes to PRSI section
2108: l_this_insurable_weeks pay_run_result_values.result_value%TYPE;
2109: l_this_emp_prsi_cont pay_run_result_values.result_value%TYPE;
2110: l_this_tot_prsi pay_run_result_values.result_value%TYPE;
2111: l_this_initial_class pay_run_result_values.result_value%TYPE;
2112: l_this_sec_class pay_run_result_values.result_value%TYPE;
2113: l_this_weeks_at_sec_class pay_run_result_values.result_value%TYPE;
2114: -- end P60 changes to PRSI section
2115:

Line 2112: l_this_sec_class pay_run_result_values.result_value%TYPE;

2108: l_this_insurable_weeks pay_run_result_values.result_value%TYPE;
2109: l_this_emp_prsi_cont pay_run_result_values.result_value%TYPE;
2110: l_this_tot_prsi pay_run_result_values.result_value%TYPE;
2111: l_this_initial_class pay_run_result_values.result_value%TYPE;
2112: l_this_sec_class pay_run_result_values.result_value%TYPE;
2113: l_this_weeks_at_sec_class pay_run_result_values.result_value%TYPE;
2114: -- end P60 changes to PRSI section
2115:
2116: --6633719

Line 2113: l_this_weeks_at_sec_class pay_run_result_values.result_value%TYPE;

2109: l_this_emp_prsi_cont pay_run_result_values.result_value%TYPE;
2110: l_this_tot_prsi pay_run_result_values.result_value%TYPE;
2111: l_this_initial_class pay_run_result_values.result_value%TYPE;
2112: l_this_sec_class pay_run_result_values.result_value%TYPE;
2113: l_this_weeks_at_sec_class pay_run_result_values.result_value%TYPE;
2114: -- end P60 changes to PRSI section
2115:
2116: --6633719
2117: l_ppsn_override per_assignment_extra_info.aei_information1%type;

Line 4727: pay_run_result_values rrv1,

4723: per_time_periods ptp,
4724: pay_run_results prr,
4725: pay_element_types_f pet,
4726: pay_input_values_f piv1,
4727: pay_run_result_values rrv1,
4728: per_assignment_extra_info paei --6633719
4729: WHERE per.person_id = p_person_id
4730: --6633719 these condition added to fetch the contexes having similar PPSN OVERRIDE if given
4731: AND paei.assignment_id(+) = asg.assignment_id

Line 4847: pay_run_result_values rrv1

4843: per_time_periods ptp,
4844: pay_run_results prr,
4845: pay_element_types_f pet,
4846: pay_input_values_f piv1,
4847: pay_run_result_values rrv1
4848: WHERE per.person_id = p_person_id
4849: --ANd asg.assignment_id = p_assignment_id -- vik added code for getting values for given assignment
4850: AND per.effective_start_date =
4851: (SELECT MIN (per2.effective_start_date)