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 72: TYPE supp_wk_tab is table of number INDEX BY pay_run_result_values.result_value%TYPE;

68: p_start_date DATE;
69: p_end_date DATE;
70:
71: --8259095
72: TYPE supp_wk_tab is table of number INDEX BY pay_run_result_values.result_value%TYPE;
73: l_supp_wk_tab supp_wk_tab;
74: l_supp_wk_tab_empty supp_wk_tab; --9080372
75: --8259095
76:

Line 255: pay_run_result_values rrv1

251: per_time_periods ptp,
252: pay_run_results prr,
253: pay_element_types_f pet,
254: pay_input_values_f piv1,
255: pay_run_result_values rrv1
256: WHERE per.person_id = p_person_id
257: AND per.current_employee_flag = 'Y'
258: AND per.effective_start_date =
259: (SELECT MIN (per2.effective_start_date)

Line 975: FROM pay_run_result_values prrv,

971: /* --8322991
972: -- Dont create action if the latest tax basis is exclusion 5867343
973: CURSOR csr_exclusion (p_action_id NUMBER) IS
974: SELECT 'Y', ppa.action_type
975: FROM pay_run_result_values prrv,
976: pay_run_results prr,
977: pay_input_values_f pivf,
978: pay_element_types_f pet,
979: pay_assignment_actions paa,

Line 997: FROM pay_run_result_values prrv,

993: --8322991
994: -- Dont create action if the tax basis is exclusion for whole year(Tax Period).
995: CURSOR csr_exclusion_year (p_action_id_min NUMBER, p_action_id_max NUMBER, p_asg_id NUMBER) IS
996: SELECT count(1) cnt
997: FROM pay_run_result_values prrv,
998: pay_run_results prr,
999: pay_input_values_f pivf,
1000: pay_element_types_f pet,
1001: pay_assignment_actions paa,

Line 1446: l_arch_totwks_insurble_emplmnt pay_run_result_values.result_value%TYPE;

1442: l_arch_payroll_action_id pay_assignment_actions.payroll_action_id%TYPE;
1443: l_arch_annual_tax_credit pay_action_information.action_information26%TYPE;
1444: l_arch_term_date pay_action_information.action_information25%TYPE;
1445: l_arch_mothers_name per_people_f.per_information1%TYPE;
1446: l_arch_totwks_insurble_emplmnt pay_run_result_values.result_value%TYPE;
1447: l_arch_initial_class pay_run_result_values.result_value%TYPE;
1448: l_arch_second_class pay_run_result_values.result_value%TYPE;
1449: l_arch_third_class pay_run_result_values.result_value%TYPE;
1450: l_arch_fourth_class pay_run_result_values.result_value%TYPE;

Line 1447: l_arch_initial_class pay_run_result_values.result_value%TYPE;

1443: l_arch_annual_tax_credit pay_action_information.action_information26%TYPE;
1444: l_arch_term_date pay_action_information.action_information25%TYPE;
1445: l_arch_mothers_name per_people_f.per_information1%TYPE;
1446: l_arch_totwks_insurble_emplmnt pay_run_result_values.result_value%TYPE;
1447: l_arch_initial_class pay_run_result_values.result_value%TYPE;
1448: l_arch_second_class pay_run_result_values.result_value%TYPE;
1449: l_arch_third_class pay_run_result_values.result_value%TYPE;
1450: l_arch_fourth_class pay_run_result_values.result_value%TYPE;
1451: l_arch_fifth_class pay_run_result_values.result_value%TYPE;

Line 1448: l_arch_second_class pay_run_result_values.result_value%TYPE;

1444: l_arch_term_date pay_action_information.action_information25%TYPE;
1445: l_arch_mothers_name per_people_f.per_information1%TYPE;
1446: l_arch_totwks_insurble_emplmnt pay_run_result_values.result_value%TYPE;
1447: l_arch_initial_class pay_run_result_values.result_value%TYPE;
1448: l_arch_second_class pay_run_result_values.result_value%TYPE;
1449: l_arch_third_class pay_run_result_values.result_value%TYPE;
1450: l_arch_fourth_class pay_run_result_values.result_value%TYPE;
1451: l_arch_fifth_class pay_run_result_values.result_value%TYPE;
1452: l_arch_weeks_at_initial_class pay_run_result_values.result_value%TYPE;

Line 1449: l_arch_third_class pay_run_result_values.result_value%TYPE;

1445: l_arch_mothers_name per_people_f.per_information1%TYPE;
1446: l_arch_totwks_insurble_emplmnt pay_run_result_values.result_value%TYPE;
1447: l_arch_initial_class pay_run_result_values.result_value%TYPE;
1448: l_arch_second_class pay_run_result_values.result_value%TYPE;
1449: l_arch_third_class pay_run_result_values.result_value%TYPE;
1450: l_arch_fourth_class pay_run_result_values.result_value%TYPE;
1451: l_arch_fifth_class pay_run_result_values.result_value%TYPE;
1452: l_arch_weeks_at_initial_class pay_run_result_values.result_value%TYPE;
1453: l_arch_weeks_at_second_class pay_run_result_values.result_value%TYPE;

Line 1450: l_arch_fourth_class pay_run_result_values.result_value%TYPE;

1446: l_arch_totwks_insurble_emplmnt pay_run_result_values.result_value%TYPE;
1447: l_arch_initial_class pay_run_result_values.result_value%TYPE;
1448: l_arch_second_class pay_run_result_values.result_value%TYPE;
1449: l_arch_third_class pay_run_result_values.result_value%TYPE;
1450: l_arch_fourth_class pay_run_result_values.result_value%TYPE;
1451: l_arch_fifth_class pay_run_result_values.result_value%TYPE;
1452: l_arch_weeks_at_initial_class pay_run_result_values.result_value%TYPE;
1453: l_arch_weeks_at_second_class pay_run_result_values.result_value%TYPE;
1454: l_arch_weeks_at_third_class pay_run_result_values.result_value%TYPE;

Line 1451: l_arch_fifth_class pay_run_result_values.result_value%TYPE;

1447: l_arch_initial_class pay_run_result_values.result_value%TYPE;
1448: l_arch_second_class pay_run_result_values.result_value%TYPE;
1449: l_arch_third_class pay_run_result_values.result_value%TYPE;
1450: l_arch_fourth_class pay_run_result_values.result_value%TYPE;
1451: l_arch_fifth_class pay_run_result_values.result_value%TYPE;
1452: l_arch_weeks_at_initial_class pay_run_result_values.result_value%TYPE;
1453: l_arch_weeks_at_second_class pay_run_result_values.result_value%TYPE;
1454: l_arch_weeks_at_third_class pay_run_result_values.result_value%TYPE;
1455: l_arch_weeks_at_fourth_class pay_run_result_values.result_value%TYPE;

Line 1452: l_arch_weeks_at_initial_class pay_run_result_values.result_value%TYPE;

1448: l_arch_second_class pay_run_result_values.result_value%TYPE;
1449: l_arch_third_class pay_run_result_values.result_value%TYPE;
1450: l_arch_fourth_class pay_run_result_values.result_value%TYPE;
1451: l_arch_fifth_class pay_run_result_values.result_value%TYPE;
1452: l_arch_weeks_at_initial_class pay_run_result_values.result_value%TYPE;
1453: l_arch_weeks_at_second_class pay_run_result_values.result_value%TYPE;
1454: l_arch_weeks_at_third_class pay_run_result_values.result_value%TYPE;
1455: l_arch_weeks_at_fourth_class pay_run_result_values.result_value%TYPE;
1456: l_arch_weeks_at_fifth_class pay_run_result_values.result_value%TYPE;

Line 1453: l_arch_weeks_at_second_class pay_run_result_values.result_value%TYPE;

1449: l_arch_third_class pay_run_result_values.result_value%TYPE;
1450: l_arch_fourth_class pay_run_result_values.result_value%TYPE;
1451: l_arch_fifth_class pay_run_result_values.result_value%TYPE;
1452: l_arch_weeks_at_initial_class pay_run_result_values.result_value%TYPE;
1453: l_arch_weeks_at_second_class pay_run_result_values.result_value%TYPE;
1454: l_arch_weeks_at_third_class pay_run_result_values.result_value%TYPE;
1455: l_arch_weeks_at_fourth_class pay_run_result_values.result_value%TYPE;
1456: l_arch_weeks_at_fifth_class pay_run_result_values.result_value%TYPE;
1457: l_arch_net_tax pay_action_information.action_information4%TYPE;

Line 1454: l_arch_weeks_at_third_class pay_run_result_values.result_value%TYPE;

1450: l_arch_fourth_class pay_run_result_values.result_value%TYPE;
1451: l_arch_fifth_class pay_run_result_values.result_value%TYPE;
1452: l_arch_weeks_at_initial_class pay_run_result_values.result_value%TYPE;
1453: l_arch_weeks_at_second_class pay_run_result_values.result_value%TYPE;
1454: l_arch_weeks_at_third_class pay_run_result_values.result_value%TYPE;
1455: l_arch_weeks_at_fourth_class pay_run_result_values.result_value%TYPE;
1456: l_arch_weeks_at_fifth_class pay_run_result_values.result_value%TYPE;
1457: l_arch_net_tax pay_action_information.action_information4%TYPE;
1458: l_arch_tax_or_refund pay_action_information.action_information4%TYPE;

Line 1455: l_arch_weeks_at_fourth_class pay_run_result_values.result_value%TYPE;

1451: l_arch_fifth_class pay_run_result_values.result_value%TYPE;
1452: l_arch_weeks_at_initial_class pay_run_result_values.result_value%TYPE;
1453: l_arch_weeks_at_second_class pay_run_result_values.result_value%TYPE;
1454: l_arch_weeks_at_third_class pay_run_result_values.result_value%TYPE;
1455: l_arch_weeks_at_fourth_class pay_run_result_values.result_value%TYPE;
1456: l_arch_weeks_at_fifth_class pay_run_result_values.result_value%TYPE;
1457: l_arch_net_tax pay_action_information.action_information4%TYPE;
1458: l_arch_tax_or_refund pay_action_information.action_information4%TYPE;
1459: l_arch_employees_prsi_cont pay_action_information.action_information4%TYPE;

Line 1456: l_arch_weeks_at_fifth_class pay_run_result_values.result_value%TYPE;

1452: l_arch_weeks_at_initial_class pay_run_result_values.result_value%TYPE;
1453: l_arch_weeks_at_second_class pay_run_result_values.result_value%TYPE;
1454: l_arch_weeks_at_third_class pay_run_result_values.result_value%TYPE;
1455: l_arch_weeks_at_fourth_class pay_run_result_values.result_value%TYPE;
1456: l_arch_weeks_at_fifth_class pay_run_result_values.result_value%TYPE;
1457: l_arch_net_tax pay_action_information.action_information4%TYPE;
1458: l_arch_tax_or_refund pay_action_information.action_information4%TYPE;
1459: l_arch_employees_prsi_cont pay_action_information.action_information4%TYPE;
1460: l_arch_total_prsi_cont pay_action_information.action_information4%TYPE;

Line 2557: l_this_insurable_weeks pay_run_result_values.result_value%TYPE;

2553: l_temp_tax pay_action_information.action_information4%TYPE;
2554:
2555: -- end P60
2556: -- For P60 changes to PRSI section
2557: l_this_insurable_weeks pay_run_result_values.result_value%TYPE;
2558: l_this_emp_prsi_cont pay_run_result_values.result_value%TYPE;
2559: l_this_tot_prsi pay_run_result_values.result_value%TYPE;
2560: l_this_initial_class pay_run_result_values.result_value%TYPE;
2561: l_this_sec_class pay_run_result_values.result_value%TYPE;

Line 2558: l_this_emp_prsi_cont pay_run_result_values.result_value%TYPE;

2554:
2555: -- end P60
2556: -- For P60 changes to PRSI section
2557: l_this_insurable_weeks pay_run_result_values.result_value%TYPE;
2558: l_this_emp_prsi_cont pay_run_result_values.result_value%TYPE;
2559: l_this_tot_prsi pay_run_result_values.result_value%TYPE;
2560: l_this_initial_class pay_run_result_values.result_value%TYPE;
2561: l_this_sec_class pay_run_result_values.result_value%TYPE;
2562: l_this_weeks_at_sec_class pay_run_result_values.result_value%TYPE;

Line 2559: l_this_tot_prsi pay_run_result_values.result_value%TYPE;

2555: -- end P60
2556: -- For P60 changes to PRSI section
2557: l_this_insurable_weeks pay_run_result_values.result_value%TYPE;
2558: l_this_emp_prsi_cont pay_run_result_values.result_value%TYPE;
2559: l_this_tot_prsi pay_run_result_values.result_value%TYPE;
2560: l_this_initial_class pay_run_result_values.result_value%TYPE;
2561: l_this_sec_class pay_run_result_values.result_value%TYPE;
2562: l_this_weeks_at_sec_class pay_run_result_values.result_value%TYPE;
2563: -- end P60 changes to PRSI section

Line 2560: l_this_initial_class pay_run_result_values.result_value%TYPE;

2556: -- For P60 changes to PRSI section
2557: l_this_insurable_weeks pay_run_result_values.result_value%TYPE;
2558: l_this_emp_prsi_cont pay_run_result_values.result_value%TYPE;
2559: l_this_tot_prsi pay_run_result_values.result_value%TYPE;
2560: l_this_initial_class pay_run_result_values.result_value%TYPE;
2561: l_this_sec_class pay_run_result_values.result_value%TYPE;
2562: l_this_weeks_at_sec_class pay_run_result_values.result_value%TYPE;
2563: -- end P60 changes to PRSI section
2564:

Line 2561: l_this_sec_class pay_run_result_values.result_value%TYPE;

2557: l_this_insurable_weeks pay_run_result_values.result_value%TYPE;
2558: l_this_emp_prsi_cont pay_run_result_values.result_value%TYPE;
2559: l_this_tot_prsi pay_run_result_values.result_value%TYPE;
2560: l_this_initial_class pay_run_result_values.result_value%TYPE;
2561: l_this_sec_class pay_run_result_values.result_value%TYPE;
2562: l_this_weeks_at_sec_class pay_run_result_values.result_value%TYPE;
2563: -- end P60 changes to PRSI section
2564:
2565: --6633719

Line 2562: l_this_weeks_at_sec_class pay_run_result_values.result_value%TYPE;

2558: l_this_emp_prsi_cont pay_run_result_values.result_value%TYPE;
2559: l_this_tot_prsi pay_run_result_values.result_value%TYPE;
2560: l_this_initial_class pay_run_result_values.result_value%TYPE;
2561: l_this_sec_class pay_run_result_values.result_value%TYPE;
2562: l_this_weeks_at_sec_class pay_run_result_values.result_value%TYPE;
2563: -- end P60 changes to PRSI section
2564:
2565: --6633719
2566: l_ppsn_override per_assignment_extra_info.aei_information1%type;

Line 2630: FROM pay_run_result_values prrv,

2626:
2627:
2628: CURSOR csr_exclusion_flag (p_action_id_min NUMBER, p_action_id_max NUMBER, p_asg_id NUMBER) IS
2629: SELECT count(1) cnt
2630: FROM pay_run_result_values prrv,
2631: pay_run_results prr,
2632: pay_input_values_f pivf,
2633: pay_element_types_f pet,
2634: pay_assignment_actions paa,

Line 7792: pay_run_result_values rrv1,

7788: per_time_periods ptp,
7789: pay_run_results prr,
7790: pay_element_types_f pet,
7791: pay_input_values_f piv1,
7792: pay_run_result_values rrv1,
7793: per_assignment_extra_info paei --6633719
7794: WHERE per.person_id = p_person_id
7795: --6633719 these condition added to fetch the contexes having similar PPSN OVERRIDE if given
7796: AND paei.assignment_id(+) = asg.assignment_id

Line 7914: pay_run_result_values rrv1

7910: per_time_periods ptp,
7911: pay_run_results prr,
7912: pay_element_types_f pet,
7913: pay_input_values_f piv1,
7914: pay_run_result_values rrv1
7915: WHERE per.person_id = p_person_id
7916: --ANd asg.assignment_id = p_assignment_id -- vik added code for getting values for given assignment
7917: AND per.effective_start_date =
7918: (SELECT MIN (per2.effective_start_date)

Line 8024: pay_run_result_values rrv1,

8020: per_time_periods ptp,
8021: pay_run_results prr,
8022: pay_element_types_f pet,
8023: pay_input_values_f piv1,
8024: pay_run_result_values rrv1,
8025: per_assignment_extra_info paei
8026: WHERE per.person_id = p_person_id
8027: AND paei.assignment_id(+) = asg.assignment_id
8028: AND paei.aei_information_category(+) = 'IE_ASG_OVERRIDE'

Line 8075: l_supp_run_class pay_run_result_values.result_value%type;

8071: asg.person_id,
8072: ptp.time_period_id
8073: ORDER BY min_eff_date;
8074:
8075: l_supp_run_class pay_run_result_values.result_value%type;
8076: TYPE type_context_name IS table of c_context_name%rowtype INDEX BY BINARY_INTEGER;
8077: l_type_context_name_tab type_context_name;
8078: --8259095
8079: