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 607: pay_action_information pai_comp,

603: cursor asg_low is
604: select min(paa2.assignment_id)
605: from pay_assignment_actions paa,
606: pay_assignment_actions paa2,
607: pay_action_information pai_comp,
608: pay_action_information pai_person
609: where paa.assignment_action_id = p_action_id
610: and paa2.payroll_action_id = paa.payroll_action_id
611: and pai_comp.action_context_id = paa2.assignment_action_id

Line 608: pay_action_information pai_person

604: select min(paa2.assignment_id)
605: from pay_assignment_actions paa,
606: pay_assignment_actions paa2,
607: pay_action_information pai_comp,
608: pay_action_information pai_person
609: where paa.assignment_action_id = p_action_id
610: and paa2.payroll_action_id = paa.payroll_action_id
611: and pai_comp.action_context_id = paa2.assignment_action_id
612: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'

Line 671: from pay_action_information pai_person

667: begin
668: -- populating the person id
669: select action_information1
670: into g_person_id
671: from pay_action_information pai_person
672: where pai_person.action_context_id = p_assignment_action_id
673: and pai_person.action_information_category = 'ADDRESS DETAILS'
674: and pai_person.action_context_type = 'AAP'
675: and pai_person.action_information14 = 'Employee Address';

Line 681: from pay_action_information pai_comp

677: select action_information6,
678: action_information7
679: into g_emp_ref_no,
680: g_employer_name
681: from pay_action_information pai_comp
682: where pai_comp.action_context_id = p_assignment_action_id
683: and pai_comp.action_context_type = 'AAP'
684: and pai_comp.action_information_category = 'EMEA PAYROLL INFO';
685:

Line 702: from pay_action_information pai_gb

698: l_p11d_fields.sur_name,
699: l_p11d_fields.fore_name,
700: l_p11d_fields.date_of_birth,
701: l_p11d_fields.gender
702: from pay_action_information pai_gb
703: where pai_gb.action_context_id = p_assignment_action_id
704: and pai_gb.action_context_type = 'AAP'
705: and pai_gb.action_information_category = 'GB EMPLOYEE DETAILS';
706: --

Line 714: from pay_action_information pai_emp

710: -- action_information14 -- assign num
711: into l_p11d_fields.full_name,
712: l_p11d_fields.national_ins_no,
713: l_p11d_fields.employee_number
714: from pay_action_information pai_emp
715: where pai_emp.action_context_id = p_assignment_action_id
716: and pai_emp.action_context_type = 'AAP'
717: and pai_emp.action_information_category = 'EMPLOYEE DETAILS';
718:

Line 772: from pay_action_information pai_emp

768: l_p11d_fields.j_ce, l_p11d_fields.k_cost, l_p11d_fields.k_amg,
769: l_p11d_fields.k_ce, l_p11d_fields.l_desc, l_p11d_fields.l_cost,
770: l_p11d_fields.l_amg, l_p11d_fields.l_ce, l_p11d_fields.m_shares,
771: l_h_ce, l_h_count, l_f_count
772: from pay_action_information pai_emp
773: where pai_emp.action_context_id = p_assignment_action_id
774: and pai_emp.action_context_type = 'AAP'
775: and pai_emp.action_information_category = 'GB P11D ASSIGNMENT RESULTA';
776:

Line 818: from pay_action_information pai_emp

814: l_p11d_fields.o4_cost, l_p11d_fields.o4_amg, l_p11d_fields.o4_ce,
815: l_p11d_fields.o5_cost, l_p11d_fields.o5_amg, l_p11d_fields.o5_ce,
816: l_p11d_fields.o6_desc, l_p11d_fields.o6_cost,
817: l_p11d_fields.o6_amg, l_p11d_fields.o6_ce
818: from pay_action_information pai_emp
819: where pai_emp.action_context_id = p_assignment_action_id
820: and pai_emp.action_context_type = 'AAP'
821: and pai_emp.action_information_category = 'GB P11D ASSIGNMENT RESULTB';
822:

Line 830: from pay_action_information pai_emp

826: substr(action_information10,1,4) ,
827: decode (action_information11,null,'N','Y'),to_number(nvl(ACTION_INFORMATION23,'0'))
828: into l_p11d_fields.f_date_free,l_p11d_fields.f_rein_yr,
829: l_h_sum_max_amt_outstanding
830: from pay_action_information pai_emp
831: where pai_emp.action_context_id = p_assignment_action_id
832: and pai_emp.action_context_type = 'AAP'
833: and pai_emp.action_information_category = 'GB P11D ASSIGNMENT RESULTC';
834:

Line 875: from pay_action_information pai_emp

871: l_p11d_fields.j_ce, l_p11d_fields.k_cost, l_p11d_fields.k_amg,
872: l_p11d_fields.k_ce, l_p11d_fields.l_desc, l_p11d_fields.l_cost,
873: l_p11d_fields.l_amg, l_p11d_fields.l_ce,
874: l_h_ce, l_h_count, l_f_count
875: from pay_action_information pai_emp
876: where pai_emp.action_context_id = p_assignment_action_id
877: and pai_emp.action_context_type = 'AAP'
878: and pai_emp.action_information_category = 'GB P11D ASSIGNMENT RESULTA';
879:

Line 922: from pay_action_information pai_emp

918: l_p11d_fields.o4_cost, l_p11d_fields.o4_amg, l_p11d_fields.o4_ce,
919: l_p11d_fields.o5_cost, l_p11d_fields.o5_amg, l_p11d_fields.o5_ce,
920: l_p11d_fields.o6_desc, l_p11d_fields.o6_cost,
921: l_p11d_fields.o6_amg, l_p11d_fields.o6_ce, l_p11d_fields.g_cef
922: from pay_action_information pai_emp
923: where pai_emp.action_context_id = p_assignment_action_id
924: and pai_emp.action_context_type = 'AAP'
925: and pai_emp.action_information_category = 'GB P11D ASSIGNMENT RESULTB';
926:

Line 930: from pay_action_information pai_emp

926:
927: hr_utility.trace('Fetching from Result C');
928: select to_number(nvl(ACTION_INFORMATION23,'0'))
929: into l_h_sum_max_amt_outstanding
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 RESULTC';
934: end if;

Line 971: from pay_action_information pai_emp

967: substr(action_information26,6,2) || ' ' ||
968: substr(action_information26,1,4) f_date_free,
969: decode(action_information27,'Y','Y','N') f_rein_yr,
970: pai_emp.action_information18 f_esize
971: from pay_action_information pai_emp
972: where pai_emp.action_information_category = 'CAR AND CAR FUEL 2003_04'
973: and pai_emp.action_context_type = 'AAP'
974: and pai_emp.action_context_id in( select paa.assignment_action_id
975: from pay_action_information pai_comp,

Line 975: from pay_action_information pai_comp,

971: from pay_action_information pai_emp
972: where pai_emp.action_information_category = 'CAR AND CAR FUEL 2003_04'
973: and pai_emp.action_context_type = 'AAP'
974: and pai_emp.action_context_id in( select paa.assignment_action_id
975: from pay_action_information pai_comp,
976: pay_action_information pai_person,
977: pay_assignment_actions paa,
978: pay_payroll_actions ppa
979: where ppa.payroll_action_id = p_pactid

Line 976: pay_action_information pai_person,

972: where pai_emp.action_information_category = 'CAR AND CAR FUEL 2003_04'
973: and pai_emp.action_context_type = 'AAP'
974: and pai_emp.action_context_id in( select paa.assignment_action_id
975: from pay_action_information pai_comp,
976: pay_action_information pai_person,
977: pay_assignment_actions paa,
978: pay_payroll_actions ppa
979: where ppa.payroll_action_id = p_pactid
980: and paa.payroll_action_id = ppa.payroll_action_id

Line 1126: from pay_action_information pai_emp

1122: substr(pai_emp.action_information10,6,2) ||decode(pai_emp.action_information10,null,null,' ') ||
1123: substr(pai_emp.action_information10,1,4) h_dld,
1124: to_char(to_number(nvl(pai_emp.action_information11,'0')),'FM999,999,990.00') h_ce,
1125: to_char(to_number(nvl(pai_emp.action_information16,'0')),'FM999,999,990.00') h_aye
1126: from pay_action_information pai_emp
1127: where pai_emp.action_information_category = 'INT FREE AND LOW INT LOANS'
1128: and pai_emp.action_context_type = 'AAP'
1129: and pai_emp.action_context_id in ( select paa.assignment_action_id
1130: from pay_action_information pai_comp,

Line 1130: from pay_action_information pai_comp,

1126: from pay_action_information pai_emp
1127: where pai_emp.action_information_category = 'INT FREE AND LOW INT LOANS'
1128: and pai_emp.action_context_type = 'AAP'
1129: and pai_emp.action_context_id in ( select paa.assignment_action_id
1130: from pay_action_information pai_comp,
1131: pay_action_information pai_person,
1132: pay_assignment_actions paa,
1133: pay_payroll_actions ppa
1134: where ppa.payroll_action_id = p_pactid

Line 1131: pay_action_information pai_person,

1127: where pai_emp.action_information_category = 'INT FREE AND LOW INT LOANS'
1128: and pai_emp.action_context_type = 'AAP'
1129: and pai_emp.action_context_id in ( select paa.assignment_action_id
1130: from pay_action_information pai_comp,
1131: pay_action_information pai_person,
1132: pay_assignment_actions paa,
1133: pay_payroll_actions ppa
1134: where ppa.payroll_action_id = p_pactid
1135: and paa.payroll_action_id = ppa.payroll_action_id

Line 2067: from pay_action_information pai_person

2063: is
2064: cursor csr_person_id
2065: is
2066: select action_information1
2067: from pay_action_information pai_person
2068: where pai_person.action_context_id = p_assignment_action_id
2069: and pai_person.action_information_category = 'ADDRESS DETAILS'
2070: and pai_person.action_information14 = 'Employee Address';
2071: l_person_id number;

Line 2087: from pay_action_information pai_comp

2083: cursor csr_employer_details
2084: is
2085: select action_information6,
2086: action_information7
2087: from pay_action_information pai_comp
2088: where pai_comp.action_context_id = p_assignment_action_id
2089: and pai_comp.action_information_category = 'EMEA PAYROLL INFO';
2090: begin
2091: open csr_employer_details;

Line 2107: from pay_action_information pai_emp

2103: is
2104: select action_information1,
2105: action_information4,
2106: action_information10
2107: from pay_action_information pai_emp
2108: where pai_emp.action_context_id = p_assignment_action_id
2109: and pai_emp.action_information_category = 'EMPLOYEE DETAILS';
2110: begin
2111: open csr_employee_details;

Line 2140: use_index(pai_comp,pay_action_information_n2)

2136: p_emp_ref VARCHAR2,
2137: p_emp_name VARCHAR2)
2138: is
2139: select /*+ ORDERED use_nl(ppa, paa, pai_comp, pai_person, pai_car)
2140: use_index(pai_comp,pay_action_information_n2)
2141: use_index(pai_person,pay_action_information_n2)
2142: use_index(pai_car,pay_action_information_n2) */
2143: pai_car.action_context_id
2144: from pay_payroll_actions ppa,

Line 2141: use_index(pai_person,pay_action_information_n2)

2137: p_emp_name VARCHAR2)
2138: is
2139: select /*+ ORDERED use_nl(ppa, paa, pai_comp, pai_person, pai_car)
2140: use_index(pai_comp,pay_action_information_n2)
2141: use_index(pai_person,pay_action_information_n2)
2142: use_index(pai_car,pay_action_information_n2) */
2143: pai_car.action_context_id
2144: from pay_payroll_actions ppa,
2145: pay_assignment_actions paa,

Line 2142: use_index(pai_car,pay_action_information_n2) */

2138: is
2139: select /*+ ORDERED use_nl(ppa, paa, pai_comp, pai_person, pai_car)
2140: use_index(pai_comp,pay_action_information_n2)
2141: use_index(pai_person,pay_action_information_n2)
2142: use_index(pai_car,pay_action_information_n2) */
2143: pai_car.action_context_id
2144: from pay_payroll_actions ppa,
2145: pay_assignment_actions paa,
2146: pay_action_information pai_comp,

Line 2146: pay_action_information pai_comp,

2142: use_index(pai_car,pay_action_information_n2) */
2143: pai_car.action_context_id
2144: from pay_payroll_actions ppa,
2145: pay_assignment_actions paa,
2146: pay_action_information pai_comp,
2147: pay_action_information pai_person,
2148: pay_action_information pai_car
2149: where ppa.payroll_action_id = p_pactid
2150: and paa.payroll_action_id = ppa.payroll_action_id

Line 2147: pay_action_information pai_person,

2143: pai_car.action_context_id
2144: from pay_payroll_actions ppa,
2145: pay_assignment_actions paa,
2146: pay_action_information pai_comp,
2147: pay_action_information pai_person,
2148: pay_action_information pai_car
2149: where ppa.payroll_action_id = p_pactid
2150: and paa.payroll_action_id = ppa.payroll_action_id
2151: and pai_comp.action_context_id = paa.assignment_action_id

Line 2148: pay_action_information pai_car

2144: from pay_payroll_actions ppa,
2145: pay_assignment_actions paa,
2146: pay_action_information pai_comp,
2147: pay_action_information pai_person,
2148: pay_action_information pai_car
2149: where ppa.payroll_action_id = p_pactid
2150: and paa.payroll_action_id = ppa.payroll_action_id
2151: and pai_comp.action_context_id = paa.assignment_action_id
2152: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'

Line 2206: from pay_action_information pai_ben

2202: 1,decode(months_between(
2203: fnd_date.canonical_to_date(pai_ben.action_information4)+1,
2204: fnd_date.canonical_to_date(pai_ben.action_information3)),12,null,
2205: to_char(to_number(nvl(pai_ben.action_information15,0)))),null) NUMBER_OF_DAYS
2206: from pay_action_information pai_ben
2207: where pai_ben.action_information_category = 'LIVING ACCOMMODATION'
2208: and pai_ben.action_context_id = p_context_id
2209: and pai_ben.action_context_type = 'AAP';
2210:

Line 2403: use_index(pai_person,pay_action_information_n2)

2399: --
2400: l_select := 'select asg_id
2401: from (select asg_id, rownum as row_num
2402: from (select /*+ ORDERED use_nl(paa,paf,emp,pai_payroll)
2403: use_index(pai_person,pay_action_information_n2)
2404: use_index(pai,pay_action_information_n2) */
2405: paf.person_id, max(paa.assignment_action_id) as asg_id ';
2406: l_from := 'from pay_assignment_actions paa,
2407: per_all_assignments_f paf,

Line 2404: use_index(pai,pay_action_information_n2) */

2400: l_select := 'select asg_id
2401: from (select asg_id, rownum as row_num
2402: from (select /*+ ORDERED use_nl(paa,paf,emp,pai_payroll)
2403: use_index(pai_person,pay_action_information_n2)
2404: use_index(pai,pay_action_information_n2) */
2405: paf.person_id, max(paa.assignment_action_id) as asg_id ';
2406: l_from := 'from pay_assignment_actions paa,
2407: per_all_assignments_f paf,
2408: pay_action_information emp,

Line 2408: pay_action_information emp,

2404: use_index(pai,pay_action_information_n2) */
2405: paf.person_id, max(paa.assignment_action_id) as asg_id ';
2406: l_from := 'from pay_assignment_actions paa,
2407: per_all_assignments_f paf,
2408: pay_action_information emp,
2409: pay_action_information pai_payroll ';
2410: l_where := 'where paa.payroll_action_id = ' || l_payroll_action_id || '
2411: and paa.action_status = ''C''
2412: and paa.assignment_id = paf.assignment_id

Line 2409: pay_action_information pai_payroll ';

2405: paf.person_id, max(paa.assignment_action_id) as asg_id ';
2406: l_from := 'from pay_assignment_actions paa,
2407: per_all_assignments_f paf,
2408: pay_action_information emp,
2409: pay_action_information pai_payroll ';
2410: l_where := 'where paa.payroll_action_id = ' || l_payroll_action_id || '
2411: and paa.action_status = ''C''
2412: and paa.assignment_id = paf.assignment_id
2413: and emp.action_information_category = ''EMPLOYEE DETAILS''

Line 2561: use_index(pai_comp,pay_action_information_n2)

2557: p_emp_name VARCHAR2,
2558: p_category VARCHAR2)
2559: is
2560: select /*+ ORDERED use_nl(ppa, paa, pai_comp, pai_person, pai_car)
2561: use_index(pai_comp,pay_action_information_n2)
2562: use_index(pai_person,pay_action_information_n2)
2563: use_index(pai_car,pay_action_information_n2) */
2564: pai_car.action_context_id
2565: from pay_payroll_actions ppa,

Line 2562: use_index(pai_person,pay_action_information_n2)

2558: p_category VARCHAR2)
2559: is
2560: select /*+ ORDERED use_nl(ppa, paa, pai_comp, pai_person, pai_car)
2561: use_index(pai_comp,pay_action_information_n2)
2562: use_index(pai_person,pay_action_information_n2)
2563: use_index(pai_car,pay_action_information_n2) */
2564: pai_car.action_context_id
2565: from pay_payroll_actions ppa,
2566: pay_assignment_actions paa,

Line 2563: use_index(pai_car,pay_action_information_n2) */

2559: is
2560: select /*+ ORDERED use_nl(ppa, paa, pai_comp, pai_person, pai_car)
2561: use_index(pai_comp,pay_action_information_n2)
2562: use_index(pai_person,pay_action_information_n2)
2563: use_index(pai_car,pay_action_information_n2) */
2564: pai_car.action_context_id
2565: from pay_payroll_actions ppa,
2566: pay_assignment_actions paa,
2567: pay_action_information pai_comp,

Line 2567: pay_action_information pai_comp,

2563: use_index(pai_car,pay_action_information_n2) */
2564: pai_car.action_context_id
2565: from pay_payroll_actions ppa,
2566: pay_assignment_actions paa,
2567: pay_action_information pai_comp,
2568: pay_action_information pai_person,
2569: pay_action_information pai_car
2570: where ppa.payroll_action_id = p_pactid
2571: and paa.payroll_action_id = ppa.payroll_action_id

Line 2568: pay_action_information pai_person,

2564: pai_car.action_context_id
2565: from pay_payroll_actions ppa,
2566: pay_assignment_actions paa,
2567: pay_action_information pai_comp,
2568: pay_action_information pai_person,
2569: pay_action_information pai_car
2570: where ppa.payroll_action_id = p_pactid
2571: and paa.payroll_action_id = ppa.payroll_action_id
2572: and pai_comp.action_context_id = paa.assignment_action_id

Line 2569: pay_action_information pai_car

2565: from pay_payroll_actions ppa,
2566: pay_assignment_actions paa,
2567: pay_action_information pai_comp,
2568: pay_action_information pai_person,
2569: pay_action_information pai_car
2570: where ppa.payroll_action_id = p_pactid
2571: and paa.payroll_action_id = ppa.payroll_action_id
2572: and pai_comp.action_context_id = paa.assignment_action_id
2573: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'

Line 2644: from pay_action_information pai_emp

2640: to_char(to_number(pai_emp.action_information28),'FM999,999,990.00') FUEL_SCALE,
2641: nvl(pai_emp.action_information21,0) ben_charge,
2642: nvl(pai_emp.action_information26,0) stand_disc,
2643: nvl(pai_emp.action_information27,0) additional_disc
2644: from pay_action_information pai_emp
2645: where pai_emp.action_information_category = 'CAR AND CAR FUEL'
2646: and pai_emp.action_context_id = p_context_id
2647: and pai_emp.action_context_type = 'AAP';
2648:

Line 2713: from pay_action_information pai_emp

2709: decode (pai_emp.action_information26,null,to_char(to_number(nvl(pai_emp.action_information20,0))),
2710: to_char(to_number(nvl(pai_emp.action_information20,0) +
2711: nvl(pai_emp.action_information28,0)) ) ) total_days ,
2712: to_char(to_number(nvl(pai_emp.action_information30,0)),'FM999,999,990') fuel_unavailable
2713: from pay_action_information pai_emp
2714: where pai_emp.action_information_category = 'CAR AND CAR FUEL 2003_04'
2715: and pai_emp.action_context_id = p_context_id
2716: and pai_emp.action_context_type = 'AAP';
2717:

Line 2842: from pay_action_information pai_emp

2838: end if;
2839: hr_utility.trace('A4');
2840: select action_information30
2841: into l_car_count
2842: from pay_action_information pai_emp
2843: where pai_emp.action_context_id = p_assignment_action_id
2844: and pai_emp.action_information_category = 'GB P11D ASSIGNMENT RESULTA';
2845:
2846: hr_utility.trace('A5');

Line 3085: from pay_action_information pai_emp

3081: -- hr_utility.trace_on(null,'CAR');
3082: hr_utility.trace('A4');
3083: select action_information30
3084: into l_car_count
3085: from pay_action_information pai_emp
3086: where pai_emp.action_context_id = p_assignment_action_id
3087: and pai_emp.action_information_category = 'GB P11D ASSIGNMENT RESULTA';
3088: hr_utility.trace('A5');
3089: if l_car_count = 1

Line 3289: from pay_action_information pai_emp

3285: -- hr_utility.trace_on(null,'CAR');
3286: hr_utility.trace('A4');
3287: select action_information30
3288: into l_car_count
3289: from pay_action_information pai_emp
3290: where pai_emp.action_context_id = p_assignment_action_id
3291: and pai_emp.action_information_category = 'GB P11D ASSIGNMENT RESULTA';
3292: hr_utility.trace('A5');
3293: if l_car_count = 1

Line 3457: from pay_action_information

3453: nvl(ACTION_INFORMATION12,0) UNAVAILABLE_VAL,
3454: nvl(ACTION_INFORMATION13,0) NUM_SHARE,
3455: nvl(ACTION_INFORMATION14,0) PVT_USE_PAYMENT,
3456: nvl(ACTION_INFORMATION15,0) CASH_EQUIVALENT
3457: from pay_action_information
3458: where action_information_category = 'VANS 2002_03'
3459: and action_context_id in (select paa.assignment_action_id
3460: from pay_action_information pai_comp,
3461: pay_action_information pai_person,

Line 3460: from pay_action_information pai_comp,

3456: nvl(ACTION_INFORMATION15,0) CASH_EQUIVALENT
3457: from pay_action_information
3458: where action_information_category = 'VANS 2002_03'
3459: and action_context_id in (select paa.assignment_action_id
3460: from pay_action_information pai_comp,
3461: pay_action_information pai_person,
3462: pay_assignment_actions paa,
3463: pay_payroll_actions ppa
3464: where ppa.payroll_action_id = p_pactid

Line 3461: pay_action_information pai_person,

3457: from pay_action_information
3458: where action_information_category = 'VANS 2002_03'
3459: and action_context_id in (select paa.assignment_action_id
3460: from pay_action_information pai_comp,
3461: pay_action_information pai_person,
3462: pay_assignment_actions paa,
3463: pay_payroll_actions ppa
3464: where ppa.payroll_action_id = p_pactid
3465: and paa.payroll_action_id = ppa.payroll_action_id

Line 3505: from pay_action_information

3501: nvl(action_information12,0) van_reduce_share, -- K
3502: nvl(action_information14,0) van_private_uses, -- L
3503: nvl(action_information15,0) van_benefit_charge, -- M
3504: action_context_id
3505: from pay_action_information
3506: where action_information_category = 'VANS 2005'
3507: and action_context_type = 'AAP'
3508: and action_context_id in (select paa.assignment_action_id
3509: from pay_action_information pai_comp,

Line 3509: from pay_action_information pai_comp,

3505: from pay_action_information
3506: where action_information_category = 'VANS 2005'
3507: and action_context_type = 'AAP'
3508: and action_context_id in (select paa.assignment_action_id
3509: from pay_action_information pai_comp,
3510: pay_action_information pai_person,
3511: pay_assignment_actions paa,
3512: pay_payroll_actions ppa
3513: where ppa.payroll_action_id = p_pactid

Line 3510: pay_action_information pai_person,

3506: where action_information_category = 'VANS 2005'
3507: and action_context_type = 'AAP'
3508: and action_context_id in (select paa.assignment_action_id
3509: from pay_action_information pai_comp,
3510: pay_action_information pai_person,
3511: pay_assignment_actions paa,
3512: pay_payroll_actions ppa
3513: where ppa.payroll_action_id = p_pactid
3514: and paa.payroll_action_id = ppa.payroll_action_id

Line 3532: from pay_action_information

3528: p_emp_ref Varchar2 ,
3529: p_emp_name Varchar2)
3530: is
3531: select count(*)
3532: from pay_action_information
3533: where action_information_category = 'VANS 2005'
3534: and action_context_type = 'AAP'
3535: and action_context_id in (select paa.assignment_action_id
3536: from pay_action_information pai_comp,

Line 3536: from pay_action_information pai_comp,

3532: from pay_action_information
3533: where action_information_category = 'VANS 2005'
3534: and action_context_type = 'AAP'
3535: and action_context_id in (select paa.assignment_action_id
3536: from pay_action_information pai_comp,
3537: pay_action_information pai_person,
3538: pay_assignment_actions paa,
3539: pay_payroll_actions ppa
3540: where ppa.payroll_action_id = p_pactid

Line 3537: pay_action_information pai_person,

3533: where action_information_category = 'VANS 2005'
3534: and action_context_type = 'AAP'
3535: and action_context_id in (select paa.assignment_action_id
3536: from pay_action_information pai_comp,
3537: pay_action_information pai_person,
3538: pay_assignment_actions paa,
3539: pay_payroll_actions ppa
3540: where ppa.payroll_action_id = p_pactid
3541: and paa.payroll_action_id = ppa.payroll_action_id

Line 3593: from pay_action_information

3589: - nvl(action_information28,0)) van_fuel_charge_reduction, --V
3590: nvl(action_information29,0) van_reduction_sharing, --W
3591: nvl(action_information30,0) van_feul_ben_charge, --X
3592: action_context_id
3593: from pay_action_information
3594: where action_information_category = 'VANS 2007'
3595: and action_context_type = 'AAP'
3596: and action_context_id in (select paa.assignment_action_id
3597: from pay_action_information pai_comp,

Line 3597: from pay_action_information pai_comp,

3593: from pay_action_information
3594: where action_information_category = 'VANS 2007'
3595: and action_context_type = 'AAP'
3596: and action_context_id in (select paa.assignment_action_id
3597: from pay_action_information pai_comp,
3598: pay_action_information pai_person,
3599: pay_assignment_actions paa,
3600: pay_payroll_actions ppa
3601: where ppa.payroll_action_id = p_pactid

Line 3598: pay_action_information pai_person,

3594: where action_information_category = 'VANS 2007'
3595: and action_context_type = 'AAP'
3596: and action_context_id in (select paa.assignment_action_id
3597: from pay_action_information pai_comp,
3598: pay_action_information pai_person,
3599: pay_assignment_actions paa,
3600: pay_payroll_actions ppa
3601: where ppa.payroll_action_id = p_pactid
3602: and paa.payroll_action_id = ppa.payroll_action_id

Line 3621: from pay_action_information

3617: p_emp_ref Varchar2 ,
3618: p_emp_name Varchar2)
3619: is
3620: select count(*)
3621: from pay_action_information
3622: where action_information_category = 'VANS 2007'
3623: and action_context_type = 'AAP'
3624: and action_context_id in (select paa.assignment_action_id
3625: from pay_action_information pai_comp,

Line 3625: from pay_action_information pai_comp,

3621: from pay_action_information
3622: where action_information_category = 'VANS 2007'
3623: and action_context_type = 'AAP'
3624: and action_context_id in (select paa.assignment_action_id
3625: from pay_action_information pai_comp,
3626: pay_action_information pai_person,
3627: pay_assignment_actions paa,
3628: pay_payroll_actions ppa
3629: where ppa.payroll_action_id = p_pactid

Line 3626: pay_action_information pai_person,

3622: where action_information_category = 'VANS 2007'
3623: and action_context_type = 'AAP'
3624: and action_context_id in (select paa.assignment_action_id
3625: from pay_action_information pai_comp,
3626: pay_action_information pai_person,
3627: pay_assignment_actions paa,
3628: pay_payroll_actions ppa
3629: where ppa.payroll_action_id = p_pactid
3630: and paa.payroll_action_id = ppa.payroll_action_id

Line 4052: from pay_action_information

4048: ACTION_INFORMATION11 Cash_Equivalent,
4049: ACTION_INFORMATION19 Annual_Interest_Value,
4050: ACTION_INFORMATION20 Interest_Value,
4051: action_context_id
4052: from pay_action_information
4053: where action_information_category = 'INT FREE AND LOW INT LOANS'
4054: and action_context_type = 'AAP'
4055: and action_context_id in(select paa.assignment_action_id
4056: from pay_action_information pai_comp,

Line 4056: from pay_action_information pai_comp,

4052: from pay_action_information
4053: where action_information_category = 'INT FREE AND LOW INT LOANS'
4054: and action_context_type = 'AAP'
4055: and action_context_id in(select paa.assignment_action_id
4056: from pay_action_information pai_comp,
4057: pay_action_information pai_person,
4058: pay_assignment_actions paa,
4059: pay_payroll_actions ppa
4060: where ppa.payroll_action_id = p_pactid

Line 4057: pay_action_information pai_person,

4053: where action_information_category = 'INT FREE AND LOW INT LOANS'
4054: and action_context_type = 'AAP'
4055: and action_context_id in(select paa.assignment_action_id
4056: from pay_action_information pai_comp,
4057: pay_action_information pai_person,
4058: pay_assignment_actions paa,
4059: pay_payroll_actions ppa
4060: where ppa.payroll_action_id = p_pactid
4061: and paa.payroll_action_id = ppa.payroll_action_id

Line 4116: from pay_action_information pai_emp

4112: l_tab_index := 0;
4113:
4114: select to_number(nvl(ACTION_INFORMATION23,'0'))
4115: into l_h_sum_max_amt_outstanding
4116: from pay_action_information pai_emp
4117: where pai_emp.action_context_id = p_assignment_action_id
4118: and pai_emp.action_information_category = 'GB P11D ASSIGNMENT RESULTC';
4119:
4120: if to_number(l_rep_run) < 2007 then

Line 4238: from pay_action_information pai_ben

4234: to_char(to_number(nvl(pai_ben.action_information14,0)),'FM999,999,990.00') EARLIER_YEARS,
4235: to_char(to_number(nvl(pai_ben.action_information15,0)),'FM999,999,990.00') AMOUNT_EXEMPTED,
4236: to_char(to_number(nvl(pai_ben.action_information5,0)),'FM999,999,990.00') FINAL_AMOUNT,
4237: action_context_id
4238: from pay_action_information pai_ben
4239: where pai_ben.action_information_category = 'RELOCATION EXPENSES'
4240: and pai_ben.action_context_type = 'AAP'
4241: and pai_ben.action_context_id in ( select paa.assignment_action_id
4242: from pay_action_information pai_comp,

Line 4242: from pay_action_information pai_comp,

4238: from pay_action_information pai_ben
4239: where pai_ben.action_information_category = 'RELOCATION EXPENSES'
4240: and pai_ben.action_context_type = 'AAP'
4241: and pai_ben.action_context_id in ( select paa.assignment_action_id
4242: from pay_action_information pai_comp,
4243: pay_action_information pai_person,
4244: pay_assignment_actions paa,
4245: pay_payroll_actions ppa
4246: where ppa.payroll_action_id = p_pactid

Line 4243: pay_action_information pai_person,

4239: where pai_ben.action_information_category = 'RELOCATION EXPENSES'
4240: and pai_ben.action_context_type = 'AAP'
4241: and pai_ben.action_context_id in ( select paa.assignment_action_id
4242: from pay_action_information pai_comp,
4243: pay_action_information pai_person,
4244: pay_assignment_actions paa,
4245: pay_payroll_actions ppa
4246: where ppa.payroll_action_id = p_pactid
4247: and paa.payroll_action_id = ppa.payroll_action_id

Line 4397: from pay_action_information

4393: nvl(ACTION_INFORMATION9,0) b_reimbursement_rate2,
4394: nvl(ACTION_INFORMATION19,0) PASSEN_PAYMENTS,
4395: nvl(ACTION_INFORMATION20,0) PASSEN_BUSINESS_MILES,
4396: nvl(ACTION_INFORMATION21,0) PASSENGER_BUS_MILES_AMOUNT
4397: from pay_action_information
4398: where action_information_category = 'GB P11D ASSIGNMENT RESULTC'
4399: and action_context_type = 'AAP'
4400: and action_context_id = p_assignment_action_id;/*Removed sub query for assignment action id*/
4401:

Line 4744: from pay_action_information

4740: 'OTHER ITEMS NON 1A',ACTION_INFORMATION9,
4741: 'EXPENSES PAYMENTS',ACTION_INFORMATION8) LINE_COL3,
4742: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION3),'DD-MON-YYYY') LINE_START_DATE,
4743: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION4),'DD-MON-YYYY') LINE_END_DATE
4744: from pay_action_information
4745: where action_information_category in(
4746: 'ASSETS TRANSFERRED',
4747: 'PAYMENTS MADE FOR EMP',
4748: 'VOUCHERS OR CREDIT CARDS',

Line 4758: from pay_action_information pai_comp,

4754: 'OTHER ITEMS NON 1A',
4755: 'EXPENSES PAYMENTS')
4756: and action_context_type = 'AAP'
4757: and action_context_id in ( select paa.assignment_action_id
4758: from pay_action_information pai_comp,
4759: pay_action_information pai_person,
4760: pay_assignment_actions paa,
4761: pay_payroll_actions ppa
4762: where ppa.payroll_action_id = p_pactid

Line 4759: pay_action_information pai_person,

4755: 'EXPENSES PAYMENTS')
4756: and action_context_type = 'AAP'
4757: and action_context_id in ( select paa.assignment_action_id
4758: from pay_action_information pai_comp,
4759: pay_action_information pai_person,
4760: pay_assignment_actions paa,
4761: pay_payroll_actions ppa
4762: where ppa.payroll_action_id = p_pactid
4763: and paa.payroll_action_id = ppa.payroll_action_id

Line 4880: from pay_action_information

4876: 'OTHER ITEMS NON 1A',ACTION_INFORMATION9,
4877: 'EXPENSES PAYMENTS',ACTION_INFORMATION8) LINE_COL3,
4878: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION3),'DD-MON-YYYY') LINE_START_DATE,
4879: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION4),'DD-MON-YYYY') LINE_END_DATE
4880: from pay_action_information
4881: where action_information_category in(
4882: 'ASSETS TRANSFERRED',
4883: 'PAYMENTS MADE FOR EMP',
4884: 'VOUCHERS OR CREDIT CARDS',

Line 4893: from pay_action_information pai_comp,

4889: 'OTHER ITEMS NON 1A',
4890: 'EXPENSES PAYMENTS')
4891: and action_context_type = 'AAP'
4892: and action_context_id in ( select paa.assignment_action_id
4893: from pay_action_information pai_comp,
4894: pay_action_information pai_person,
4895: pay_assignment_actions paa,
4896: pay_payroll_actions ppa
4897: where ppa.payroll_action_id = p_pactid

Line 4894: pay_action_information pai_person,

4890: 'EXPENSES PAYMENTS')
4891: and action_context_type = 'AAP'
4892: and action_context_id in ( select paa.assignment_action_id
4893: from pay_action_information pai_comp,
4894: pay_action_information pai_person,
4895: pay_assignment_actions paa,
4896: pay_payroll_actions ppa
4897: where ppa.payroll_action_id = p_pactid
4898: and paa.payroll_action_id = ppa.payroll_action_id

Line 5544: from pay_action_information emp

5540:
5541: cursor csr_person_name
5542: is
5543: select emp.action_information1 emp_name
5544: from pay_action_information emp
5545: where emp.action_information_category = 'EMPLOYEE DETAILS'
5546: and emp.action_context_id = p_assignment_action_id
5547: and emp.action_context_type = 'AAP';
5548:

Line 5558: ,pay_action_information emp -- Employee Details

5554: ,adr.action_information8 adr_town
5555: ,adr.action_information12 adr_county
5556: ,adr.action_information9 adr_code
5557: from pay_assignment_actions paa
5558: ,pay_action_information emp -- Employee Details
5559: ,pay_action_information adr -- Address Details
5560: ,pay_action_information prl -- EMEA Payroll Info
5561: where paa.assignment_action_id = p_assignment_action_id
5562: and emp.action_information_category = 'EMPLOYEE DETAILS'

Line 5559: ,pay_action_information adr -- Address Details

5555: ,adr.action_information12 adr_county
5556: ,adr.action_information9 adr_code
5557: from pay_assignment_actions paa
5558: ,pay_action_information emp -- Employee Details
5559: ,pay_action_information adr -- Address Details
5560: ,pay_action_information prl -- EMEA Payroll Info
5561: where paa.assignment_action_id = p_assignment_action_id
5562: and emp.action_information_category = 'EMPLOYEE DETAILS'
5563: and emp.action_context_id = paa.assignment_action_id

Line 5560: ,pay_action_information prl -- EMEA Payroll Info

5556: ,adr.action_information9 adr_code
5557: from pay_assignment_actions paa
5558: ,pay_action_information emp -- Employee Details
5559: ,pay_action_information adr -- Address Details
5560: ,pay_action_information prl -- EMEA Payroll Info
5561: where paa.assignment_action_id = p_assignment_action_id
5562: and emp.action_information_category = 'EMPLOYEE DETAILS'
5563: and emp.action_context_id = paa.assignment_action_id
5564: and emp.action_context_type = 'AAP'

Line 5587: l_adress1 pay_action_information.action_information5%type;

5583:
5584: l_xfdf_str clob;
5585: l_xfdf_blob_str blob;
5586: l_xfdf_intermetiate_var varchar2(20000);
5587: l_adress1 pay_action_information.action_information5%type;
5588: l_adress2 pay_action_information.action_information6%type;
5589: l_adress3 pay_action_information.action_information7%type;
5590: l_town pay_action_information.action_information8%type;
5591: l_county pay_action_information.action_information12%type;

Line 5588: l_adress2 pay_action_information.action_information6%type;

5584: l_xfdf_str clob;
5585: l_xfdf_blob_str blob;
5586: l_xfdf_intermetiate_var varchar2(20000);
5587: l_adress1 pay_action_information.action_information5%type;
5588: l_adress2 pay_action_information.action_information6%type;
5589: l_adress3 pay_action_information.action_information7%type;
5590: l_town pay_action_information.action_information8%type;
5591: l_county pay_action_information.action_information12%type;
5592: l_employee_name pay_action_information.action_information1%type;

Line 5589: l_adress3 pay_action_information.action_information7%type;

5585: l_xfdf_blob_str blob;
5586: l_xfdf_intermetiate_var varchar2(20000);
5587: l_adress1 pay_action_information.action_information5%type;
5588: l_adress2 pay_action_information.action_information6%type;
5589: l_adress3 pay_action_information.action_information7%type;
5590: l_town pay_action_information.action_information8%type;
5591: l_county pay_action_information.action_information12%type;
5592: l_employee_name pay_action_information.action_information1%type;
5593: l_code pay_action_information.action_information9%type;

Line 5590: l_town pay_action_information.action_information8%type;

5586: l_xfdf_intermetiate_var varchar2(20000);
5587: l_adress1 pay_action_information.action_information5%type;
5588: l_adress2 pay_action_information.action_information6%type;
5589: l_adress3 pay_action_information.action_information7%type;
5590: l_town pay_action_information.action_information8%type;
5591: l_county pay_action_information.action_information12%type;
5592: l_employee_name pay_action_information.action_information1%type;
5593: l_code pay_action_information.action_information9%type;
5594: l_meaning hr_lookups.meaning%type;

Line 5591: l_county pay_action_information.action_information12%type;

5587: l_adress1 pay_action_information.action_information5%type;
5588: l_adress2 pay_action_information.action_information6%type;
5589: l_adress3 pay_action_information.action_information7%type;
5590: l_town pay_action_information.action_information8%type;
5591: l_county pay_action_information.action_information12%type;
5592: l_employee_name pay_action_information.action_information1%type;
5593: l_code pay_action_information.action_information9%type;
5594: l_meaning hr_lookups.meaning%type;
5595: begin

Line 5592: l_employee_name pay_action_information.action_information1%type;

5588: l_adress2 pay_action_information.action_information6%type;
5589: l_adress3 pay_action_information.action_information7%type;
5590: l_town pay_action_information.action_information8%type;
5591: l_county pay_action_information.action_information12%type;
5592: l_employee_name pay_action_information.action_information1%type;
5593: l_code pay_action_information.action_information9%type;
5594: l_meaning hr_lookups.meaning%type;
5595: begin
5596: dbms_lob.createtemporary(l_xfdf_str,false,DBMS_LOB.CALL);

Line 5593: l_code pay_action_information.action_information9%type;

5589: l_adress3 pay_action_information.action_information7%type;
5590: l_town pay_action_information.action_information8%type;
5591: l_county pay_action_information.action_information12%type;
5592: l_employee_name pay_action_information.action_information1%type;
5593: l_code pay_action_information.action_information9%type;
5594: l_meaning hr_lookups.meaning%type;
5595: begin
5596: dbms_lob.createtemporary(l_xfdf_str,false,DBMS_LOB.CALL);
5597: dbms_lob.open(l_xfdf_str,dbms_lob.lob_readwrite);

Line 5651: pay_action_information pai_comp

5647: -- In case if only secondary have benefits then we may write
5648: -- any secondary assignment number in the magtape
5649: FROM per_assignments_f paf,
5650: pay_assignment_actions paa,
5651: pay_action_information pai_comp
5652: WHERE paf.person_id = p_person_id
5653: AND paa.assignment_id = paf.assignment_id
5654: AND paa.payroll_action_id = p_arch_payroll_action_id
5655: AND pai_comp.action_context_id = paa.assignment_action_id

Line 5667: pay_action_information pai_comp,

5663: SELECT /*+ ordered */
5664: SUM (TO_NUMBER (NVL (pai.action_information7, '0')))
5665: FROM per_assignments_f paf,
5666: pay_assignment_actions paa,
5667: pay_action_information pai_comp,
5668: pay_action_information pai
5669: WHERE paf.person_id = p_person_id
5670: AND paa.payroll_action_id = p_arch_payroll_action_id
5671: AND paa.assignment_id = paf.assignment_id

Line 5668: pay_action_information pai

5664: SUM (TO_NUMBER (NVL (pai.action_information7, '0')))
5665: FROM per_assignments_f paf,
5666: pay_assignment_actions paa,
5667: pay_action_information pai_comp,
5668: pay_action_information pai
5669: WHERE paf.person_id = p_person_id
5670: AND paa.payroll_action_id = p_arch_payroll_action_id
5671: AND paa.assignment_id = paf.assignment_id
5672: AND pai_comp.action_context_id = paa.assignment_action_id

Line 5683: FROM pay_action_information pai

5679: CURSOR fetch_ben_values (p_assignment_action_id NUMBER,
5680: p_action_info_catg VARCHAR2)
5681: IS
5682: SELECT *
5683: FROM pay_action_information pai
5684: WHERE pai.action_context_id = p_assignment_action_id
5685: AND pai.action_information_category = p_action_info_catg;
5686:
5687: l_ce_values_a fetch_ben_values%ROWTYPE;