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_GB_P11D_ARCHIVE_SS dependencies on PAY_ACTION_INFORMATION

Line 1028: FROM pay_action_information pai_comp,

1024: CURSOR assignments_to_sum(p_person_id NUMBER, p_emp_ref VARCHAR2, p_emp_name VARCHAR2)
1025: IS
1026: SELECT paa.assignment_action_id, pai_person.action_information1, pai_comp.action_information6,
1027: pai_comp.action_information7
1028: FROM pay_action_information pai_comp,
1029: pay_action_information pai_person,
1030: pay_assignment_actions paa,
1031: pay_payroll_actions ppa
1032: WHERE ppa.payroll_action_id = g_pactid

Line 1029: pay_action_information pai_person,

1025: IS
1026: SELECT paa.assignment_action_id, pai_person.action_information1, pai_comp.action_information6,
1027: pai_comp.action_information7
1028: FROM pay_action_information pai_comp,
1029: pay_action_information pai_person,
1030: pay_assignment_actions paa,
1031: pay_payroll_actions ppa
1032: WHERE ppa.payroll_action_id = g_pactid
1033: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1532: pay_action_information_api.create_action_information(

1528: IS
1529: BEGIN
1530: if to_number(g_param_rep_run) < 2005
1531: then
1532: pay_action_information_api.create_action_information(
1533: p_action_information_id => l_action_info_id,
1534: p_action_context_id => p_assactid,
1535: p_action_context_type => 'AAP',
1536: p_object_version_number => l_ovn,

Line 1573: pay_action_information_api.create_action_information(

1569: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1570: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1571:
1572: --
1573: pay_action_information_api.create_action_information(
1574: p_action_information_id => l_action_info_id,
1575: p_action_context_id => p_assactid,
1576: p_action_context_type => 'AAP',
1577: p_object_version_number => l_ovn,

Line 1613: pay_action_information_api.create_action_information(

1609: p_action_information28 => per_formula_functions.get_number('O6_AMG'),
1610: p_action_information29 => per_formula_functions.get_number('O6_CE') );
1611:
1612: --
1613: pay_action_information_api.create_action_information(
1614: p_action_information_id => l_action_info_id,
1615: p_action_context_id => p_assactid,
1616: p_action_context_type => 'AAP',
1617: p_object_version_number => l_ovn,

Line 1648: pay_action_information_api.create_action_information(

1644: p_action_information23 => per_formula_functions.get_number('INT_MAX_AMT_OUTSTANDING')
1645: );
1646: else
1647: /* Code for year 04/05 onward */
1648: pay_action_information_api.create_action_information(
1649: p_action_information_id => l_action_info_id,
1650: p_action_context_id => p_assactid,
1651: p_action_context_type => 'AAP',
1652: p_object_version_number => l_ovn,

Line 1690: pay_action_information_api.create_action_information(

1686: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1687:
1688: hr_utility.trace('FFFFFF Count : ' || per_formula_functions.get_number('F_COUNT'));
1689: --
1690: pay_action_information_api.create_action_information(
1691: p_action_information_id => l_action_info_id,
1692: p_action_context_id => p_assactid,
1693: p_action_context_type => 'AAP',
1694: p_object_version_number => l_ovn,

Line 1731: pay_action_information_api.create_action_information(

1727: p_action_information29 => per_formula_functions.get_number('N6_CE')
1728: ,p_action_information30 => per_formula_functions.get_number('G_FCE'));
1729:
1730:
1731: pay_action_information_api.create_action_information(
1732: p_action_information_id => l_action_info_id,
1733: p_action_context_id => p_assactid,
1734: p_action_context_type => 'AAP',
1735: p_object_version_number => l_ovn,

Line 1828: from pay_action_information pai,

1824: c_payroll_action_id in number) is
1825: select 'Y'
1826: from dual
1827: where exists (select 'X'
1828: from pay_action_information pai,
1829: pay_assignment_actions paa,
1830: per_all_assignments_f paaf
1831: where paaf.person_id = c_person_id
1832: and paaf.assignment_id = paa.assignment_id

Line 1880: FROM pay_action_information

1876: l_col17_val, l_col18_val, l_col19_val, l_col20_val,
1877: l_col21_val, l_col22_val, l_col23_val, l_col24_val,
1878: l_col25_val, l_col26_val, l_col27_val, l_col28_val,
1879: l_col29_val, l_col30_val
1880: FROM pay_action_information
1881: WHERE action_context_id = p_assignment_action_id AND
1882: action_information_category = 'GB P11D ASSIGNMENT RESULTA'
1883: AND action_context_type = 'AAP';
1884:

Line 1932: FROM pay_action_information

1928: l_col17_val, l_col18_val, l_col19_val, l_col20_val,
1929: l_col21_val, l_col22_val, l_col23_val, l_col24_val,
1930: l_col25_val, l_col26_val, l_col27_val, l_col28_val,
1931: l_col29_val, l_col30_val
1932: FROM pay_action_information
1933: WHERE action_context_id = p_assignment_action_id AND
1934: action_information_category ='GB P11D ASSIGNMENT RESULTB'
1935: AND action_context_type = 'AAP';
1936:

Line 1984: FROM pay_action_information

1980: l_col17_val, l_col18_val, l_col19_val, l_col20_val,
1981: l_col21_val, l_col22_val, l_col23_val, l_col24_val,
1982: l_col25_val, l_col26_val, l_col27_val, l_col28_val,
1983: l_col29_val, l_col30_val
1984: FROM pay_action_information
1985: WHERE action_context_id = p_assignment_action_id AND
1986: action_information_category ='GB P11D ASSIGNMENT RESULTC'
1987: AND action_context_type = 'AAP';
1988:

Line 2045: FROM pay_action_information

2041: l_col17_val, l_col18_val, l_col19_val, l_col20_val,
2042: l_col21_val, l_col22_val, l_col23_val, l_col24_val,
2043: l_col25_val, l_col26_val, l_col28_val, l_col29_val,
2044: l_col30_val
2045: FROM pay_action_information
2046: WHERE action_context_id = p_assignment_action_id AND
2047: action_information_category = 'GB P11D ASSIGNMENT RESULTA'
2048: AND action_context_type = 'AAP';
2049:

Line 2097: FROM pay_action_information

2093: l_col17_val, l_col18_val, l_col19_val, l_col20_val,
2094: l_col21_val, l_col22_val, l_col23_val, l_col24_val,
2095: l_col25_val, l_col26_val, l_col27_val, l_col28_val,
2096: l_col29_val, l_col30_val
2097: FROM pay_action_information
2098: WHERE action_context_id = p_assignment_action_id AND
2099: action_information_category ='GB P11D ASSIGNMENT RESULTB'
2100: AND action_context_type = 'AAP';
2101:

Line 2146: FROM pay_action_information

2142: l_col9_val, l_col12_val,
2143: l_col13_val, l_col14_val, l_col15_val, l_col16_val,
2144: l_col17_val, l_col18_val, l_col19_val, l_col20_val,
2145: l_col21_val, l_col22_val, l_col23_val
2146: FROM pay_action_information
2147: WHERE action_context_id = p_assignment_action_id AND
2148: action_information_category ='GB P11D ASSIGNMENT RESULTC'
2149: AND action_context_type = 'AAP';
2150:

Line 2186: pay_action_information_api.update_action_information(

2182: if to_number(g_param_rep_run) < 2005
2183: then
2184: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTA'
2185: THEN
2186: pay_action_information_api.update_action_information(
2187: p_action_information_id => p_action_info_id,
2188: p_object_version_number => p_ovn,
2189: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2190: p_action_information2 => per_formula_functions.get_number('A_COST'),

Line 2223: pay_action_information_api.update_action_information(

2219: END IF;
2220:
2221: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTB'
2222: THEN
2223: pay_action_information_api.update_action_information(
2224: p_action_information_id => p_action_info_id,
2225: p_object_version_number => p_ovn,
2226: p_action_information1 => per_formula_functions.get_text('N_DESC'),
2227: p_action_information2 => per_formula_functions.get_number('N_COST'),

Line 2259: pay_action_information_api.update_action_information(

2255: END IF;
2256:
2257: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTC'
2258: THEN
2259: pay_action_information_api.update_action_information(
2260: p_action_information_id => p_action_info_id,
2261: p_object_version_number => p_ovn,
2262: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2263: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),

Line 2291: pay_action_information_api.update_action_information(

2287: else
2288: /* Code for year 04/05 onwards */
2289: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTA'
2290: THEN
2291: pay_action_information_api.update_action_information(
2292: p_action_information_id => p_action_info_id,
2293: p_object_version_number => p_ovn,
2294: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2295: p_action_information2 => per_formula_functions.get_number('A_COST'),

Line 2328: pay_action_information_api.update_action_information(

2324: END IF;
2325:
2326: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTB'
2327: THEN
2328: pay_action_information_api.update_action_information(
2329: p_action_information_id => p_action_info_id,
2330: p_object_version_number => p_ovn,
2331: p_action_information1 => per_formula_functions.get_text('M_DESC'),
2332: p_action_information2 => per_formula_functions.get_number('M_COST'),

Line 2366: pay_action_information_api.update_action_information(

2362: END IF;
2363:
2364: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTC'
2365: THEN
2366: pay_action_information_api.update_action_information(
2367: p_action_information_id => p_action_info_id,
2368: p_object_version_number => p_ovn,
2369: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2370: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),

Line 2410: FROM pay_action_information

2406: l_action_info_id NUMBER(15);
2407: BEGIN
2408: SELECT action_information_id, object_version_number
2409: INTO l_action_info_id, p_ovn
2410: FROM pay_action_information
2411: WHERE action_context_id = p_assignment_action_id AND
2412: action_information_category = p_action_info_category;
2413: RETURN l_action_info_id;
2414: END;

Line 2682: update pay_action_information

2678: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'W');
2679: pay_core_utils.push_token('TEXT', ': Invalid NI number ' || l_nat_number);
2680:
2681: -- Update the NI Number field to NULL
2682: update pay_action_information
2683: set action_information4 = null
2684: where action_information_category = 'EMPLOYEE DETAILS'
2685: and action_context_type = 'AAP'
2686: and action_context_id = p_assactid

Line 2707: from pay_action_information pai_person,

2703: NVL(UPPER(pai_person.action_information6), ' '), -- addr line 2
2704: NVL(UPPER(pai_person.action_information7), ' '), -- addr line 3
2705: NVL(UPPER(pai_person.action_information8), ' '), -- addr line 4
2706: NVL(UPPER(hl.meaning), ' ') -- addr line 5
2707: from pay_action_information pai_person,
2708: hr_lookups hl
2709: where pai_person.action_context_id = p_assignment_action_id
2710: and pai_person.action_information_category = 'ADDRESS DETAILS'
2711: and pai_person.action_information14 = 'Employee Address'

Line 2789: from pay_action_information a,

2785: a1.region_2,
2786: a1.region_3,
2787: a1.postal_code,
2788: a1.country
2789: from pay_action_information a,
2790: per_addresses a1,
2791: per_all_assignments_f per
2792: where per.assignment_id = p_assignment_id
2793: and p_asg_end_date between per.effective_start_date and per.effective_end_date

Line 2838: update pay_action_information

2834: l_fi_name,
2835: l_l_name,
2836: l_m_names;
2837: if row_person_return%FOUND then
2838: update pay_action_information
2839: set action_information1 = l_fu_name
2840: where action_information_category = 'EMPLOYEE DETAILS'
2841: and action_context_type = 'AAP'
2842: and action_context_id = p_assignment_act_id;

Line 2844: update pay_action_information

2840: where action_information_category = 'EMPLOYEE DETAILS'
2841: and action_context_type = 'AAP'
2842: and action_context_id = p_assignment_act_id;
2843:
2844: update pay_action_information
2845: set action_information6 = l_fi_name,
2846: action_information7 = l_m_names,
2847: action_information8 = l_l_name
2848: where action_information_category = 'GB EMPLOYEE DETAILS'

Line 2866: update pay_action_information

2862: l_reg3,
2863: l_poc,
2864: l_country;
2865: if row_address_return%FOUND then
2866: update pay_action_information
2867: set action_information5 = l_addr1,
2868: action_information6 = l_addr2,
2869: action_information7 = l_addr3,
2870: action_information8 = l_toc,

Line 3055: pay_action_information_api.create_action_information(

3051: END; -- end for payroll info setup
3052:
3053: IF l_error <> '1'
3054: THEN
3055: pay_action_information_api.create_action_information(
3056: p_action_information_id => l_action_info_id,
3057: p_action_context_id => p_assactid,
3058: p_action_context_type => 'AAP',
3059: p_object_version_number => l_ovn,

Line 3126: pay_action_information_api.create_action_information(

3122: END IF;
3123:
3124: IF l_error <> '1'
3125: THEN
3126: pay_action_information_api.create_action_information(
3127: p_action_information_id => l_action_info_id,
3128: p_action_context_id => p_assactid,
3129: p_action_context_type => 'AAP',
3130: p_object_version_number => l_ovn,

Line 3633: pay_action_information_api.create_action_information(

3629: END IF;
3630: END LOOP;
3631: END LOOP;
3632: hr_utility.set_location('calling the create api', 20);
3633: pay_action_information_api.create_action_information(
3634: p_action_information_id => l_action_info_id,
3635: p_action_context_id => l_action_context_id,
3636: p_action_context_type => 'AAP',
3637: p_object_version_number => l_ovn,

Line 3799: pay_action_information pai,

3795: CURSOR csr_incorrect_ni_num IS
3796: SELECT pai.action_information7 action_information7, COUNT(1) temp_num
3797: FROM pay_payroll_actions ppa,
3798: pay_assignment_actions paa,
3799: pay_action_information pai,
3800: pay_action_information pai_emp
3801: WHERE ppa.payroll_action_id = pactid
3802: AND paa.payroll_action_id = ppa.payroll_action_id
3803: AND pai.action_context_id = paa.assignment_action_id

Line 3800: pay_action_information pai_emp

3796: SELECT pai.action_information7 action_information7, COUNT(1) temp_num
3797: FROM pay_payroll_actions ppa,
3798: pay_assignment_actions paa,
3799: pay_action_information pai,
3800: pay_action_information pai_emp
3801: WHERE ppa.payroll_action_id = pactid
3802: AND paa.payroll_action_id = ppa.payroll_action_id
3803: AND pai.action_context_id = paa.assignment_action_id
3804: AND pai.action_information_category = 'EMEA PAYROLL INFO'

Line 3818: pay_action_information pai

3814: CURSOR csr_total_num(p_employer_name varchar2) IS
3815: SELECT pai.action_information7 action_information7, COUNT(1) tot_num
3816: FROM pay_payroll_actions ppa,
3817: pay_assignment_actions paa,
3818: pay_action_information pai
3819: WHERE ppa.payroll_action_id = pactid
3820: AND paa.payroll_action_id = ppa.payroll_action_id
3821: AND pai.action_context_id = paa.assignment_action_id
3822: AND pai.action_information_category = 'EMEA PAYROLL INFO'

Line 3832: pay_action_information pai_ben

3828: IS
3829: SELECT COUNT(DISTINCT pai_ben.action_information10)
3830: FROM pay_payroll_actions ppa,
3831: pay_assignment_actions paa,
3832: pay_action_information pai_ben
3833: WHERE ppa.payroll_action_id = pactid
3834: AND ppa.payroll_action_id = paa .payroll_action_id
3835: AND pai_ben.action_context_id = paa.assignment_action_id
3836: AND pai_ben.action_information_category = 'EXPENSES PAYMENTS'

Line 3858: FROM pay_action_information pai_comp,

3854: 'ASSETS AT EMP DISPOSAL', pai.action_information9,
3855: 'OTHER ITEMS', pai.action_information9,
3856: -- 'EXPENSES PAYMENTS', pai.action_information8,
3857: '0') ) p11db_value
3858: FROM pay_action_information pai_comp,
3859: pay_action_information pai,
3860: pay_assignment_actions paa,
3861: pay_payroll_actions ppa
3862: WHERE ppa.payroll_action_id = pactid

Line 3859: pay_action_information pai,

3855: 'OTHER ITEMS', pai.action_information9,
3856: -- 'EXPENSES PAYMENTS', pai.action_information8,
3857: '0') ) p11db_value
3858: FROM pay_action_information pai_comp,
3859: pay_action_information pai,
3860: pay_assignment_actions paa,
3861: pay_payroll_actions ppa
3862: WHERE ppa.payroll_action_id = pactid
3863: AND ppa.payroll_action_id = paa .payroll_action_id

Line 3895: pay_action_information ppa

3891: ppa.action_information10,
3892: ppa.action_information11,
3893: ppa.action_information12
3894: from pay_assignment_actions paa,
3895: pay_action_information ppa
3896: where paa.payroll_action_id = pactid
3897: and paa.assignment_action_id = ppa.action_context_id
3898: and ppa.action_information_category = 'GB EMPLOYEE DETAILS'
3899: and ppa.action_context_type = 'AAP'

Line 3991: pay_action_information pai

3987:
3988: cursor get_employer(p_pact_id number) is
3989: select action_information7
3990: from pay_assignment_actions paa,
3991: pay_action_information pai
3992: where paa.payroll_action_id = p_pact_id
3993: and pai.action_context_id = paa.assignment_action_id
3994: and pai.action_information_category = 'EMEA PAYROLL INFO'
3995: and pai.action_context_type = 'AAP'

Line 4001: use_index(pai_person,pay_action_information_n2)

3997:
3998: cursor get_total(p_pact_id number, p_emp_name varchar2) is
3999: select * from (
4000: select /*+ ORDERED use_nl(paf,paa,pai,pai_a,pai_person)
4001: use_index(pai_person,pay_action_information_n2)
4002: use_index(pai,pay_action_information_n2)
4003: use_index(pai_a,pay_action_information_n2)*/
4004: pai.action_information_category name,
4005: sum(decode(pai.action_information_category,

Line 4002: use_index(pai,pay_action_information_n2)

3998: cursor get_total(p_pact_id number, p_emp_name varchar2) is
3999: select * from (
4000: select /*+ ORDERED use_nl(paf,paa,pai,pai_a,pai_person)
4001: use_index(pai_person,pay_action_information_n2)
4002: use_index(pai,pay_action_information_n2)
4003: use_index(pai_a,pay_action_information_n2)*/
4004: pai.action_information_category name,
4005: sum(decode(pai.action_information_category,
4006: 'ASSETS TRANSFERRED', pai.action_information9,

Line 4003: use_index(pai_a,pay_action_information_n2)*/

3999: select * from (
4000: select /*+ ORDERED use_nl(paf,paa,pai,pai_a,pai_person)
4001: use_index(pai_person,pay_action_information_n2)
4002: use_index(pai,pay_action_information_n2)
4003: use_index(pai_a,pay_action_information_n2)*/
4004: pai.action_information_category name,
4005: sum(decode(pai.action_information_category,
4006: 'ASSETS TRANSFERRED', pai.action_information9,
4007: 'PAYMENTS MADE FOR EMP', pai.action_information7,

Line 4043: pay_action_information pai,

4039: 'OTHER ITEMS NON 1A', 'M',
4040: 'EXPENSES PAYMENTS', 'N') cat,
4041: count(*) no_of_entries
4042: from pay_assignment_actions paa,
4043: pay_action_information pai,
4044: pay_action_information pai_a,
4045: pay_action_information pai_person
4046: where paa.payroll_action_id = p_pact_id
4047: and pai.action_context_id = paa.assignment_action_id

Line 4044: pay_action_information pai_a,

4040: 'EXPENSES PAYMENTS', 'N') cat,
4041: count(*) no_of_entries
4042: from pay_assignment_actions paa,
4043: pay_action_information pai,
4044: pay_action_information pai_a,
4045: pay_action_information pai_person
4046: where paa.payroll_action_id = p_pact_id
4047: and pai.action_context_id = paa.assignment_action_id
4048: and pai.action_context_type = 'AAP'

Line 4045: pay_action_information pai_person

4041: count(*) no_of_entries
4042: from pay_assignment_actions paa,
4043: pay_action_information pai,
4044: pay_action_information pai_a,
4045: pay_action_information pai_person
4046: where paa.payroll_action_id = p_pact_id
4047: and pai.action_context_id = paa.assignment_action_id
4048: and pai.action_context_type = 'AAP'
4049: and pai.action_information_category = pai.action_information_category

Line 4066: pay_action_information pai,

4062: cursor get_int_free_total(p_pact_id number, p_emp_name varchar2) is
4063: select sum(decode(pai.action_information_category,
4064: 'INT FREE AND LOW INT LOANS', pai.action_information11)) total
4065: from pay_assignment_actions paa,
4066: pay_action_information pai,
4067: pay_action_information pai_a,
4068: pay_action_information pai_person
4069: where paa.payroll_action_id = p_pact_id
4070: and pai.action_context_id = paa.assignment_action_id

Line 4067: pay_action_information pai_a,

4063: select sum(decode(pai.action_information_category,
4064: 'INT FREE AND LOW INT LOANS', pai.action_information11)) total
4065: from pay_assignment_actions paa,
4066: pay_action_information pai,
4067: pay_action_information pai_a,
4068: pay_action_information pai_person
4069: where paa.payroll_action_id = p_pact_id
4070: and pai.action_context_id = paa.assignment_action_id
4071: and pai.action_context_type = 'AAP'

Line 4068: pay_action_information pai_person

4064: 'INT FREE AND LOW INT LOANS', pai.action_information11)) total
4065: from pay_assignment_actions paa,
4066: pay_action_information pai,
4067: pay_action_information pai_a,
4068: pay_action_information pai_person
4069: where paa.payroll_action_id = p_pact_id
4070: and pai.action_context_id = paa.assignment_action_id
4071: and pai.action_context_type = 'AAP'
4072: and pai_person.action_context_id = paa.assignment_action_id

Line 4080: from pay_action_information pai_max

4076: and pai_a.action_context_id = paa.assignment_action_id
4077: and pai_a.action_context_type = 'AAP'
4078: and pai_a.action_information_category = 'GB P11D ASSIGNMENT RESULTA'
4079: and not exists (select 1
4080: from pay_action_information pai_max
4081: where pai_max.action_context_id = paa.assignment_action_id
4082: and nvl(pai_max.ACTION_INFORMATION23,0) < 5000
4083: and pai_max.action_context_type = 'AAP'
4084: and pai_max.action_information_category = 'GB P11D ASSIGNMENT RESULTC');

Line 4089: /* Modified query for Bug:12314320 joined with pay_action_information to get the person id which is

4085:
4086: /* Added for the bug 8513401*/
4087:
4088: cursor get_mileage(p_pact_id number, p_emp_name varchar2) is
4089: /* Modified query for Bug:12314320 joined with pay_action_information to get the person id which is
4090: stored in action_information1 and group by person id so that it works for person with
4091: mulitple assignments and also for assignments for muliptle persons*/
4092:
4093: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)

Line 4094: use_index(pai_person,pay_action_information_n2)

4090: stored in action_information1 and group by person id so that it works for person with
4091: mulitple assignments and also for assignments for muliptle persons*/
4092:
4093: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
4094: use_index(pai_person,pay_action_information_n2)
4095: use_index(pai,pay_action_information_n2) */
4096: -- modified for Bug 12314320
4097: sum(nonclassA) from
4098: (select

Line 4095: use_index(pai,pay_action_information_n2) */

4091: mulitple assignments and also for assignments for muliptle persons*/
4092:
4093: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
4094: use_index(pai_person,pay_action_information_n2)
4095: use_index(pai,pay_action_information_n2) */
4096: -- modified for Bug 12314320
4097: sum(nonclassA) from
4098: (select
4099: max(pai.action_information12) as nonclassA --Modified for the bug 11727875

Line 4101: pay_action_information pai,

4097: sum(nonclassA) from
4098: (select
4099: max(pai.action_information12) as nonclassA --Modified for the bug 11727875
4100: from pay_assignment_actions paa,
4101: pay_action_information pai,
4102: pay_action_information pai_person,
4103: pay_action_information pai_add
4104: where paa.payroll_action_id = p_pact_id
4105: and pai.action_context_id = paa.assignment_action_id

Line 4102: pay_action_information pai_person,

4098: (select
4099: max(pai.action_information12) as nonclassA --Modified for the bug 11727875
4100: from pay_assignment_actions paa,
4101: pay_action_information pai,
4102: pay_action_information pai_person,
4103: pay_action_information pai_add
4104: where paa.payroll_action_id = p_pact_id
4105: and pai.action_context_id = paa.assignment_action_id
4106: and pai.action_context_type = 'AAP'

Line 4103: pay_action_information pai_add

4099: max(pai.action_information12) as nonclassA --Modified for the bug 11727875
4100: from pay_assignment_actions paa,
4101: pay_action_information pai,
4102: pay_action_information pai_person,
4103: pay_action_information pai_add
4104: where paa.payroll_action_id = p_pact_id
4105: and pai.action_context_id = paa.assignment_action_id
4106: and pai.action_context_type = 'AAP'
4107: and pai.action_information_category = 'GB P11D ASSIGNMENT RESULTA'

Line 4117: use_index(pai_person,pay_action_information_n2)

4113: and pai_person.action_context_type = 'AAP' group by pai_add.action_information1);
4114:
4115: cursor get_car_fuel(p_pact_id number, p_emp_name varchar2) is
4116: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
4117: use_index(pai_person,pay_action_information_n2)
4118: use_index(pai,pay_action_information_n2) */
4119: sum(pai.action_information11) -- Cash Equivalent For Fuel
4120: from pay_assignment_actions paa,
4121: pay_action_information pai,

Line 4118: use_index(pai,pay_action_information_n2) */

4114:
4115: cursor get_car_fuel(p_pact_id number, p_emp_name varchar2) is
4116: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
4117: use_index(pai_person,pay_action_information_n2)
4118: use_index(pai,pay_action_information_n2) */
4119: sum(pai.action_information11) -- Cash Equivalent For Fuel
4120: from pay_assignment_actions paa,
4121: pay_action_information pai,
4122: pay_action_information pai_person

Line 4121: pay_action_information pai,

4117: use_index(pai_person,pay_action_information_n2)
4118: use_index(pai,pay_action_information_n2) */
4119: sum(pai.action_information11) -- Cash Equivalent For Fuel
4120: from pay_assignment_actions paa,
4121: pay_action_information pai,
4122: pay_action_information pai_person
4123: where paa.payroll_action_id = p_pact_id
4124: and pai.action_context_id = paa.assignment_action_id
4125: and pai.action_context_type = 'AAP'

Line 4122: pay_action_information pai_person

4118: use_index(pai,pay_action_information_n2) */
4119: sum(pai.action_information11) -- Cash Equivalent For Fuel
4120: from pay_assignment_actions paa,
4121: pay_action_information pai,
4122: pay_action_information pai_person
4123: where paa.payroll_action_id = p_pact_id
4124: and pai.action_context_id = paa.assignment_action_id
4125: and pai.action_context_type = 'AAP'
4126: and pai.action_information_category = 'CAR AND CAR FUEL 2003_04'

Line 4134: use_index(pai_person,pay_action_information_n2)

4130: and pai_person.action_context_type = 'AAP';
4131:
4132: cursor get_van_fuel(p_pact_id number, p_emp_name varchar2) is
4133: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
4134: use_index(pai_person,pay_action_information_n2)
4135: use_index(pai,pay_action_information_n2) */
4136: sum(pai.action_information30) -- Cash Equivalent For Fuel
4137: from pay_assignment_actions paa,
4138: pay_action_information pai,

Line 4135: use_index(pai,pay_action_information_n2) */

4131:
4132: cursor get_van_fuel(p_pact_id number, p_emp_name varchar2) is
4133: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
4134: use_index(pai_person,pay_action_information_n2)
4135: use_index(pai,pay_action_information_n2) */
4136: sum(pai.action_information30) -- Cash Equivalent For Fuel
4137: from pay_assignment_actions paa,
4138: pay_action_information pai,
4139: pay_action_information pai_person

Line 4138: pay_action_information pai,

4134: use_index(pai_person,pay_action_information_n2)
4135: use_index(pai,pay_action_information_n2) */
4136: sum(pai.action_information30) -- Cash Equivalent For Fuel
4137: from pay_assignment_actions paa,
4138: pay_action_information pai,
4139: pay_action_information pai_person
4140: where paa.payroll_action_id = p_pact_id
4141: and pai.action_context_id = paa.assignment_action_id
4142: and pai.action_context_type = 'AAP'

Line 4139: pay_action_information pai_person

4135: use_index(pai,pay_action_information_n2) */
4136: sum(pai.action_information30) -- Cash Equivalent For Fuel
4137: from pay_assignment_actions paa,
4138: pay_action_information pai,
4139: pay_action_information pai_person
4140: where paa.payroll_action_id = p_pact_id
4141: and pai.action_context_id = paa.assignment_action_id
4142: and pai.action_context_type = 'AAP'
4143: and pai.action_information_category = 'VANS 2007'

Line 4154: use_index(pai_person,pay_action_information_n2)

4150: p_emp_name varchar2,
4151: p_category varchar2) is
4152: select count(*)
4153: from (select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
4154: use_index(pai_person,pay_action_information_n2)
4155: use_index(pai,pay_action_information_n2) */
4156: pai_person.action_information10 -- Person id
4157: from pay_assignment_actions paa,
4158: pay_action_information pai,

Line 4155: use_index(pai,pay_action_information_n2) */

4151: p_category varchar2) is
4152: select count(*)
4153: from (select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
4154: use_index(pai_person,pay_action_information_n2)
4155: use_index(pai,pay_action_information_n2) */
4156: pai_person.action_information10 -- Person id
4157: from pay_assignment_actions paa,
4158: pay_action_information pai,
4159: pay_action_information pai_person

Line 4158: pay_action_information pai,

4154: use_index(pai_person,pay_action_information_n2)
4155: use_index(pai,pay_action_information_n2) */
4156: pai_person.action_information10 -- Person id
4157: from pay_assignment_actions paa,
4158: pay_action_information pai,
4159: pay_action_information pai_person
4160: where paa.payroll_action_id = p_pact_id
4161: and pai.action_context_id = paa.assignment_action_id
4162: and pai.action_context_type = 'AAP'

Line 4159: pay_action_information pai_person

4155: use_index(pai,pay_action_information_n2) */
4156: pai_person.action_information10 -- Person id
4157: from pay_assignment_actions paa,
4158: pay_action_information pai,
4159: pay_action_information pai_person
4160: where paa.payroll_action_id = p_pact_id
4161: and pai.action_context_id = paa.assignment_action_id
4162: and pai.action_context_type = 'AAP'
4163: and pai.action_information_category = p_category