[Home] [Help]
134:
135: cursor csr_p45_3_header is
136: select 'SENDER_ID=P', nvl(hoi.org_information11,' '),
137: 'RECEIVER_ID=P', 'INLAND REVENUE',
138: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
139: 'URGENT_MARKER=P', decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
140: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
141: 'FORM_TYPE=P', '5',
142: 'FORM_TYPE_MEANING=P', 'P45_3',
135: cursor csr_p45_3_header is
136: select 'SENDER_ID=P', nvl(hoi.org_information11,' '),
137: 'RECEIVER_ID=P', 'INLAND REVENUE',
138: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
139: 'URGENT_MARKER=P', decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
140: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
141: 'FORM_TYPE=P', '5',
142: 'FORM_TYPE_MEANING=P', 'P45_3',
143: 'TAX_DIST_NO=P', nvl(substr(hoi.org_information1,1,3),' '),
146: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
147: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' ')
148: from pay_payroll_actions pact,
149: hr_organization_information hoi
150: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
151: and pact.business_group_id = hoi.organization_id
152: and hoi.org_information_context = 'Tax Details References'
153: and nvl(hoi.org_information10,'UK') = 'UK'
154: and substr(pact.legislative_parameters, instr(pact.legislative_parameters, 'TAX_REF=') + 8,
193: pay_assignment_actions paa,
194: pay_action_information addr,
195: pay_action_information peo,
196: pay_action_information p453
197: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
198: and pay.payroll_action_id = paa.payroll_action_id
199: and paa.assignment_action_id = peo.action_context_id
200: and peo.action_information_category = 'GB EMPLOYEE DETAILS'
201: and peo.action_context_type = 'AAP'
209: --
210: cursor csr_p46_header is
211: select 'SENDER_ID=P', nvl(hoi.org_information11,' '),
212: 'RECEIVER_ID=P', 'INLAND REVENUE',
213: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
214: 'URGENT_MARKER=P', decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
215: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
216: 'FORM_TYPE=P', '7',
217: 'FORM_TYPE_MEANING=P', 'P46',
210: cursor csr_p46_header is
211: select 'SENDER_ID=P', nvl(hoi.org_information11,' '),
212: 'RECEIVER_ID=P', 'INLAND REVENUE',
213: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
214: 'URGENT_MARKER=P', decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
215: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
216: 'FORM_TYPE=P', '7',
217: 'FORM_TYPE_MEANING=P', 'P46',
218: 'TAX_DIST_NO=P', nvl(substr(hoi.org_information1,1,3),' '),
221: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
222: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' ')
223: from pay_payroll_actions pact,
224: hr_organization_information hoi
225: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
226: and pact.business_group_id = hoi.organization_id
227: and hoi.org_information_context = 'Tax Details References'
228: and nvl(hoi.org_information10,'UK') = 'UK'
229: and substr(pact.legislative_parameters,instr(pact.legislative_parameters,'TAX_REF=') + 8,
257: pay_assignment_actions paa,
258: pay_action_information addr,
259: pay_action_information peo,
260: pay_action_information p46
261: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
262: and pay.payroll_action_id = paa.payroll_action_id
263: and paa.assignment_action_id = peo.action_context_id
264: and peo.action_information_category = 'GB EMPLOYEE DETAILS'
265: and peo.action_context_type = 'AAP'
273: --
274: cursor csr_p46_pennot_header is
275: select 'SENDER_ID=P', hoi.org_information11,
276: 'RECEIVER_ID=P', 'INLAND REVENUE',
277: 'TEST_INDICATOR=P',decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
278: 'URGENT_MARKER=P', decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
279: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
280: 'FORM_TYPE=P', '6',
281: 'FORM_TYPE_MEANING=P', 'P46_PENNOT',
274: cursor csr_p46_pennot_header is
275: select 'SENDER_ID=P', hoi.org_information11,
276: 'RECEIVER_ID=P', 'INLAND REVENUE',
277: 'TEST_INDICATOR=P',decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
278: 'URGENT_MARKER=P', decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
279: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
280: 'FORM_TYPE=P', '6',
281: 'FORM_TYPE_MEANING=P', 'P46_PENNOT',
282: 'TAX_DIST_NO=P', substr(hoi.org_information1,1,3),
285: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
286: 'EMPLOYERS_NAME=P',nvl(upper(hoi.org_information3),' ')
287: from pay_payroll_actions pact,
288: hr_organization_information hoi
289: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
290: and pact.business_group_id = hoi.organization_id
291: and hoi.org_information_context = 'Tax Details References'
292: and nvl(hoi.org_information10,'UK') = 'UK'
293: and substr(pact.legislative_parameters, instr(pact.legislative_parameters,'TAX_REF=') + 8,
320: pay_assignment_actions paa,
321: pay_action_information addr,
322: pay_action_information peo,
323: pay_action_information p46p
324: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
325: and pay.payroll_action_id = paa.payroll_action_id
326: and paa.assignment_action_id = peo.action_context_id
327: and peo.action_information_category = 'GB EMPLOYEE DETAILS'
328: and peo.action_context_type = 'AAP'
337: -- Bug 5398360
338: cursor csr_wnu3_header is
339: select 'SENDER_ID=P', nvl(hoi.org_information11,' '),
340: 'RECEIVER_ID=P', 'INLAND REVENUE',
341: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
342: 'URGENT_MARKER=P', ' ', -- as a space is required in this place
343: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
344: 'FORM_TYPE=P', '18',
345: 'FORM_TYPE_MEANING=P', 'WNU',
349: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
350: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' ')
351: from pay_payroll_actions pact,
352: hr_organization_information hoi
353: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
354: and pact.business_group_id = hoi.organization_id
355: and hoi.org_information_context = 'Tax Details References'
356: and nvl(hoi.org_information10,'UK') = 'UK'
357: and substr(pact.legislative_parameters,instr(pact.legislative_parameters,'TAX_REF=') + 8,
382: 'OLD_ASSIGNMENT_NUMBER=P',nvl(upper(wnu3.action_information2), ' ') -- for PAY_GB_EDI_WNU_3
383: from pay_assignment_actions paa,
384: pay_action_information peo,
385: pay_action_information wnu3
386: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
387: and paa.assignment_action_id = peo.action_context_id
388: and peo.action_information_category = 'GB EMPLOYEE DETAILS'
389: and peo.action_context_type = 'AAP'
390: and paa.assignment_action_id = wnu3.action_context_id(+)
395: /* changes for P45PT_3 start*/
396: cursor csr_p45pt_3_header is
397: select 'SENDER_ID=P', nvl(hoi.org_information11,' '),
398: 'RECEIVER_ID=P', 'HMRC', /* changed for P45PT_3*/
399: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
400: 'URGENT_MARKER=P', ' ',
401: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
402: 'FORM_TYPE=P', '5',
403: 'FORM_TYPE_MEANING=P', 'P45PT3', /* changed for P45PT_3*/
405: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),
406: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
407: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
408: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
409: 'TEST_ID=P', nvl(pay_magtape_generic.get_parameter_value('TEST_ID'),' ') /*added for P45PT_3*/
410: from pay_payroll_actions pact,
411: hr_organization_information hoi
412: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
413: and pact.business_group_id = hoi.organization_id
408: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
409: 'TEST_ID=P', nvl(pay_magtape_generic.get_parameter_value('TEST_ID'),' ') /*added for P45PT_3*/
410: from pay_payroll_actions pact,
411: hr_organization_information hoi
412: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
413: and pact.business_group_id = hoi.organization_id
414: and hoi.org_information_context = 'Tax Details References'
415: and nvl(hoi.org_information10,'UK') = 'UK'
416: and substr(pact.legislative_parameters, instr(pact.legislative_parameters, 'TAX_REF=') + 8,
468: pay_assignment_actions paa,
469: pay_action_information addr,
470: pay_action_information peo,
471: pay_action_information p453
472: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
473: and pay.payroll_action_id = paa.payroll_action_id
474: and paa.assignment_action_id = peo.action_context_id
475: and peo.action_information_category = 'GB EMPLOYEE DETAILS'
476: and peo.action_context_type = 'AAP'
486:
487: cursor csr_p45pt_3_ver6_header is
488: select 'SENDER_ID=P', nvl(UPPER(hoi.org_information11),' '), -- Bug 8329474
489: 'RECEIVER_ID=P', 'HMRC', /* changed for P45PT_3*/
490: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
491: 'URGENT_MARKER=P', ' ',
492: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
493: 'FORM_TYPE=P', '5',
494: 'FORM_TYPE_MEANING=P', 'P45PT_3_VER6', /* changed for P45PT_3*/
496: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),
497: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
498: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
499: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
500: 'TEST_ID=P', nvl(pay_magtape_generic.get_parameter_value('TEST_ID'),' ') /*added for P45PT_3*/
501: from pay_payroll_actions pact,
502: hr_organization_information hoi
503: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
504: and pact.business_group_id = hoi.organization_id
499: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
500: 'TEST_ID=P', nvl(pay_magtape_generic.get_parameter_value('TEST_ID'),' ') /*added for P45PT_3*/
501: from pay_payroll_actions pact,
502: hr_organization_information hoi
503: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
504: and pact.business_group_id = hoi.organization_id
505: and hoi.org_information_context = 'Tax Details References'
506: and nvl(hoi.org_information10,'UK') = 'UK'
507: and substr(pact.legislative_parameters, instr(pact.legislative_parameters, 'TAX_REF=') + 8,
558: pay_assignment_actions paa,
559: pay_action_information addr,
560: pay_action_information peo,
561: pay_action_information p453
562: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
563: and pay.payroll_action_id = paa.payroll_action_id
564: and paa.assignment_action_id = peo.action_context_id
565: and peo.action_information_category = 'GB EMPLOYEE DETAILS'
566: and peo.action_context_type = 'AAP'
577: /******* start *******/
578: cursor csr_p46_5_pennot_header is
579: select 'SENDER_ID=P', hoi.org_information11,
580: 'RECEIVER_ID=P', 'HMRC',
581: 'TEST_INDICATOR=P',decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
582: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID'),
583: 'URGENT_MARKER=P', ' ',
584: 'TRANSMISSION_DATE=P', to_char(sysdate,'CCYYMMDD'),
585: 'TRANSMISSION_TIME=P', to_char(sysdate,'HHMMSS'),
578: cursor csr_p46_5_pennot_header is
579: select 'SENDER_ID=P', hoi.org_information11,
580: 'RECEIVER_ID=P', 'HMRC',
581: 'TEST_INDICATOR=P',decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
582: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID'),
583: 'URGENT_MARKER=P', ' ',
584: 'TRANSMISSION_DATE=P', to_char(sysdate,'CCYYMMDD'),
585: 'TRANSMISSION_TIME=P', to_char(sysdate,'HHMMSS'),
586: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
595: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
596: 'EMPLOYERS_NAME=P',nvl(upper(hoi.org_information3),' ')
597: from pay_payroll_actions pact,
598: hr_organization_information hoi
599: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
600: and pact.business_group_id = hoi.organization_id
601: and hoi.org_information_context = 'Tax Details References'
602: and nvl(hoi.org_information10,'UK') = 'UK'
603: and substr(pact.legislative_parameters, instr(pact.legislative_parameters,'TAX_REF=') + 8,
648: pay_assignment_actions paa,
649: pay_action_information addr,
650: pay_action_information peo,
651: pay_action_information p46p
652: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
653: and pay.payroll_action_id = paa.payroll_action_id
654: and paa.assignment_action_id = peo.action_context_id
655: and peo.action_information_category = 'GB EMPLOYEE DETAILS'
656: and peo.action_context_type = 'AAP'
665: /***** Year end changes for P46 PENNOT Version 6 Start********/
666: cursor csr_p46_ver6_pennot_header is
667: select 'SENDER_ID=P', UPPER(hoi.org_information11),
668: 'RECEIVER_ID=P', 'HMRC',
669: 'TEST_INDICATOR=P',decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
670: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID'),
671: 'URGENT_MARKER=P', ' ',
672: 'TRANSMISSION_DATE=P', to_char(sysdate,'CCYYMMDD'),
673: 'TRANSMISSION_TIME=P', to_char(sysdate,'HHMMSS'),
666: cursor csr_p46_ver6_pennot_header is
667: select 'SENDER_ID=P', UPPER(hoi.org_information11),
668: 'RECEIVER_ID=P', 'HMRC',
669: 'TEST_INDICATOR=P',decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
670: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID'),
671: 'URGENT_MARKER=P', ' ',
672: 'TRANSMISSION_DATE=P', to_char(sysdate,'CCYYMMDD'),
673: 'TRANSMISSION_TIME=P', to_char(sysdate,'HHMMSS'),
674: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
683: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
684: 'EMPLOYERS_NAME=P',nvl(upper(hoi.org_information3),' ')
685: from pay_payroll_actions pact,
686: hr_organization_information hoi
687: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
688: and pact.business_group_id = hoi.organization_id
689: and hoi.org_information_context = 'Tax Details References'
690: and nvl(hoi.org_information10,'UK') = 'UK'
691: and substr(pact.legislative_parameters, instr(pact.legislative_parameters,'TAX_REF=') + 8,
738: pay_assignment_actions paa,
739: pay_action_information addr,
740: pay_action_information peo,
741: pay_action_information p46p
742: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
743: and pay.payroll_action_id = paa.payroll_action_id
744: and paa.assignment_action_id = peo.action_context_id
745: and peo.action_information_category = 'GB EMPLOYEE DETAILS'
746: and peo.action_context_type = 'AAP'
755: ---
756: cursor csr_p46_5_header is
757: select 'SENDER_ID=P', nvl(UPPER(hoi.org_information11),' '),
758: 'RECEIVER_ID=P', 'HMRC',
759: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
760: 'URGENT_MARKER=P', ' ',--decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
761: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
762: 'FORM_TYPE=P', '7',
763: 'FORM_TYPE_MEANING=P', 'P46_5',
756: cursor csr_p46_5_header is
757: select 'SENDER_ID=P', nvl(UPPER(hoi.org_information11),' '),
758: 'RECEIVER_ID=P', 'HMRC',
759: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
760: 'URGENT_MARKER=P', ' ',--decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
761: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
762: 'FORM_TYPE=P', '7',
763: 'FORM_TYPE_MEANING=P', 'P46_5',
764: 'TAX_DIST_NO=P', nvl(substr(hoi.org_information1,1,3),' '),
765: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),
766: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
767: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
768: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
769: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID')
770: from pay_payroll_actions pact,
771: hr_organization_information hoi
772: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
773: and pact.business_group_id = hoi.organization_id
768: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
769: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID')
770: from pay_payroll_actions pact,
771: hr_organization_information hoi
772: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
773: and pact.business_group_id = hoi.organization_id
774: and hoi.org_information_context = 'Tax Details References'
775: and nvl(hoi.org_information10,'UK') = 'UK'
776: and substr(pact.legislative_parameters,instr(pact.legislative_parameters,'TAX_REF=') + 8,
808: pay_assignment_actions paa,
809: pay_action_information addr,
810: pay_action_information peo,
811: pay_action_information p46
812: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
813: and pay.payroll_action_id = paa.payroll_action_id
814: and paa.assignment_action_id = peo.action_context_id
815: and peo.action_information_category = 'GB EMPLOYEE DETAILS'
816: and peo.action_context_type = 'AAP'
826: /*P46 Version6 EOY Changes Start*/
827: cursor csr_p46_ver6_header is
828: select 'SENDER_ID=P', nvl(UPPER(hoi.org_information11),' '),
829: 'RECEIVER_ID=P', 'HMRC',
830: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
831: 'URGENT_MARKER=P', ' ',--decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
832: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
833: 'FORM_TYPE=P', '7',
834: 'FORM_TYPE_MEANING=P', 'P46_VER6',
827: cursor csr_p46_ver6_header is
828: select 'SENDER_ID=P', nvl(UPPER(hoi.org_information11),' '),
829: 'RECEIVER_ID=P', 'HMRC',
830: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
831: 'URGENT_MARKER=P', ' ',--decode(pay_magtape_generic.get_parameter_value('URGENT'),'N',' ','Y','1'),
832: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
833: 'FORM_TYPE=P', '7',
834: 'FORM_TYPE_MEANING=P', 'P46_VER6',
835: 'TAX_DIST_NO=P', nvl(substr(hoi.org_information1,1,3),' '),
836: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),
837: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
838: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
839: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
840: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID')
841: from pay_payroll_actions pact,
842: hr_organization_information hoi
843: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
844: and pact.business_group_id = hoi.organization_id
839: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
840: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID')
841: from pay_payroll_actions pact,
842: hr_organization_information hoi
843: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
844: and pact.business_group_id = hoi.organization_id
845: and hoi.org_information_context = 'Tax Details References'
846: and nvl(hoi.org_information10,'UK') = 'UK'
847: and substr(pact.legislative_parameters,instr(pact.legislative_parameters,'TAX_REF=') + 8,
879: pay_assignment_actions paa,
880: pay_action_information addr,
881: pay_action_information peo,
882: pay_action_information p46
883: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
884: and pay.payroll_action_id = paa.payroll_action_id
885: and paa.assignment_action_id = peo.action_context_id
886: and peo.action_information_category = 'GB EMPLOYEE DETAILS'
887: and peo.action_context_type = 'AAP'
898: /*Changes for P46EXP_Ver6 starts*/
899: cursor csr_p46exp_ver6_header is
900: select 'SENDER_ID=P', nvl(UPPER(hoi.org_information11),' '),
901: 'RECEIVER_ID=P', 'HMRC',
902: 'TEST_INDICATOR=P', decode(pay_magtape_generic.get_parameter_value('TEST'),'N',' ','Y','1'),
903: 'URGENT_MARKER=P', ' ',
904: 'REQUEST_ID=P', fnd_number.number_to_canonical(pact.request_id),
905: 'FORM_TYPE=P', '23',
906: 'FORM_TYPE_MEANING=P', 'P46EXP_VER6',
908: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),
909: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
910: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
911: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
912: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID')
913: from pay_payroll_actions pact,
914: hr_organization_information hoi
915: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
916: and pact.business_group_id = hoi.organization_id
911: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
912: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID')
913: from pay_payroll_actions pact,
914: hr_organization_information hoi
915: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
916: and pact.business_group_id = hoi.organization_id
917: and hoi.org_information_context = 'Tax Details References'
918: and nvl(hoi.org_information10,'UK') = 'UK'
919: and substr(pact.legislative_parameters,instr(pact.legislative_parameters,'TAX_REF=') + 8,
953: pay_assignment_actions paa,
954: pay_action_information addr,
955: pay_action_information peo,
956: pay_action_information p46
957: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
958: and pay.payroll_action_id = paa.payroll_action_id
959: and paa.assignment_action_id = peo.action_context_id
960: and peo.action_information_category = 'GB EMPLOYEE DETAILS'
961: and peo.action_context_type = 'AAP'