[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
596: l_asg_no varchar2(25);
597:
598: cursor asg_id is
599: select assignment_id
600: from pay_assignment_actions
601: where assignment_action_id = p_action_id;
602:
603: cursor asg_low is
604: select min(paa2.assignment_id)
601: where assignment_action_id = p_action_id;
602:
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
602:
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
719: l_p11d_fields.employee_number := get_assignment_number(p_assignment_action_id, true, g_person_id, g_emp_ref_no);
720:
721: select payroll_action_id
722: into l_pactid
723: from pay_assignment_actions
724: where assignment_action_id = p_assignment_action_id;
725:
726: PAY_GB_P11D_ARCHIVE_SS.get_parameters(p_payroll_action_id => l_pactid,
727: p_token_name => 'Rep_Run',
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
981: and pai_comp.action_context_id = paa.assignment_action_id
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
1136: and pai_comp.action_context_id = paa.assignment_action_id
1209: begin
1210: hr_utility.trace('Inside fetch p11d rep_data p_assignment_action_id' || p_assignment_action_id);
1211: select payroll_action_id
1212: into g_payroll_action_id
1213: from pay_assignment_actions
1214: where assignment_action_id = p_assignment_action_id;
1215:
1216: hr_utility.trace('g_payroll_action_id ' || g_payroll_action_id);
1217: populate_stored_fields;
1235: l_p11d_fields := fetch_p11d_rep_data(p_assignment_action_id);
1236:
1237: select payroll_action_id
1238: into l_pactid
1239: from pay_assignment_actions
1240: where assignment_action_id = p_assignment_action_id;
1241:
1242: PAY_GB_P11D_ARCHIVE_SS.get_parameters(p_payroll_action_id => l_pactid,
1243: p_token_name => 'Rep_Run',
2048: is
2049: cursor csr_pactid
2050: is
2051: select payroll_action_id
2052: from pay_assignment_actions
2053: where assignment_action_id = p_assignment_action_id;
2054: l_pactid number;
2055: begin
2056: open csr_pactid ;
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,
2147: pay_action_information pai_person,
2148: pay_action_information pai_car
2149: where ppa.payroll_action_id = p_pactid
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,
2409: pay_action_information pai_payroll ';
2410: l_where := 'where paa.payroll_action_id = ' || l_payroll_action_id || '
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,
2568: pay_action_information pai_person,
2569: pay_action_information pai_car
2570: where ppa.payroll_action_id = p_pactid
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
3466: and pai_comp.action_context_id = paa.assignment_action_id
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
3515: and pai_comp.action_context_id = paa.assignment_action_id
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
3542: and pai_comp.action_context_id = paa.assignment_action_id
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
3603: and pai_comp.action_context_id = paa.assignment_action_id
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
3631: and pai_comp.action_context_id = paa.assignment_action_id
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
4062: and pai_comp.action_context_id = paa.assignment_action_id
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
4248: and pai_comp.action_context_id = paa.assignment_action_id
4628: is
4629: cursor csr_pactid
4630: is
4631: select count(1)
4632: from pay_assignment_actions
4633: where payroll_action_id = p_payroll_action_id
4634: and action_status='C';
4635:
4636: l_pactid number;
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
4764: and pai_comp.action_context_id = paa.assignment_action_id
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
4899: and pai_comp.action_context_id = paa.assignment_action_id
5530: region_1
5531: from per_addresses
5532: where person_id = (
5533: select distinct person_id
5534: from pay_assignment_actions paa,
5535: per_all_assignments_f paf
5536: where paa.assignment_action_id = p_assignment_action_id
5537: and paf.assignment_id = paa.assignment_id)
5538: and primary_flag = 'Y'
5553: ,adr.action_information7 adr_adress3
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
5646: -- magtape if the primary and sec both have the p11d benefits
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
5662: IS
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