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

Line 1027: FROM pay_action_information pai_comp,

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

Line 1028: pay_action_information pai_person,

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

Line 1531: pay_action_information_api.create_action_information(

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

Line 1572: pay_action_information_api.create_action_information(

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

Line 1612: pay_action_information_api.create_action_information(

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

Line 1647: pay_action_information_api.create_action_information(

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

Line 1689: pay_action_information_api.create_action_information(

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

Line 1730: pay_action_information_api.create_action_information(

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

Line 1820: FROM pay_action_information

1816: l_col17_val, l_col18_val, l_col19_val, l_col20_val,
1817: l_col21_val, l_col22_val, l_col23_val, l_col24_val,
1818: l_col25_val, l_col26_val, l_col27_val, l_col28_val,
1819: l_col29_val, l_col30_val
1820: FROM pay_action_information
1821: WHERE action_context_id = p_assignment_action_id AND
1822: action_information_category = 'GB P11D ASSIGNMENT RESULTA'
1823: AND action_context_type = 'AAP';
1824:

Line 1872: FROM pay_action_information

1868: l_col17_val, l_col18_val, l_col19_val, l_col20_val,
1869: l_col21_val, l_col22_val, l_col23_val, l_col24_val,
1870: l_col25_val, l_col26_val, l_col27_val, l_col28_val,
1871: l_col29_val, l_col30_val
1872: FROM pay_action_information
1873: WHERE action_context_id = p_assignment_action_id AND
1874: action_information_category ='GB P11D ASSIGNMENT RESULTB'
1875: AND action_context_type = 'AAP';
1876:

Line 1924: FROM pay_action_information

1920: l_col17_val, l_col18_val, l_col19_val, l_col20_val,
1921: l_col21_val, l_col22_val, l_col23_val, l_col24_val,
1922: l_col25_val, l_col26_val, l_col27_val, l_col28_val,
1923: l_col29_val, l_col30_val
1924: FROM pay_action_information
1925: WHERE action_context_id = p_assignment_action_id AND
1926: action_information_category ='GB P11D ASSIGNMENT RESULTC'
1927: AND action_context_type = 'AAP';
1928:

Line 1980: FROM pay_action_information

1976: l_col17_val, l_col18_val, l_col19_val, l_col20_val,
1977: l_col21_val, l_col22_val, l_col23_val, l_col24_val,
1978: l_col25_val, l_col26_val, l_col28_val, l_col29_val,
1979: l_col30_val
1980: FROM pay_action_information
1981: WHERE action_context_id = p_assignment_action_id AND
1982: action_information_category = 'GB P11D ASSIGNMENT RESULTA'
1983: AND action_context_type = 'AAP';
1984:

Line 2032: FROM pay_action_information

2028: l_col17_val, l_col18_val, l_col19_val, l_col20_val,
2029: l_col21_val, l_col22_val, l_col23_val, l_col24_val,
2030: l_col25_val, l_col26_val, l_col27_val, l_col28_val,
2031: l_col29_val, l_col30_val
2032: FROM pay_action_information
2033: WHERE action_context_id = p_assignment_action_id AND
2034: action_information_category ='GB P11D ASSIGNMENT RESULTB'
2035: AND action_context_type = 'AAP';
2036:

Line 2081: FROM pay_action_information

2077: l_col9_val, l_col12_val,
2078: l_col13_val, l_col14_val, l_col15_val, l_col16_val,
2079: l_col17_val, l_col18_val, l_col19_val, l_col20_val,
2080: l_col21_val, l_col22_val, l_col23_val
2081: FROM pay_action_information
2082: WHERE action_context_id = p_assignment_action_id AND
2083: action_information_category ='GB P11D ASSIGNMENT RESULTC'
2084: AND action_context_type = 'AAP';
2085:

Line 2121: pay_action_information_api.update_action_information(

2117: if to_number(g_param_rep_run) < 2005
2118: then
2119: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTA'
2120: THEN
2121: pay_action_information_api.update_action_information(
2122: p_action_information_id => p_action_info_id,
2123: p_object_version_number => p_ovn,
2124: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2125: p_action_information2 => per_formula_functions.get_number('A_COST'),

Line 2158: pay_action_information_api.update_action_information(

2154: END IF;
2155:
2156: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTB'
2157: THEN
2158: pay_action_information_api.update_action_information(
2159: p_action_information_id => p_action_info_id,
2160: p_object_version_number => p_ovn,
2161: p_action_information1 => per_formula_functions.get_text('N_DESC'),
2162: p_action_information2 => per_formula_functions.get_number('N_COST'),

Line 2194: pay_action_information_api.update_action_information(

2190: END IF;
2191:
2192: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTC'
2193: THEN
2194: pay_action_information_api.update_action_information(
2195: p_action_information_id => p_action_info_id,
2196: p_object_version_number => p_ovn,
2197: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2198: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),

Line 2226: pay_action_information_api.update_action_information(

2222: else
2223: /* Code for year 04/05 onwards */
2224: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTA'
2225: THEN
2226: pay_action_information_api.update_action_information(
2227: p_action_information_id => p_action_info_id,
2228: p_object_version_number => p_ovn,
2229: p_action_information1 => per_formula_functions.get_text('A_DESC'),
2230: p_action_information2 => per_formula_functions.get_number('A_COST'),

Line 2263: pay_action_information_api.update_action_information(

2259: END IF;
2260:
2261: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTB'
2262: THEN
2263: pay_action_information_api.update_action_information(
2264: p_action_information_id => p_action_info_id,
2265: p_object_version_number => p_ovn,
2266: p_action_information1 => per_formula_functions.get_text('M_DESC'),
2267: p_action_information2 => per_formula_functions.get_number('M_COST'),

Line 2301: pay_action_information_api.update_action_information(

2297: END IF;
2298:
2299: IF p_action_info_category = 'GB P11D ASSIGNMENT RESULTC'
2300: THEN
2301: pay_action_information_api.update_action_information(
2302: p_action_information_id => p_action_info_id,
2303: p_object_version_number => p_ovn,
2304: p_action_information1 => per_formula_functions.get_number('C_BUS_MILES'),
2305: p_action_information2 => per_formula_functions.get_number('M_BUS_MILES'),

Line 2344: FROM pay_action_information

2340: l_action_info_id NUMBER(15);
2341: BEGIN
2342: SELECT action_information_id, object_version_number
2343: INTO l_action_info_id, p_ovn
2344: FROM pay_action_information
2345: WHERE action_context_id = p_assignment_action_id AND
2346: action_information_category = p_action_info_category;
2347: RETURN l_action_info_id;
2348: END;

Line 2616: update pay_action_information

2612: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'W');
2613: pay_core_utils.push_token('TEXT', ': Invalid NI number ' || l_nat_number);
2614:
2615: -- Update the NI Number field to NULL
2616: update pay_action_information
2617: set action_information4 = null
2618: where action_information_category = 'EMPLOYEE DETAILS'
2619: and action_context_type = 'AAP'
2620: and action_context_id = p_assactid

Line 2641: from pay_action_information pai_person,

2637: NVL(UPPER(pai_person.action_information6), ' '), -- addr line 2
2638: NVL(UPPER(pai_person.action_information7), ' '), -- addr line 3
2639: NVL(UPPER(pai_person.action_information8), ' '), -- addr line 4
2640: NVL(UPPER(hl.meaning), ' ') -- addr line 5
2641: from pay_action_information pai_person,
2642: hr_lookups hl
2643: where pai_person.action_context_id = p_assignment_action_id
2644: and pai_person.action_information_category = 'ADDRESS DETAILS'
2645: and pai_person.action_information14 = 'Employee Address'

Line 2723: from pay_action_information a,

2719: a1.region_2,
2720: a1.region_3,
2721: a1.postal_code,
2722: a1.country
2723: from pay_action_information a,
2724: per_addresses a1,
2725: per_all_assignments_f per
2726: where per.assignment_id = p_assignment_id
2727: and p_asg_end_date between per.effective_start_date and per.effective_end_date

Line 2772: update pay_action_information

2768: l_fi_name,
2769: l_l_name,
2770: l_m_names;
2771: if row_person_return%FOUND then
2772: update pay_action_information
2773: set action_information1 = l_fu_name
2774: where action_information_category = 'EMPLOYEE DETAILS'
2775: and action_context_type = 'AAP'
2776: and action_context_id = p_assignment_act_id;

Line 2778: update pay_action_information

2774: where action_information_category = 'EMPLOYEE DETAILS'
2775: and action_context_type = 'AAP'
2776: and action_context_id = p_assignment_act_id;
2777:
2778: update pay_action_information
2779: set action_information6 = l_fi_name,
2780: action_information7 = l_m_names,
2781: action_information8 = l_l_name
2782: where action_information_category = 'GB EMPLOYEE DETAILS'

Line 2800: update pay_action_information

2796: l_reg3,
2797: l_poc,
2798: l_country;
2799: if row_address_return%FOUND then
2800: update pay_action_information
2801: set action_information5 = l_addr1,
2802: action_information6 = l_addr2,
2803: action_information7 = l_addr3,
2804: action_information8 = l_toc,

Line 2989: pay_action_information_api.create_action_information(

2985: END; -- end for payroll info setup
2986:
2987: IF l_error <> '1'
2988: THEN
2989: pay_action_information_api.create_action_information(
2990: p_action_information_id => l_action_info_id,
2991: p_action_context_id => p_assactid,
2992: p_action_context_type => 'AAP',
2993: p_object_version_number => l_ovn,

Line 3060: pay_action_information_api.create_action_information(

3056: END IF;
3057:
3058: IF l_error <> '1'
3059: THEN
3060: pay_action_information_api.create_action_information(
3061: p_action_information_id => l_action_info_id,
3062: p_action_context_id => p_assactid,
3063: p_action_context_type => 'AAP',
3064: p_object_version_number => l_ovn,

Line 3567: pay_action_information_api.create_action_information(

3563: END IF;
3564: END LOOP;
3565: END LOOP;
3566: hr_utility.set_location('calling the create api', 20);
3567: pay_action_information_api.create_action_information(
3568: p_action_information_id => l_action_info_id,
3569: p_action_context_id => l_action_context_id,
3570: p_action_context_type => 'AAP',
3571: p_object_version_number => l_ovn,

Line 3733: pay_action_information pai,

3729: CURSOR csr_incorrect_ni_num IS
3730: SELECT pai.action_information7 action_information7, COUNT(1) temp_num
3731: FROM pay_payroll_actions ppa,
3732: pay_assignment_actions paa,
3733: pay_action_information pai,
3734: pay_action_information pai_emp
3735: WHERE ppa.payroll_action_id = pactid
3736: AND paa.payroll_action_id = ppa.payroll_action_id
3737: AND pai.action_context_id = paa.assignment_action_id

Line 3734: pay_action_information pai_emp

3730: SELECT pai.action_information7 action_information7, COUNT(1) temp_num
3731: FROM pay_payroll_actions ppa,
3732: pay_assignment_actions paa,
3733: pay_action_information pai,
3734: pay_action_information pai_emp
3735: WHERE ppa.payroll_action_id = pactid
3736: AND paa.payroll_action_id = ppa.payroll_action_id
3737: AND pai.action_context_id = paa.assignment_action_id
3738: AND pai.action_information_category = 'EMEA PAYROLL INFO'

Line 3752: pay_action_information pai

3748: CURSOR csr_total_num(p_employer_name varchar2) IS
3749: SELECT pai.action_information7 action_information7, COUNT(1) tot_num
3750: FROM pay_payroll_actions ppa,
3751: pay_assignment_actions paa,
3752: pay_action_information pai
3753: WHERE ppa.payroll_action_id = pactid
3754: AND paa.payroll_action_id = ppa.payroll_action_id
3755: AND pai.action_context_id = paa.assignment_action_id
3756: AND pai.action_information_category = 'EMEA PAYROLL INFO'

Line 3766: pay_action_information pai_ben

3762: IS
3763: SELECT COUNT(DISTINCT pai_ben.action_information10)
3764: FROM pay_payroll_actions ppa,
3765: pay_assignment_actions paa,
3766: pay_action_information pai_ben
3767: WHERE ppa.payroll_action_id = pactid
3768: AND ppa.payroll_action_id = paa .payroll_action_id
3769: AND pai_ben.action_context_id = paa.assignment_action_id
3770: AND pai_ben.action_information_category = 'EXPENSES PAYMENTS'

Line 3792: FROM pay_action_information pai_comp,

3788: 'ASSETS AT EMP DISPOSAL', pai.action_information9,
3789: 'OTHER ITEMS', pai.action_information9,
3790: -- 'EXPENSES PAYMENTS', pai.action_information8,
3791: '0') ) p11db_value
3792: FROM pay_action_information pai_comp,
3793: pay_action_information pai,
3794: pay_assignment_actions paa,
3795: pay_payroll_actions ppa
3796: WHERE ppa.payroll_action_id = pactid

Line 3793: pay_action_information pai,

3789: 'OTHER ITEMS', pai.action_information9,
3790: -- 'EXPENSES PAYMENTS', pai.action_information8,
3791: '0') ) p11db_value
3792: FROM pay_action_information pai_comp,
3793: pay_action_information pai,
3794: pay_assignment_actions paa,
3795: pay_payroll_actions ppa
3796: WHERE ppa.payroll_action_id = pactid
3797: AND ppa.payroll_action_id = paa .payroll_action_id

Line 3829: pay_action_information ppa

3825: ppa.action_information10,
3826: ppa.action_information11,
3827: ppa.action_information12
3828: from pay_assignment_actions paa,
3829: pay_action_information ppa
3830: where paa.payroll_action_id = pactid
3831: and paa.assignment_action_id = ppa.action_context_id
3832: and ppa.action_information_category = 'GB EMPLOYEE DETAILS'
3833: and ppa.action_context_type = 'AAP'

Line 3925: pay_action_information pai

3921:
3922: cursor get_employer(p_pact_id number) is
3923: select action_information7
3924: from pay_assignment_actions paa,
3925: pay_action_information pai
3926: where paa.payroll_action_id = p_pact_id
3927: and pai.action_context_id = paa.assignment_action_id
3928: and pai.action_information_category = 'EMEA PAYROLL INFO'
3929: and pai.action_context_type = 'AAP'

Line 3935: use_index(pai_person,pay_action_information_n2)

3931:
3932: cursor get_total(p_pact_id number, p_emp_name varchar2) is
3933: select * from (
3934: select /*+ ORDERED use_nl(paf,paa,pai,pai_a,pai_person)
3935: use_index(pai_person,pay_action_information_n2)
3936: use_index(pai,pay_action_information_n2)
3937: use_index(pai_a,pay_action_information_n2)*/
3938: pai.action_information_category name,
3939: sum(decode(pai.action_information_category,

Line 3936: use_index(pai,pay_action_information_n2)

3932: cursor get_total(p_pact_id number, p_emp_name varchar2) is
3933: select * from (
3934: select /*+ ORDERED use_nl(paf,paa,pai,pai_a,pai_person)
3935: use_index(pai_person,pay_action_information_n2)
3936: use_index(pai,pay_action_information_n2)
3937: use_index(pai_a,pay_action_information_n2)*/
3938: pai.action_information_category name,
3939: sum(decode(pai.action_information_category,
3940: 'ASSETS TRANSFERRED', pai.action_information9,

Line 3937: use_index(pai_a,pay_action_information_n2)*/

3933: select * from (
3934: select /*+ ORDERED use_nl(paf,paa,pai,pai_a,pai_person)
3935: use_index(pai_person,pay_action_information_n2)
3936: use_index(pai,pay_action_information_n2)
3937: use_index(pai_a,pay_action_information_n2)*/
3938: pai.action_information_category name,
3939: sum(decode(pai.action_information_category,
3940: 'ASSETS TRANSFERRED', pai.action_information9,
3941: 'PAYMENTS MADE FOR EMP', pai.action_information7,

Line 3977: pay_action_information pai,

3973: 'OTHER ITEMS NON 1A', 'M',
3974: 'EXPENSES PAYMENTS', 'N') cat,
3975: count(*) no_of_entries
3976: from pay_assignment_actions paa,
3977: pay_action_information pai,
3978: pay_action_information pai_a,
3979: pay_action_information pai_person
3980: where paa.payroll_action_id = p_pact_id
3981: and pai.action_context_id = paa.assignment_action_id

Line 3978: pay_action_information pai_a,

3974: 'EXPENSES PAYMENTS', 'N') cat,
3975: count(*) no_of_entries
3976: from pay_assignment_actions paa,
3977: pay_action_information pai,
3978: pay_action_information pai_a,
3979: pay_action_information pai_person
3980: where paa.payroll_action_id = p_pact_id
3981: and pai.action_context_id = paa.assignment_action_id
3982: and pai.action_context_type = 'AAP'

Line 3979: pay_action_information pai_person

3975: count(*) no_of_entries
3976: from pay_assignment_actions paa,
3977: pay_action_information pai,
3978: pay_action_information pai_a,
3979: pay_action_information pai_person
3980: where paa.payroll_action_id = p_pact_id
3981: and pai.action_context_id = paa.assignment_action_id
3982: and pai.action_context_type = 'AAP'
3983: and pai.action_information_category = pai.action_information_category

Line 3997: use_index(pai_person,pay_action_information_n2)

3993: order by cat;
3994:
3995: cursor get_mileage(p_pact_id number, p_emp_name varchar2) is
3996: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
3997: use_index(pai_person,pay_action_information_n2)
3998: use_index(pai,pay_action_information_n2) */
3999: sum(pai.action_information12)
4000: from pay_assignment_actions paa,
4001: pay_action_information pai,

Line 3998: use_index(pai,pay_action_information_n2) */

3994:
3995: cursor get_mileage(p_pact_id number, p_emp_name varchar2) is
3996: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
3997: use_index(pai_person,pay_action_information_n2)
3998: use_index(pai,pay_action_information_n2) */
3999: sum(pai.action_information12)
4000: from pay_assignment_actions paa,
4001: pay_action_information pai,
4002: pay_action_information pai_person

Line 4001: pay_action_information pai,

3997: use_index(pai_person,pay_action_information_n2)
3998: use_index(pai,pay_action_information_n2) */
3999: sum(pai.action_information12)
4000: from pay_assignment_actions paa,
4001: pay_action_information pai,
4002: pay_action_information pai_person
4003: where paa.payroll_action_id = p_pact_id
4004: and pai.action_context_id = paa.assignment_action_id
4005: and pai.action_context_type = 'AAP'

Line 4002: pay_action_information pai_person

3998: use_index(pai,pay_action_information_n2) */
3999: sum(pai.action_information12)
4000: from pay_assignment_actions paa,
4001: pay_action_information pai,
4002: pay_action_information pai_person
4003: where paa.payroll_action_id = p_pact_id
4004: and pai.action_context_id = paa.assignment_action_id
4005: and pai.action_context_type = 'AAP'
4006: and pai.action_information_category = 'GB P11D ASSIGNMENT RESULTA'

Line 4014: use_index(pai_person,pay_action_information_n2)

4010: and pai_person.action_context_type = 'AAP';
4011:
4012: cursor get_car_fuel(p_pact_id number, p_emp_name varchar2) is
4013: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
4014: use_index(pai_person,pay_action_information_n2)
4015: use_index(pai,pay_action_information_n2) */
4016: sum(pai.action_information11) -- Cash Equivalent For Fuel
4017: from pay_assignment_actions paa,
4018: pay_action_information pai,

Line 4015: use_index(pai,pay_action_information_n2) */

4011:
4012: cursor get_car_fuel(p_pact_id number, p_emp_name varchar2) is
4013: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
4014: use_index(pai_person,pay_action_information_n2)
4015: use_index(pai,pay_action_information_n2) */
4016: sum(pai.action_information11) -- Cash Equivalent For Fuel
4017: from pay_assignment_actions paa,
4018: pay_action_information pai,
4019: pay_action_information pai_person

Line 4018: pay_action_information pai,

4014: use_index(pai_person,pay_action_information_n2)
4015: use_index(pai,pay_action_information_n2) */
4016: sum(pai.action_information11) -- Cash Equivalent For Fuel
4017: from pay_assignment_actions paa,
4018: pay_action_information pai,
4019: pay_action_information pai_person
4020: where paa.payroll_action_id = p_pact_id
4021: and pai.action_context_id = paa.assignment_action_id
4022: and pai.action_context_type = 'AAP'

Line 4019: pay_action_information pai_person

4015: use_index(pai,pay_action_information_n2) */
4016: sum(pai.action_information11) -- Cash Equivalent For Fuel
4017: from pay_assignment_actions paa,
4018: pay_action_information pai,
4019: pay_action_information pai_person
4020: where paa.payroll_action_id = p_pact_id
4021: and pai.action_context_id = paa.assignment_action_id
4022: and pai.action_context_type = 'AAP'
4023: and pai.action_information_category = 'CAR AND CAR FUEL 2003_04'

Line 4031: use_index(pai_person,pay_action_information_n2)

4027: and pai_person.action_context_type = 'AAP';
4028:
4029: cursor get_van_fuel(p_pact_id number, p_emp_name varchar2) is
4030: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
4031: use_index(pai_person,pay_action_information_n2)
4032: use_index(pai,pay_action_information_n2) */
4033: sum(pai.action_information30) -- Cash Equivalent For Fuel
4034: from pay_assignment_actions paa,
4035: pay_action_information pai,

Line 4032: use_index(pai,pay_action_information_n2) */

4028:
4029: cursor get_van_fuel(p_pact_id number, p_emp_name varchar2) is
4030: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
4031: use_index(pai_person,pay_action_information_n2)
4032: use_index(pai,pay_action_information_n2) */
4033: sum(pai.action_information30) -- Cash Equivalent For Fuel
4034: from pay_assignment_actions paa,
4035: pay_action_information pai,
4036: pay_action_information pai_person

Line 4035: pay_action_information pai,

4031: use_index(pai_person,pay_action_information_n2)
4032: use_index(pai,pay_action_information_n2) */
4033: sum(pai.action_information30) -- Cash Equivalent For Fuel
4034: from pay_assignment_actions paa,
4035: pay_action_information pai,
4036: pay_action_information pai_person
4037: where paa.payroll_action_id = p_pact_id
4038: and pai.action_context_id = paa.assignment_action_id
4039: and pai.action_context_type = 'AAP'

Line 4036: pay_action_information pai_person

4032: use_index(pai,pay_action_information_n2) */
4033: sum(pai.action_information30) -- Cash Equivalent For Fuel
4034: from pay_assignment_actions paa,
4035: pay_action_information pai,
4036: pay_action_information pai_person
4037: where paa.payroll_action_id = p_pact_id
4038: and pai.action_context_id = paa.assignment_action_id
4039: and pai.action_context_type = 'AAP'
4040: and pai.action_information_category = 'VANS 2007'

Line 4051: use_index(pai_person,pay_action_information_n2)

4047: p_emp_name varchar2,
4048: p_category varchar2) is
4049: select count(*)
4050: from (select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
4051: use_index(pai_person,pay_action_information_n2)
4052: use_index(pai,pay_action_information_n2) */
4053: pai_person.action_information10 -- Person id
4054: from pay_assignment_actions paa,
4055: pay_action_information pai,

Line 4052: use_index(pai,pay_action_information_n2) */

4048: p_category varchar2) is
4049: select count(*)
4050: from (select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
4051: use_index(pai_person,pay_action_information_n2)
4052: use_index(pai,pay_action_information_n2) */
4053: pai_person.action_information10 -- Person id
4054: from pay_assignment_actions paa,
4055: pay_action_information pai,
4056: pay_action_information pai_person

Line 4055: pay_action_information pai,

4051: use_index(pai_person,pay_action_information_n2)
4052: use_index(pai,pay_action_information_n2) */
4053: pai_person.action_information10 -- Person id
4054: from pay_assignment_actions paa,
4055: pay_action_information pai,
4056: pay_action_information pai_person
4057: where paa.payroll_action_id = p_pact_id
4058: and pai.action_context_id = paa.assignment_action_id
4059: and pai.action_context_type = 'AAP'

Line 4056: pay_action_information pai_person

4052: use_index(pai,pay_action_information_n2) */
4053: pai_person.action_information10 -- Person id
4054: from pay_assignment_actions paa,
4055: pay_action_information pai,
4056: pay_action_information pai_person
4057: where paa.payroll_action_id = p_pact_id
4058: and pai.action_context_id = paa.assignment_action_id
4059: and pai.action_context_type = 'AAP'
4060: and pai.action_information_category = p_category