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.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on PAY_ACTION_INFORMATION

Line 322: from pay_action_information pai_comp,

318: l_loan_amount NUMBER;
319: begin
320: select sum(nvl(pai.action_information7, 0) )
321: into l_loan_amount
322: from pay_action_information pai_comp,
323: pay_action_information pai_person,
324: pay_action_information pai,
325: pay_assignment_actions paa,
326: pay_payroll_actions ppa

Line 323: pay_action_information pai_person,

319: begin
320: select sum(nvl(pai.action_information7, 0) )
321: into l_loan_amount
322: from pay_action_information pai_comp,
323: pay_action_information pai_person,
324: pay_action_information pai,
325: pay_assignment_actions paa,
326: pay_payroll_actions ppa
327: where ppa.payroll_action_id = p_archive_payroll_action_id

Line 324: pay_action_information pai,

320: select sum(nvl(pai.action_information7, 0) )
321: into l_loan_amount
322: from pay_action_information pai_comp,
323: pay_action_information pai_person,
324: pay_action_information pai,
325: pay_assignment_actions paa,
326: pay_payroll_actions ppa
327: where ppa.payroll_action_id = p_archive_payroll_action_id
328: and ppa.payroll_action_id = paa.payroll_action_id

Line 615: pay_action_information pai_comp,

611: cursor asg_low is
612: select min(paa2.assignment_id)
613: from pay_assignment_actions paa,
614: pay_assignment_actions paa2,
615: pay_action_information pai_comp,
616: pay_action_information pai_person
617: where paa.assignment_action_id = p_action_id
618: and paa2.payroll_action_id = paa.payroll_action_id
619: and pai_comp.action_context_id = paa2.assignment_action_id

Line 616: pay_action_information pai_person

612: select min(paa2.assignment_id)
613: from pay_assignment_actions paa,
614: pay_assignment_actions paa2,
615: pay_action_information pai_comp,
616: pay_action_information pai_person
617: where paa.assignment_action_id = p_action_id
618: and paa2.payroll_action_id = paa.payroll_action_id
619: and pai_comp.action_context_id = paa2.assignment_action_id
620: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'

Line 679: from pay_action_information pai_person

675: begin
676: -- populating the person id
677: select action_information1
678: into g_person_id
679: from pay_action_information pai_person
680: where pai_person.action_context_id = p_assignment_action_id
681: and pai_person.action_information_category = 'ADDRESS DETAILS'
682: and pai_person.action_context_type = 'AAP'
683: and pai_person.action_information14 = 'Employee Address';

Line 689: from pay_action_information pai_comp

685: select action_information6,
686: action_information7
687: into g_emp_ref_no,
688: g_employer_name
689: from pay_action_information pai_comp
690: where pai_comp.action_context_id = p_assignment_action_id
691: and pai_comp.action_context_type = 'AAP'
692: and pai_comp.action_information_category = 'EMEA PAYROLL INFO';
693:

Line 710: from pay_action_information pai_gb

706: l_p11d_fields.sur_name,
707: l_p11d_fields.fore_name,
708: l_p11d_fields.date_of_birth,
709: l_p11d_fields.gender
710: from pay_action_information pai_gb
711: where pai_gb.action_context_id = p_assignment_action_id
712: and pai_gb.action_context_type = 'AAP'
713: and pai_gb.action_information_category = 'GB EMPLOYEE DETAILS';
714: --

Line 722: from pay_action_information pai_emp

718: -- action_information14 -- assign num
719: into l_p11d_fields.full_name,
720: l_p11d_fields.national_ins_no,
721: l_p11d_fields.employee_number
722: from pay_action_information pai_emp
723: where pai_emp.action_context_id = p_assignment_action_id
724: and pai_emp.action_context_type = 'AAP'
725: and pai_emp.action_information_category = 'EMPLOYEE DETAILS';
726:

Line 780: from pay_action_information pai_emp

776: l_p11d_fields.j_ce, l_p11d_fields.k_cost, l_p11d_fields.k_amg,
777: l_p11d_fields.k_ce, l_p11d_fields.l_desc, l_p11d_fields.l_cost,
778: l_p11d_fields.l_amg, l_p11d_fields.l_ce, l_p11d_fields.m_shares,
779: l_h_ce, l_h_count, l_f_count
780: from pay_action_information pai_emp
781: where pai_emp.action_context_id = p_assignment_action_id
782: and pai_emp.action_context_type = 'AAP'
783: and pai_emp.action_information_category = 'GB P11D ASSIGNMENT RESULTA';
784:

Line 826: from pay_action_information pai_emp

822: l_p11d_fields.o4_cost, l_p11d_fields.o4_amg, l_p11d_fields.o4_ce,
823: l_p11d_fields.o5_cost, l_p11d_fields.o5_amg, l_p11d_fields.o5_ce,
824: l_p11d_fields.o6_desc, l_p11d_fields.o6_cost,
825: l_p11d_fields.o6_amg, l_p11d_fields.o6_ce
826: from pay_action_information pai_emp
827: where pai_emp.action_context_id = p_assignment_action_id
828: and pai_emp.action_context_type = 'AAP'
829: and pai_emp.action_information_category = 'GB P11D ASSIGNMENT RESULTB';
830:

Line 838: from pay_action_information pai_emp

834: substr(action_information10,1,4) ,
835: decode (action_information11,null,'N','Y'),to_number(nvl(ACTION_INFORMATION23,'0'))
836: into l_p11d_fields.f_date_free,l_p11d_fields.f_rein_yr,
837: l_h_sum_max_amt_outstanding
838: from pay_action_information pai_emp
839: where pai_emp.action_context_id = p_assignment_action_id
840: and pai_emp.action_context_type = 'AAP'
841: and pai_emp.action_information_category = 'GB P11D ASSIGNMENT RESULTC';
842:

Line 883: from pay_action_information pai_emp

879: l_p11d_fields.j_ce, l_p11d_fields.k_cost, l_p11d_fields.k_amg,
880: l_p11d_fields.k_ce, l_p11d_fields.l_desc, l_p11d_fields.l_cost,
881: l_p11d_fields.l_amg, l_p11d_fields.l_ce,
882: l_h_ce, l_h_count, l_f_count
883: from pay_action_information pai_emp
884: where pai_emp.action_context_id = p_assignment_action_id
885: and pai_emp.action_context_type = 'AAP'
886: and pai_emp.action_information_category = 'GB P11D ASSIGNMENT RESULTA';
887:

Line 930: from pay_action_information pai_emp

926: l_p11d_fields.o4_cost, l_p11d_fields.o4_amg, l_p11d_fields.o4_ce,
927: l_p11d_fields.o5_cost, l_p11d_fields.o5_amg, l_p11d_fields.o5_ce,
928: l_p11d_fields.o6_desc, l_p11d_fields.o6_cost,
929: l_p11d_fields.o6_amg, l_p11d_fields.o6_ce, l_p11d_fields.g_cef
930: from pay_action_information pai_emp
931: where pai_emp.action_context_id = p_assignment_action_id
932: and pai_emp.action_context_type = 'AAP'
933: and pai_emp.action_information_category = 'GB P11D ASSIGNMENT RESULTB';
934:

Line 938: from pay_action_information pai_emp

934:
935: hr_utility.trace('Fetching from Result C');
936: select to_number(nvl(ACTION_INFORMATION23,'0'))
937: into l_h_sum_max_amt_outstanding
938: from pay_action_information pai_emp
939: where pai_emp.action_context_id = p_assignment_action_id
940: and pai_emp.action_context_type = 'AAP'
941: and pai_emp.action_information_category = 'GB P11D ASSIGNMENT RESULTC';
942: end if;

Line 980: from pay_action_information pai_emp

976: substr(action_information26,6,2) || ' ' ||
977: substr(action_information26,1,4) f_date_free,
978: decode(action_information27,'Y','Y','N') f_rein_yr,
979: pai_emp.action_information18 f_esize
980: from pay_action_information pai_emp
981: where pai_emp.action_information_category = 'CAR AND CAR FUEL 2003_04'
982: and pai_emp.action_context_type = 'AAP'
983: and pai_emp.action_context_id in( select paa.assignment_action_id
984: from pay_action_information pai_comp,

Line 984: from pay_action_information pai_comp,

980: from pay_action_information pai_emp
981: where pai_emp.action_information_category = 'CAR AND CAR FUEL 2003_04'
982: and pai_emp.action_context_type = 'AAP'
983: and pai_emp.action_context_id in( select paa.assignment_action_id
984: from pay_action_information pai_comp,
985: pay_action_information pai_person,
986: pay_assignment_actions paa,
987: pay_payroll_actions ppa
988: where ppa.payroll_action_id = p_pactid

Line 985: pay_action_information pai_person,

981: where pai_emp.action_information_category = 'CAR AND CAR FUEL 2003_04'
982: and pai_emp.action_context_type = 'AAP'
983: and pai_emp.action_context_id in( select paa.assignment_action_id
984: from pay_action_information pai_comp,
985: pay_action_information pai_person,
986: pay_assignment_actions paa,
987: pay_payroll_actions ppa
988: where ppa.payroll_action_id = p_pactid
989: and paa.payroll_action_id = ppa.payroll_action_id

Line 1147: from pay_action_information pai_emp

1143: substr(pai_emp.action_information10,6,2) ||decode(pai_emp.action_information10,null,null,' ') ||
1144: substr(pai_emp.action_information10,1,4) h_dld,
1145: to_char(to_number(nvl(pai_emp.action_information11,'0')),'FM999,999,990.00') h_ce,
1146: to_char(to_number(nvl(pai_emp.action_information16,'0')),'FM999,999,990.00') h_aye
1147: from pay_action_information pai_emp
1148: where pai_emp.action_information_category = 'INT FREE AND LOW INT LOANS'
1149: and pai_emp.action_context_type = 'AAP'
1150: and pai_emp.action_context_id in ( select paa.assignment_action_id
1151: from pay_action_information pai_comp,

Line 1151: from pay_action_information pai_comp,

1147: from pay_action_information pai_emp
1148: where pai_emp.action_information_category = 'INT FREE AND LOW INT LOANS'
1149: and pai_emp.action_context_type = 'AAP'
1150: and pai_emp.action_context_id in ( select paa.assignment_action_id
1151: from pay_action_information pai_comp,
1152: pay_action_information pai_person,
1153: pay_assignment_actions paa,
1154: pay_payroll_actions ppa
1155: where ppa.payroll_action_id = p_pactid

Line 1152: pay_action_information pai_person,

1148: where pai_emp.action_information_category = 'INT FREE AND LOW INT LOANS'
1149: and pai_emp.action_context_type = 'AAP'
1150: and pai_emp.action_context_id in ( select paa.assignment_action_id
1151: from pay_action_information pai_comp,
1152: pay_action_information pai_person,
1153: pay_assignment_actions paa,
1154: pay_payroll_actions ppa
1155: where ppa.payroll_action_id = p_pactid
1156: and paa.payroll_action_id = ppa.payroll_action_id

Line 1955: use_index(pai_person,pay_action_information_n2)

1951: is
1952:
1953: cursor get_loan_amount (c_asg_act_id in number, c_emp_ref in varchar2) is
1954: select /*+ ORDERED use_nl(paa,pai,pai_person)
1955: use_index(pai_person,pay_action_information_n2)
1956: use_index(pai,pay_action_information_n2) */
1957: sum(to_number(nvl(pai.action_information7,0)))
1958: from pay_assignment_actions paa,
1959: pay_action_information pai,

Line 1956: use_index(pai,pay_action_information_n2) */

1952:
1953: cursor get_loan_amount (c_asg_act_id in number, c_emp_ref in varchar2) is
1954: select /*+ ORDERED use_nl(paa,pai,pai_person)
1955: use_index(pai_person,pay_action_information_n2)
1956: use_index(pai,pay_action_information_n2) */
1957: sum(to_number(nvl(pai.action_information7,0)))
1958: from pay_assignment_actions paa,
1959: pay_action_information pai,
1960: pay_action_information pai_person

Line 1959: pay_action_information pai,

1955: use_index(pai_person,pay_action_information_n2)
1956: use_index(pai,pay_action_information_n2) */
1957: sum(to_number(nvl(pai.action_information7,0)))
1958: from pay_assignment_actions paa,
1959: pay_action_information pai,
1960: pay_action_information pai_person
1961: where pai.action_context_id = paa.assignment_action_id
1962: and pai.action_context_type = 'AAP'
1963: and pai.action_information_category = 'INT FREE AND LOW INT LOANS'

Line 1960: pay_action_information pai_person

1956: use_index(pai,pay_action_information_n2) */
1957: sum(to_number(nvl(pai.action_information7,0)))
1958: from pay_assignment_actions paa,
1959: pay_action_information pai,
1960: pay_action_information pai_person
1961: where pai.action_context_id = paa.assignment_action_id
1962: and pai.action_context_type = 'AAP'
1963: and pai.action_information_category = 'INT FREE AND LOW INT LOANS'
1964: and pai_person.action_context_id = paa.assignment_action_id

Line 1972: use_index(pai_person,pay_action_information_n2)

1968: and pai_person.action_context_type = 'AAP';
1969:
1970: cursor get_ben_value (c_asg_act_id in number, c_emp_ref in varchar2) is
1971: select /*+ ORDERED use_nl(paa,pai,pai_a,pai_person)
1972: use_index(pai_person,pay_action_information_n2)
1973: use_index(pai,pay_action_information_n2)
1974: use_index(pai_a,pay_action_information_n2)*/
1975: pai_a.action_information12
1976: from pay_assignment_actions paa,

Line 1973: use_index(pai,pay_action_information_n2)

1969:
1970: cursor get_ben_value (c_asg_act_id in number, c_emp_ref in varchar2) is
1971: select /*+ ORDERED use_nl(paa,pai,pai_a,pai_person)
1972: use_index(pai_person,pay_action_information_n2)
1973: use_index(pai,pay_action_information_n2)
1974: use_index(pai_a,pay_action_information_n2)*/
1975: pai_a.action_information12
1976: from pay_assignment_actions paa,
1977: pay_action_information pai,

Line 1974: use_index(pai_a,pay_action_information_n2)*/

1970: cursor get_ben_value (c_asg_act_id in number, c_emp_ref in varchar2) is
1971: select /*+ ORDERED use_nl(paa,pai,pai_a,pai_person)
1972: use_index(pai_person,pay_action_information_n2)
1973: use_index(pai,pay_action_information_n2)
1974: use_index(pai_a,pay_action_information_n2)*/
1975: pai_a.action_information12
1976: from pay_assignment_actions paa,
1977: pay_action_information pai,
1978: pay_action_information pai_a,

Line 1977: pay_action_information pai,

1973: use_index(pai,pay_action_information_n2)
1974: use_index(pai_a,pay_action_information_n2)*/
1975: pai_a.action_information12
1976: from pay_assignment_actions paa,
1977: pay_action_information pai,
1978: pay_action_information pai_a,
1979: pay_action_information pai_person
1980: where paa.assignment_action_id = c_asg_act_id
1981: and pai.action_context_id = paa.assignment_action_id

Line 1978: pay_action_information pai_a,

1974: use_index(pai_a,pay_action_information_n2)*/
1975: pai_a.action_information12
1976: from pay_assignment_actions paa,
1977: pay_action_information pai,
1978: pay_action_information pai_a,
1979: pay_action_information pai_person
1980: where paa.assignment_action_id = c_asg_act_id
1981: and pai.action_context_id = paa.assignment_action_id
1982: and pai.action_context_type = 'AAP'

Line 1979: pay_action_information pai_person

1975: pai_a.action_information12
1976: from pay_assignment_actions paa,
1977: pay_action_information pai,
1978: pay_action_information pai_a,
1979: pay_action_information pai_person
1980: where paa.assignment_action_id = c_asg_act_id
1981: and pai.action_context_id = paa.assignment_action_id
1982: and pai.action_context_type = 'AAP'
1983: and pai.action_information_category = pai.action_information_category

Line 2001: from pay_action_information pai_comp

1997: and to_date('05-04-' || c_rep_run,'DD-MM-YYYY') between effective_start_date and effective_end_date;
1998:
1999: cursor get_emp_ref is
2000: select action_information6
2001: from pay_action_information pai_comp
2002: where pai_comp.action_context_id = p_assignment_action_id
2003: and pai_comp.action_information_category = 'EMEA PAYROLL INFO';
2004:
2005: cursor get_pactid is

Line 2012: from pay_action_information pai

2008: where assignment_action_id = p_assignment_action_id;
2009:
2010: cursor get_other_ben_exists (c_asg_act_id in number) is
2011: select 1
2012: from pay_action_information pai
2013: where pai.action_context_id = c_asg_act_id
2014: and pai.action_context_type = 'AAP'
2015: and pai.action_information_category in ('ASSETS TRANSFERRED',
2016: 'PAYMENTS MADE FOR EMP',

Line 2040: from pay_action_information pai,

2036: cursor get_other_asg_action_exists (c_asg_act_id number,
2037: c_pact_id number,
2038: c_person_id number)is
2039: select paa.assignment_action_id
2040: from pay_action_information pai,
2041: pay_assignment_actions paa,
2042: per_all_assignments_f paaf
2043: where paa.payroll_action_id = c_pact_id
2044: and pai.action_context_id = paa.assignment_action_id

Line 2519: from pay_action_information pai_person

2515: is
2516: cursor csr_person_id
2517: is
2518: select action_information1
2519: from pay_action_information pai_person
2520: where pai_person.action_context_id = p_assignment_action_id
2521: and pai_person.action_information_category = 'ADDRESS DETAILS'
2522: and pai_person.action_information14 = 'Employee Address';
2523: l_person_id number;

Line 2539: from pay_action_information pai_comp

2535: cursor csr_employer_details
2536: is
2537: select action_information6,
2538: action_information7
2539: from pay_action_information pai_comp
2540: where pai_comp.action_context_id = p_assignment_action_id
2541: and pai_comp.action_information_category = 'EMEA PAYROLL INFO';
2542: begin
2543: open csr_employer_details;

Line 2559: from pay_action_information pai_gb

2555: cursor cur_sur_fore_name(c_assignment_action_id NUMBER) is
2556:
2557: select action_information6,
2558: action_information8
2559: from pay_action_information pai_gb
2560: where pai_gb.action_context_id = c_assignment_action_id
2561: and pai_gb.action_context_type = 'AAP'
2562: and pai_gb.action_information_category = 'GB EMPLOYEE DETAILS';
2563:

Line 2581: from pay_action_information pai_emp

2577: is
2578: select action_information1,
2579: action_information4,
2580: action_information10
2581: from pay_action_information pai_emp
2582: where pai_emp.action_context_id = p_assignment_action_id
2583: and pai_emp.action_information_category = 'EMPLOYEE DETAILS';
2584: begin
2585: open csr_employee_details;

Line 2614: use_index(pai_comp,pay_action_information_n2)

2610: p_emp_ref VARCHAR2,
2611: p_emp_name VARCHAR2)
2612: is
2613: select /*+ ORDERED use_nl(ppa, paa, pai_comp, pai_person, pai_car)
2614: use_index(pai_comp,pay_action_information_n2)
2615: use_index(pai_person,pay_action_information_n2)
2616: use_index(pai_car,pay_action_information_n2) */
2617: pai_car.action_context_id
2618: from pay_payroll_actions ppa,

Line 2615: use_index(pai_person,pay_action_information_n2)

2611: p_emp_name VARCHAR2)
2612: is
2613: select /*+ ORDERED use_nl(ppa, paa, pai_comp, pai_person, pai_car)
2614: use_index(pai_comp,pay_action_information_n2)
2615: use_index(pai_person,pay_action_information_n2)
2616: use_index(pai_car,pay_action_information_n2) */
2617: pai_car.action_context_id
2618: from pay_payroll_actions ppa,
2619: pay_assignment_actions paa,

Line 2616: use_index(pai_car,pay_action_information_n2) */

2612: is
2613: select /*+ ORDERED use_nl(ppa, paa, pai_comp, pai_person, pai_car)
2614: use_index(pai_comp,pay_action_information_n2)
2615: use_index(pai_person,pay_action_information_n2)
2616: use_index(pai_car,pay_action_information_n2) */
2617: pai_car.action_context_id
2618: from pay_payroll_actions ppa,
2619: pay_assignment_actions paa,
2620: pay_action_information pai_comp,

Line 2620: pay_action_information pai_comp,

2616: use_index(pai_car,pay_action_information_n2) */
2617: pai_car.action_context_id
2618: from pay_payroll_actions ppa,
2619: pay_assignment_actions paa,
2620: pay_action_information pai_comp,
2621: pay_action_information pai_person,
2622: pay_action_information pai_car
2623: where ppa.payroll_action_id = p_pactid
2624: and paa.payroll_action_id = ppa.payroll_action_id

Line 2621: pay_action_information pai_person,

2617: pai_car.action_context_id
2618: from pay_payroll_actions ppa,
2619: pay_assignment_actions paa,
2620: pay_action_information pai_comp,
2621: pay_action_information pai_person,
2622: pay_action_information pai_car
2623: where ppa.payroll_action_id = p_pactid
2624: and paa.payroll_action_id = ppa.payroll_action_id
2625: and pai_comp.action_context_id = paa.assignment_action_id

Line 2622: pay_action_information pai_car

2618: from pay_payroll_actions ppa,
2619: pay_assignment_actions paa,
2620: pay_action_information pai_comp,
2621: pay_action_information pai_person,
2622: pay_action_information pai_car
2623: where ppa.payroll_action_id = p_pactid
2624: and paa.payroll_action_id = ppa.payroll_action_id
2625: and pai_comp.action_context_id = paa.assignment_action_id
2626: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'

Line 2680: from pay_action_information pai_ben

2676: 1,decode(months_between(
2677: fnd_date.canonical_to_date(pai_ben.action_information4)+1,
2678: fnd_date.canonical_to_date(pai_ben.action_information3)),12,null,
2679: to_char(to_number(nvl(pai_ben.action_information15,0)))),null) NUMBER_OF_DAYS
2680: from pay_action_information pai_ben
2681: where pai_ben.action_information_category = 'LIVING ACCOMMODATION'
2682: and pai_ben.action_context_id = p_context_id
2683: and pai_ben.action_context_type = 'AAP';
2684:

Line 2889: use_index(pai_person,pay_action_information_n2)

2885: --
2886: l_select := 'select asg_id
2887: from (select asg_id, rownum as row_num
2888: from (select /*+ ORDERED use_nl(paa,paf,emp,pai_payroll)
2889: use_index(pai_person,pay_action_information_n2)
2890: use_index(pai,pay_action_information_n2) */
2891: paf.person_id, max(paa.assignment_action_id) as asg_id ';
2892: l_from := 'from pay_assignment_actions paa,
2893: per_all_assignments_f paf,

Line 2890: use_index(pai,pay_action_information_n2) */

2886: l_select := 'select asg_id
2887: from (select asg_id, rownum as row_num
2888: from (select /*+ ORDERED use_nl(paa,paf,emp,pai_payroll)
2889: use_index(pai_person,pay_action_information_n2)
2890: use_index(pai,pay_action_information_n2) */
2891: paf.person_id, max(paa.assignment_action_id) as asg_id ';
2892: l_from := 'from pay_assignment_actions paa,
2893: per_all_assignments_f paf,
2894: pay_action_information emp,

Line 2894: pay_action_information emp,

2890: use_index(pai,pay_action_information_n2) */
2891: paf.person_id, max(paa.assignment_action_id) as asg_id ';
2892: l_from := 'from pay_assignment_actions paa,
2893: per_all_assignments_f paf,
2894: pay_action_information emp,
2895: pay_action_information pai_payroll ';
2896: l_where := 'where paa.payroll_action_id = ' || l_payroll_action_id || '
2897: and paa.action_status = ''C''
2898: and paa.assignment_id = paf.assignment_id

Line 2895: pay_action_information pai_payroll ';

2891: paf.person_id, max(paa.assignment_action_id) as asg_id ';
2892: l_from := 'from pay_assignment_actions paa,
2893: per_all_assignments_f paf,
2894: pay_action_information emp,
2895: pay_action_information pai_payroll ';
2896: l_where := 'where paa.payroll_action_id = ' || l_payroll_action_id || '
2897: and paa.action_status = ''C''
2898: and paa.assignment_id = paf.assignment_id
2899: and emp.action_information_category = ''EMPLOYEE DETAILS''

Line 3047: use_index(pai_comp,pay_action_information_n2)

3043: p_emp_name VARCHAR2,
3044: p_category VARCHAR2)
3045: is
3046: select /*+ ORDERED use_nl(ppa, paa, pai_comp, pai_person, pai_car)
3047: use_index(pai_comp,pay_action_information_n2)
3048: use_index(pai_person,pay_action_information_n2)
3049: use_index(pai_car,pay_action_information_n2) */
3050: pai_car.action_context_id
3051: from pay_payroll_actions ppa,

Line 3048: use_index(pai_person,pay_action_information_n2)

3044: p_category VARCHAR2)
3045: is
3046: select /*+ ORDERED use_nl(ppa, paa, pai_comp, pai_person, pai_car)
3047: use_index(pai_comp,pay_action_information_n2)
3048: use_index(pai_person,pay_action_information_n2)
3049: use_index(pai_car,pay_action_information_n2) */
3050: pai_car.action_context_id
3051: from pay_payroll_actions ppa,
3052: pay_assignment_actions paa,

Line 3049: use_index(pai_car,pay_action_information_n2) */

3045: is
3046: select /*+ ORDERED use_nl(ppa, paa, pai_comp, pai_person, pai_car)
3047: use_index(pai_comp,pay_action_information_n2)
3048: use_index(pai_person,pay_action_information_n2)
3049: use_index(pai_car,pay_action_information_n2) */
3050: pai_car.action_context_id
3051: from pay_payroll_actions ppa,
3052: pay_assignment_actions paa,
3053: pay_action_information pai_comp,

Line 3053: pay_action_information pai_comp,

3049: use_index(pai_car,pay_action_information_n2) */
3050: pai_car.action_context_id
3051: from pay_payroll_actions ppa,
3052: pay_assignment_actions paa,
3053: pay_action_information pai_comp,
3054: pay_action_information pai_person,
3055: pay_action_information pai_car
3056: where ppa.payroll_action_id = p_pactid
3057: and paa.payroll_action_id = ppa.payroll_action_id

Line 3054: pay_action_information pai_person,

3050: pai_car.action_context_id
3051: from pay_payroll_actions ppa,
3052: pay_assignment_actions paa,
3053: pay_action_information pai_comp,
3054: pay_action_information pai_person,
3055: pay_action_information pai_car
3056: where ppa.payroll_action_id = p_pactid
3057: and paa.payroll_action_id = ppa.payroll_action_id
3058: and pai_comp.action_context_id = paa.assignment_action_id

Line 3055: pay_action_information pai_car

3051: from pay_payroll_actions ppa,
3052: pay_assignment_actions paa,
3053: pay_action_information pai_comp,
3054: pay_action_information pai_person,
3055: pay_action_information pai_car
3056: where ppa.payroll_action_id = p_pactid
3057: and paa.payroll_action_id = ppa.payroll_action_id
3058: and pai_comp.action_context_id = paa.assignment_action_id
3059: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'

Line 3130: from pay_action_information pai_emp

3126: to_char(to_number(pai_emp.action_information28),'FM999,999,990.00') FUEL_SCALE,
3127: nvl(pai_emp.action_information21,0) ben_charge,
3128: nvl(pai_emp.action_information26,0) stand_disc,
3129: nvl(pai_emp.action_information27,0) additional_disc
3130: from pay_action_information pai_emp
3131: where pai_emp.action_information_category = 'CAR AND CAR FUEL'
3132: and pai_emp.action_context_id = p_context_id
3133: and pai_emp.action_context_type = 'AAP';
3134:

Line 3200: from pay_action_information pai_emp

3196: to_char(to_number(nvl(pai_emp.action_information20,0) +
3197: nvl(pai_emp.action_information28,0)) ) ) total_days ,
3198: to_char(to_number(nvl(pai_emp.action_information30,0)),'FM999,999,990') fuel_unavailable,
3199: pai_emp.action_information4 full_end_date
3200: from pay_action_information pai_emp
3201: where pai_emp.action_information_category = 'CAR AND CAR FUEL 2003_04'
3202: and pai_emp.action_context_id = p_context_id
3203: and pai_emp.action_context_type = 'AAP';
3204:

Line 3339: from pay_action_information pai_emp

3335: end if;
3336: hr_utility.trace('A4');
3337: select action_information30
3338: into l_car_count
3339: from pay_action_information pai_emp
3340: where pai_emp.action_context_id = p_assignment_action_id
3341: and pai_emp.action_information_category = 'GB P11D ASSIGNMENT RESULTA';
3342:
3343: hr_utility.trace('A5');

Line 3591: from pay_action_information pai_emp

3587: -- hr_utility.trace_on(null,'CAR');
3588: hr_utility.trace('A4');
3589: select action_information30
3590: into l_car_count
3591: from pay_action_information pai_emp
3592: where pai_emp.action_context_id = p_assignment_action_id
3593: and pai_emp.action_information_category = 'GB P11D ASSIGNMENT RESULTA';
3594: hr_utility.trace('A5');
3595: if l_car_count = 1

Line 3805: from pay_action_information pai_emp

3801: -- hr_utility.trace_on(null,'CAR');
3802: hr_utility.trace('A4');
3803: select action_information30
3804: into l_car_count
3805: from pay_action_information pai_emp
3806: where pai_emp.action_context_id = p_assignment_action_id
3807: and pai_emp.action_information_category = 'GB P11D ASSIGNMENT RESULTA';
3808: hr_utility.trace('A5');
3809: if l_car_count = 1

Line 4114: from pay_action_information

4110: nvl(ACTION_INFORMATION12,0) UNAVAILABLE_VAL,
4111: nvl(ACTION_INFORMATION13,0) NUM_SHARE,
4112: nvl(ACTION_INFORMATION14,0) PVT_USE_PAYMENT,
4113: nvl(ACTION_INFORMATION15,0) CASH_EQUIVALENT
4114: from pay_action_information
4115: where action_information_category = 'VANS 2002_03'
4116: and action_context_id in (select paa.assignment_action_id
4117: from pay_action_information pai_comp,
4118: pay_action_information pai_person,

Line 4117: from pay_action_information pai_comp,

4113: nvl(ACTION_INFORMATION15,0) CASH_EQUIVALENT
4114: from pay_action_information
4115: where action_information_category = 'VANS 2002_03'
4116: and action_context_id in (select paa.assignment_action_id
4117: from pay_action_information pai_comp,
4118: pay_action_information pai_person,
4119: pay_assignment_actions paa,
4120: pay_payroll_actions ppa
4121: where ppa.payroll_action_id = p_pactid

Line 4118: pay_action_information pai_person,

4114: from pay_action_information
4115: where action_information_category = 'VANS 2002_03'
4116: and action_context_id in (select paa.assignment_action_id
4117: from pay_action_information pai_comp,
4118: pay_action_information pai_person,
4119: pay_assignment_actions paa,
4120: pay_payroll_actions ppa
4121: where ppa.payroll_action_id = p_pactid
4122: and paa.payroll_action_id = ppa.payroll_action_id

Line 4162: from pay_action_information

4158: nvl(action_information12,0) van_reduce_share, -- K
4159: nvl(action_information14,0) van_private_uses, -- L
4160: nvl(action_information15,0) van_benefit_charge, -- M
4161: action_context_id
4162: from pay_action_information
4163: where action_information_category = 'VANS 2005'
4164: and action_context_type = 'AAP'
4165: and action_context_id in (select paa.assignment_action_id
4166: from pay_action_information pai_comp,

Line 4166: from pay_action_information pai_comp,

4162: from pay_action_information
4163: where action_information_category = 'VANS 2005'
4164: and action_context_type = 'AAP'
4165: and action_context_id in (select paa.assignment_action_id
4166: from pay_action_information pai_comp,
4167: pay_action_information pai_person,
4168: pay_assignment_actions paa,
4169: pay_payroll_actions ppa
4170: where ppa.payroll_action_id = p_pactid

Line 4167: pay_action_information pai_person,

4163: where action_information_category = 'VANS 2005'
4164: and action_context_type = 'AAP'
4165: and action_context_id in (select paa.assignment_action_id
4166: from pay_action_information pai_comp,
4167: pay_action_information pai_person,
4168: pay_assignment_actions paa,
4169: pay_payroll_actions ppa
4170: where ppa.payroll_action_id = p_pactid
4171: and paa.payroll_action_id = ppa.payroll_action_id

Line 4189: from pay_action_information

4185: p_emp_ref Varchar2 ,
4186: p_emp_name Varchar2)
4187: is
4188: select count(*)
4189: from pay_action_information
4190: where action_information_category = 'VANS 2005'
4191: and action_context_type = 'AAP'
4192: and action_context_id in (select paa.assignment_action_id
4193: from pay_action_information pai_comp,

Line 4193: from pay_action_information pai_comp,

4189: from pay_action_information
4190: where action_information_category = 'VANS 2005'
4191: and action_context_type = 'AAP'
4192: and action_context_id in (select paa.assignment_action_id
4193: from pay_action_information pai_comp,
4194: pay_action_information pai_person,
4195: pay_assignment_actions paa,
4196: pay_payroll_actions ppa
4197: where ppa.payroll_action_id = p_pactid

Line 4194: pay_action_information pai_person,

4190: where action_information_category = 'VANS 2005'
4191: and action_context_type = 'AAP'
4192: and action_context_id in (select paa.assignment_action_id
4193: from pay_action_information pai_comp,
4194: pay_action_information pai_person,
4195: pay_assignment_actions paa,
4196: pay_payroll_actions ppa
4197: where ppa.payroll_action_id = p_pactid
4198: and paa.payroll_action_id = ppa.payroll_action_id

Line 4250: from pay_action_information

4246: - nvl(action_information28,0)) van_fuel_charge_reduction, --V
4247: nvl(action_information29,0) van_reduction_sharing, --W
4248: nvl(action_information30,0) van_feul_ben_charge, --X
4249: action_context_id
4250: from pay_action_information
4251: where action_information_category = 'VANS 2007'
4252: and action_context_type = 'AAP'
4253: and action_context_id in (select paa.assignment_action_id
4254: from pay_action_information pai_comp,

Line 4254: from pay_action_information pai_comp,

4250: from pay_action_information
4251: where action_information_category = 'VANS 2007'
4252: and action_context_type = 'AAP'
4253: and action_context_id in (select paa.assignment_action_id
4254: from pay_action_information pai_comp,
4255: pay_action_information pai_person,
4256: pay_assignment_actions paa,
4257: pay_payroll_actions ppa
4258: where ppa.payroll_action_id = p_pactid

Line 4255: pay_action_information pai_person,

4251: where action_information_category = 'VANS 2007'
4252: and action_context_type = 'AAP'
4253: and action_context_id in (select paa.assignment_action_id
4254: from pay_action_information pai_comp,
4255: pay_action_information pai_person,
4256: pay_assignment_actions paa,
4257: pay_payroll_actions ppa
4258: where ppa.payroll_action_id = p_pactid
4259: and paa.payroll_action_id = ppa.payroll_action_id

Line 4278: from pay_action_information

4274: p_emp_ref Varchar2 ,
4275: p_emp_name Varchar2)
4276: is
4277: select count(*)
4278: from pay_action_information
4279: where action_information_category = 'VANS 2007'
4280: and action_context_type = 'AAP'
4281: and action_context_id in (select paa.assignment_action_id
4282: from pay_action_information pai_comp,

Line 4282: from pay_action_information pai_comp,

4278: from pay_action_information
4279: where action_information_category = 'VANS 2007'
4280: and action_context_type = 'AAP'
4281: and action_context_id in (select paa.assignment_action_id
4282: from pay_action_information pai_comp,
4283: pay_action_information pai_person,
4284: pay_assignment_actions paa,
4285: pay_payroll_actions ppa
4286: where ppa.payroll_action_id = p_pactid

Line 4283: pay_action_information pai_person,

4279: where action_information_category = 'VANS 2007'
4280: and action_context_type = 'AAP'
4281: and action_context_id in (select paa.assignment_action_id
4282: from pay_action_information pai_comp,
4283: pay_action_information pai_person,
4284: pay_assignment_actions paa,
4285: pay_payroll_actions ppa
4286: where ppa.payroll_action_id = p_pactid
4287: and paa.payroll_action_id = ppa.payroll_action_id

Line 4721: from pay_action_information

4717: ACTION_INFORMATION11 Cash_Equivalent,
4718: ACTION_INFORMATION19 Annual_Interest_Value,
4719: ACTION_INFORMATION20 Interest_Value,
4720: action_context_id
4721: from pay_action_information
4722: where action_information_category = 'INT FREE AND LOW INT LOANS'
4723: and action_context_type = 'AAP'
4724: and action_context_id in(select paa.assignment_action_id
4725: from pay_action_information pai_comp,

Line 4725: from pay_action_information pai_comp,

4721: from pay_action_information
4722: where action_information_category = 'INT FREE AND LOW INT LOANS'
4723: and action_context_type = 'AAP'
4724: and action_context_id in(select paa.assignment_action_id
4725: from pay_action_information pai_comp,
4726: pay_action_information pai_person,
4727: pay_assignment_actions paa,
4728: pay_payroll_actions ppa
4729: where ppa.payroll_action_id = p_pactid

Line 4726: pay_action_information pai_person,

4722: where action_information_category = 'INT FREE AND LOW INT LOANS'
4723: and action_context_type = 'AAP'
4724: and action_context_id in(select paa.assignment_action_id
4725: from pay_action_information pai_comp,
4726: pay_action_information pai_person,
4727: pay_assignment_actions paa,
4728: pay_payroll_actions ppa
4729: where ppa.payroll_action_id = p_pactid
4730: and paa.payroll_action_id = ppa.payroll_action_id

Line 4793: from pay_action_information pai_emp

4789: l_tab_index := 0;
4790:
4791: select to_number(nvl(ACTION_INFORMATION23,'0'))
4792: into l_h_sum_max_amt_outstanding
4793: from pay_action_information pai_emp
4794: where pai_emp.action_context_id = p_assignment_action_id
4795: and pai_emp.action_information_category = 'GB P11D ASSIGNMENT RESULTC';
4796:
4797: if to_number(l_rep_run) < 2007 then

Line 4919: from pay_action_information pai_ben

4915: to_char(to_number(nvl(pai_ben.action_information14,0)),'FM999,999,990.00') EARLIER_YEARS,
4916: to_char(to_number(nvl(pai_ben.action_information15,0)),'FM999,999,990.00') AMOUNT_EXEMPTED,
4917: to_char(to_number(nvl(pai_ben.action_information5,0)),'FM999,999,990.00') FINAL_AMOUNT,
4918: action_context_id
4919: from pay_action_information pai_ben
4920: where pai_ben.action_information_category = 'RELOCATION EXPENSES'
4921: and pai_ben.action_context_type = 'AAP'
4922: and pai_ben.action_context_id in ( select paa.assignment_action_id
4923: from pay_action_information pai_comp,

Line 4923: from pay_action_information pai_comp,

4919: from pay_action_information pai_ben
4920: where pai_ben.action_information_category = 'RELOCATION EXPENSES'
4921: and pai_ben.action_context_type = 'AAP'
4922: and pai_ben.action_context_id in ( select paa.assignment_action_id
4923: from pay_action_information pai_comp,
4924: pay_action_information pai_person,
4925: pay_assignment_actions paa,
4926: pay_payroll_actions ppa
4927: where ppa.payroll_action_id = p_pactid

Line 4924: pay_action_information pai_person,

4920: where pai_ben.action_information_category = 'RELOCATION EXPENSES'
4921: and pai_ben.action_context_type = 'AAP'
4922: and pai_ben.action_context_id in ( select paa.assignment_action_id
4923: from pay_action_information pai_comp,
4924: pay_action_information pai_person,
4925: pay_assignment_actions paa,
4926: pay_payroll_actions ppa
4927: where ppa.payroll_action_id = p_pactid
4928: and paa.payroll_action_id = ppa.payroll_action_id

Line 5094: from pay_action_information

5090: nvl(ACTION_INFORMATION9,0) b_reimbursement_rate2,
5091: nvl(ACTION_INFORMATION19,0) PASSEN_PAYMENTS,
5092: nvl(ACTION_INFORMATION20,0) PASSEN_BUSINESS_MILES,
5093: nvl(ACTION_INFORMATION21,0) PASSENGER_BUS_MILES_AMOUNT
5094: from pay_action_information
5095: where action_information_category = 'GB P11D ASSIGNMENT RESULTC'
5096: and action_context_type = 'AAP'
5097: and action_context_id = p_assignment_action_id;/*Removed sub query for assignment action id*/
5098:

Line 5103: use_index(pai_person,pay_action_information_n2)

5099: --Start of the fix for the EAP bug 9383416
5100: cursor get_ben_value (c_emp_ref in varchar2) is
5101:
5102: select /*+ ORDERED use_nl(paa,pai,pai_a,pai_person)
5103: use_index(pai_person,pay_action_information_n2)
5104: use_index(pai,pay_action_information_n2)
5105: use_index(pai_a,pay_action_information_n2)*/
5106: pai_a.action_information12
5107: from pay_assignment_actions paa,

Line 5104: use_index(pai,pay_action_information_n2)

5100: cursor get_ben_value (c_emp_ref in varchar2) is
5101:
5102: select /*+ ORDERED use_nl(paa,pai,pai_a,pai_person)
5103: use_index(pai_person,pay_action_information_n2)
5104: use_index(pai,pay_action_information_n2)
5105: use_index(pai_a,pay_action_information_n2)*/
5106: pai_a.action_information12
5107: from pay_assignment_actions paa,
5108: pay_action_information pai,

Line 5105: use_index(pai_a,pay_action_information_n2)*/

5101:
5102: select /*+ ORDERED use_nl(paa,pai,pai_a,pai_person)
5103: use_index(pai_person,pay_action_information_n2)
5104: use_index(pai,pay_action_information_n2)
5105: use_index(pai_a,pay_action_information_n2)*/
5106: pai_a.action_information12
5107: from pay_assignment_actions paa,
5108: pay_action_information pai,
5109: pay_action_information pai_a,

Line 5108: pay_action_information pai,

5104: use_index(pai,pay_action_information_n2)
5105: use_index(pai_a,pay_action_information_n2)*/
5106: pai_a.action_information12
5107: from pay_assignment_actions paa,
5108: pay_action_information pai,
5109: pay_action_information pai_a,
5110: pay_action_information pai_person
5111: where paa.assignment_action_id = p_assignment_action_id
5112: and pai.action_context_id = paa.assignment_action_id

Line 5109: pay_action_information pai_a,

5105: use_index(pai_a,pay_action_information_n2)*/
5106: pai_a.action_information12
5107: from pay_assignment_actions paa,
5108: pay_action_information pai,
5109: pay_action_information pai_a,
5110: pay_action_information pai_person
5111: where paa.assignment_action_id = p_assignment_action_id
5112: and pai.action_context_id = paa.assignment_action_id
5113: and pai.action_context_type = 'AAP'

Line 5110: pay_action_information pai_person

5106: pai_a.action_information12
5107: from pay_assignment_actions paa,
5108: pay_action_information pai,
5109: pay_action_information pai_a,
5110: pay_action_information pai_person
5111: where paa.assignment_action_id = p_assignment_action_id
5112: and pai.action_context_id = paa.assignment_action_id
5113: and pai.action_context_type = 'AAP'
5114: and pai.action_information_category = pai.action_information_category

Line 5130: from pay_action_information pai,

5126: cursor get_other_asg_mil_ben (c_asg_act_id number,
5127: c_pact_id number,
5128: c_person_id number)is
5129: select pai_a.action_information12 --Modified for the bug 9799823
5130: from pay_action_information pai,
5131: pay_assignment_actions paa,
5132: pay_action_information pai_a,
5133: per_all_assignments_f paaf
5134: where paa.payroll_action_id = c_pact_id

Line 5132: pay_action_information pai_a,

5128: c_person_id number)is
5129: select pai_a.action_information12 --Modified for the bug 9799823
5130: from pay_action_information pai,
5131: pay_assignment_actions paa,
5132: pay_action_information pai_a,
5133: per_all_assignments_f paaf
5134: where paa.payroll_action_id = c_pact_id
5135: and pai.action_context_id = paa.assignment_action_id
5136: and paa.assignment_action_id <> c_asg_act_id

Line 5525: from pay_action_information

5521: 'OTHER ITEMS NON 1A',ACTION_INFORMATION9,
5522: 'EXPENSES PAYMENTS',ACTION_INFORMATION8) LINE_COL3,
5523: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION3),'DD-MON-YYYY') LINE_START_DATE,
5524: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION4),'DD-MON-YYYY') LINE_END_DATE
5525: from pay_action_information
5526: where action_information_category in(
5527: 'ASSETS TRANSFERRED',
5528: 'PAYMENTS MADE FOR EMP',
5529: 'VOUCHERS OR CREDIT CARDS',

Line 5539: from pay_action_information pai_comp,

5535: 'OTHER ITEMS NON 1A',
5536: 'EXPENSES PAYMENTS')
5537: and action_context_type = 'AAP'
5538: and action_context_id in ( select paa.assignment_action_id
5539: from pay_action_information pai_comp,
5540: pay_action_information pai_person,
5541: pay_assignment_actions paa,
5542: pay_payroll_actions ppa
5543: where ppa.payroll_action_id = p_pactid

Line 5540: pay_action_information pai_person,

5536: 'EXPENSES PAYMENTS')
5537: and action_context_type = 'AAP'
5538: and action_context_id in ( select paa.assignment_action_id
5539: from pay_action_information pai_comp,
5540: pay_action_information pai_person,
5541: pay_assignment_actions paa,
5542: pay_payroll_actions ppa
5543: where ppa.payroll_action_id = p_pactid
5544: and paa.payroll_action_id = ppa.payroll_action_id

Line 5661: from pay_action_information

5657: 'OTHER ITEMS NON 1A',ACTION_INFORMATION9,
5658: 'EXPENSES PAYMENTS',ACTION_INFORMATION8) LINE_COL3,
5659: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION3),'DD-MON-YYYY') LINE_START_DATE,
5660: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION4),'DD-MON-YYYY') LINE_END_DATE
5661: from pay_action_information
5662: where action_information_category in(
5663: 'ASSETS TRANSFERRED',
5664: 'PAYMENTS MADE FOR EMP',
5665: 'VOUCHERS OR CREDIT CARDS',

Line 5674: from pay_action_information pai_comp,

5670: 'OTHER ITEMS NON 1A',
5671: 'EXPENSES PAYMENTS')
5672: and action_context_type = 'AAP'
5673: and action_context_id in ( select paa.assignment_action_id
5674: from pay_action_information pai_comp,
5675: pay_action_information pai_person,
5676: pay_assignment_actions paa,
5677: pay_payroll_actions ppa
5678: where ppa.payroll_action_id = p_pactid

Line 5675: pay_action_information pai_person,

5671: 'EXPENSES PAYMENTS')
5672: and action_context_type = 'AAP'
5673: and action_context_id in ( select paa.assignment_action_id
5674: from pay_action_information pai_comp,
5675: pay_action_information pai_person,
5676: pay_assignment_actions paa,
5677: pay_payroll_actions ppa
5678: where ppa.payroll_action_id = p_pactid
5679: and paa.payroll_action_id = ppa.payroll_action_id

Line 6364: from pay_action_information emp

6360:
6361: cursor csr_person_name
6362: is
6363: select emp.action_information1 emp_name
6364: from pay_action_information emp
6365: where emp.action_information_category = 'EMPLOYEE DETAILS'
6366: and emp.action_context_id = p_assignment_action_id
6367: and emp.action_context_type = 'AAP';
6368:

Line 6378: ,pay_action_information emp -- Employee Details

6374: ,adr.action_information8 adr_town
6375: ,adr.action_information12 adr_county
6376: ,adr.action_information9 adr_code
6377: from pay_assignment_actions paa
6378: ,pay_action_information emp -- Employee Details
6379: ,pay_action_information adr -- Address Details
6380: ,pay_action_information prl -- EMEA Payroll Info
6381: where paa.assignment_action_id = p_assignment_action_id
6382: and emp.action_information_category = 'EMPLOYEE DETAILS'

Line 6379: ,pay_action_information adr -- Address Details

6375: ,adr.action_information12 adr_county
6376: ,adr.action_information9 adr_code
6377: from pay_assignment_actions paa
6378: ,pay_action_information emp -- Employee Details
6379: ,pay_action_information adr -- Address Details
6380: ,pay_action_information prl -- EMEA Payroll Info
6381: where paa.assignment_action_id = p_assignment_action_id
6382: and emp.action_information_category = 'EMPLOYEE DETAILS'
6383: and emp.action_context_id = paa.assignment_action_id

Line 6380: ,pay_action_information prl -- EMEA Payroll Info

6376: ,adr.action_information9 adr_code
6377: from pay_assignment_actions paa
6378: ,pay_action_information emp -- Employee Details
6379: ,pay_action_information adr -- Address Details
6380: ,pay_action_information prl -- EMEA Payroll Info
6381: where paa.assignment_action_id = p_assignment_action_id
6382: and emp.action_information_category = 'EMPLOYEE DETAILS'
6383: and emp.action_context_id = paa.assignment_action_id
6384: and emp.action_context_type = 'AAP'

Line 6416: l_adress1 pay_action_information.action_information5%type;

6412:
6413: l_xfdf_str clob;
6414: l_xfdf_blob_str blob;
6415: l_xfdf_intermetiate_var varchar2(20000);
6416: l_adress1 pay_action_information.action_information5%type;
6417: l_adress2 pay_action_information.action_information6%type;
6418: l_adress3 pay_action_information.action_information7%type;
6419: l_town pay_action_information.action_information8%type;
6420: l_county pay_action_information.action_information12%type;

Line 6417: l_adress2 pay_action_information.action_information6%type;

6413: l_xfdf_str clob;
6414: l_xfdf_blob_str blob;
6415: l_xfdf_intermetiate_var varchar2(20000);
6416: l_adress1 pay_action_information.action_information5%type;
6417: l_adress2 pay_action_information.action_information6%type;
6418: l_adress3 pay_action_information.action_information7%type;
6419: l_town pay_action_information.action_information8%type;
6420: l_county pay_action_information.action_information12%type;
6421: l_employee_name pay_action_information.action_information1%type;

Line 6418: l_adress3 pay_action_information.action_information7%type;

6414: l_xfdf_blob_str blob;
6415: l_xfdf_intermetiate_var varchar2(20000);
6416: l_adress1 pay_action_information.action_information5%type;
6417: l_adress2 pay_action_information.action_information6%type;
6418: l_adress3 pay_action_information.action_information7%type;
6419: l_town pay_action_information.action_information8%type;
6420: l_county pay_action_information.action_information12%type;
6421: l_employee_name pay_action_information.action_information1%type;
6422: l_sur_name varchar2(150); -- P11D 08/09

Line 6419: l_town pay_action_information.action_information8%type;

6415: l_xfdf_intermetiate_var varchar2(20000);
6416: l_adress1 pay_action_information.action_information5%type;
6417: l_adress2 pay_action_information.action_information6%type;
6418: l_adress3 pay_action_information.action_information7%type;
6419: l_town pay_action_information.action_information8%type;
6420: l_county pay_action_information.action_information12%type;
6421: l_employee_name pay_action_information.action_information1%type;
6422: l_sur_name varchar2(150); -- P11D 08/09
6423: l_fore_name varchar2(150); -- P11D 08/09

Line 6420: l_county pay_action_information.action_information12%type;

6416: l_adress1 pay_action_information.action_information5%type;
6417: l_adress2 pay_action_information.action_information6%type;
6418: l_adress3 pay_action_information.action_information7%type;
6419: l_town pay_action_information.action_information8%type;
6420: l_county pay_action_information.action_information12%type;
6421: l_employee_name pay_action_information.action_information1%type;
6422: l_sur_name varchar2(150); -- P11D 08/09
6423: l_fore_name varchar2(150); -- P11D 08/09
6424: l_code pay_action_information.action_information9%type;

Line 6421: l_employee_name pay_action_information.action_information1%type;

6417: l_adress2 pay_action_information.action_information6%type;
6418: l_adress3 pay_action_information.action_information7%type;
6419: l_town pay_action_information.action_information8%type;
6420: l_county pay_action_information.action_information12%type;
6421: l_employee_name pay_action_information.action_information1%type;
6422: l_sur_name varchar2(150); -- P11D 08/09
6423: l_fore_name varchar2(150); -- P11D 08/09
6424: l_code pay_action_information.action_information9%type;
6425: l_meaning hr_lookups.meaning%type;

Line 6424: l_code pay_action_information.action_information9%type;

6420: l_county pay_action_information.action_information12%type;
6421: l_employee_name pay_action_information.action_information1%type;
6422: l_sur_name varchar2(150); -- P11D 08/09
6423: l_fore_name varchar2(150); -- P11D 08/09
6424: l_code pay_action_information.action_information9%type;
6425: l_meaning hr_lookups.meaning%type;
6426: --Parameter Added for bug 8942337
6427: l_priv_mark_meaning hr_lookups.meaning%type;
6428:

Line 6529: pay_action_information pai_comp

6525: -- In case if only secondary have benefits then we may write
6526: -- any secondary assignment number in the magtape
6527: FROM per_assignments_f paf,
6528: pay_assignment_actions paa,
6529: pay_action_information pai_comp
6530: WHERE paf.person_id = p_person_id
6531: AND paa.assignment_id = paf.assignment_id
6532: AND paa.payroll_action_id = p_arch_payroll_action_id
6533: AND pai_comp.action_context_id = paa.assignment_action_id

Line 6545: pay_action_information pai_comp,

6541: SELECT /*+ ordered */
6542: SUM (TO_NUMBER (NVL (pai.action_information7, '0')))
6543: FROM per_assignments_f paf,
6544: pay_assignment_actions paa,
6545: pay_action_information pai_comp,
6546: pay_action_information pai
6547: WHERE paf.person_id = p_person_id
6548: AND paa.payroll_action_id = p_arch_payroll_action_id
6549: AND paa.assignment_id = paf.assignment_id

Line 6546: pay_action_information pai

6542: SUM (TO_NUMBER (NVL (pai.action_information7, '0')))
6543: FROM per_assignments_f paf,
6544: pay_assignment_actions paa,
6545: pay_action_information pai_comp,
6546: pay_action_information pai
6547: WHERE paf.person_id = p_person_id
6548: AND paa.payroll_action_id = p_arch_payroll_action_id
6549: AND paa.assignment_id = paf.assignment_id
6550: AND pai_comp.action_context_id = paa.assignment_action_id

Line 6561: FROM pay_action_information pai

6557: CURSOR fetch_ben_values (p_assignment_action_id NUMBER,
6558: p_action_info_catg VARCHAR2)
6559: IS
6560: SELECT *
6561: FROM pay_action_information pai
6562: WHERE pai.action_context_id = p_assignment_action_id
6563: AND pai.action_information_category = p_action_info_catg;
6564:
6565: l_ce_values_a fetch_ben_values%ROWTYPE;