[Home] [Help]
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
329: and pai_comp.action_context_id = paa.assignment_action_id
604: l_asg_no varchar2(25);
605:
606: cursor asg_id is
607: select assignment_id
608: from pay_assignment_actions
609: where assignment_action_id = p_action_id;
610:
611: cursor asg_low is
612: select min(paa2.assignment_id)
609: where assignment_action_id = p_action_id;
610:
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
610:
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
727: l_p11d_fields.employee_number := get_assignment_number(p_assignment_action_id, true, g_person_id, g_emp_ref_no);
728:
729: select payroll_action_id
730: into l_pactid
731: from pay_assignment_actions
732: where assignment_action_id = p_assignment_action_id;
733:
734: PAY_GB_P11D_ARCHIVE_SS.get_parameters(p_payroll_action_id => l_pactid,
735: p_token_name => 'Rep_Run',
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
990: and pai_comp.action_context_id = paa.assignment_action_id
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
1157: and pai_comp.action_context_id = paa.assignment_action_id
1230: begin
1231: hr_utility.trace('Inside fetch p11d rep_data p_assignment_action_id' || p_assignment_action_id);
1232: select payroll_action_id
1233: into g_payroll_action_id
1234: from pay_assignment_actions
1235: where assignment_action_id = p_assignment_action_id;
1236:
1237: hr_utility.trace('g_payroll_action_id ' || g_payroll_action_id);
1238: populate_stored_fields;
1261: l_p11d_fields := fetch_p11d_rep_data(p_assignment_action_id);
1262:
1263: select payroll_action_id
1264: into l_pactid
1265: from pay_assignment_actions
1266: where assignment_action_id = p_assignment_action_id;
1267:
1268: PAY_GB_P11D_ARCHIVE_SS.get_parameters(p_payroll_action_id => l_pactid,
1269: p_token_name => 'Rep_Run',
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
1961: where pai.action_context_id = paa.assignment_action_id
1962: and pai.action_context_type = 'AAP'
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,
1979: pay_action_information pai_person
1980: where paa.assignment_action_id = c_asg_act_id
2003: and pai_comp.action_information_category = 'EMEA PAYROLL INFO';
2004:
2005: cursor get_pactid is
2006: select payroll_action_id
2007: from pay_assignment_actions
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
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
2045: and paa.assignment_action_id <> c_asg_act_id
2500: is
2501: cursor csr_pactid
2502: is
2503: select payroll_action_id
2504: from pay_assignment_actions
2505: where assignment_action_id = p_assignment_action_id;
2506: l_pactid number;
2507: begin
2508: open csr_pactid ;
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,
2621: pay_action_information pai_person,
2622: pay_action_information pai_car
2623: where ppa.payroll_action_id = p_pactid
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,
2895: pay_action_information pai_payroll ';
2896: l_where := 'where paa.payroll_action_id = ' || l_payroll_action_id || '
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,
3054: pay_action_information pai_person,
3055: pay_action_information pai_car
3056: where ppa.payroll_action_id = p_pactid
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
4123: and pai_comp.action_context_id = paa.assignment_action_id
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
4172: and pai_comp.action_context_id = paa.assignment_action_id
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
4199: and pai_comp.action_context_id = paa.assignment_action_id
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
4260: and pai_comp.action_context_id = paa.assignment_action_id
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
4288: and pai_comp.action_context_id = paa.assignment_action_id
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
4731: and pai_comp.action_context_id = paa.assignment_action_id
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
4929: and pai_comp.action_context_id = paa.assignment_action_id
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,
5110: pay_action_information pai_person
5111: where paa.assignment_action_id = p_assignment_action_id
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
5135: and pai.action_context_id = paa.assignment_action_id
5407: is
5408: cursor csr_pactid
5409: is
5410: select count(1)
5411: from pay_assignment_actions
5412: where payroll_action_id = p_payroll_action_id
5413: and action_status='C';
5414:
5415: l_pactid number;
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
5545: and pai_comp.action_context_id = paa.assignment_action_id
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
5680: and pai_comp.action_context_id = paa.assignment_action_id
6350: region_1
6351: from per_addresses
6352: where person_id = (
6353: select distinct person_id
6354: from pay_assignment_actions paa,
6355: per_all_assignments_f paf
6356: where paa.assignment_action_id = p_assignment_action_id
6357: and paf.assignment_id = paa.assignment_id)
6358: and primary_flag = 'Y'
6373: ,adr.action_information7 adr_adress3
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
6524: -- magtape if the primary and sec both have the p11d benefits
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
6540: IS
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