[Home] [Help]
45: aac.assignment_action_id,
46: 'APPLICATION_REFERENCE=P',
47: 'IR8A' application_reference,
48: 'BASIS_YEAR=P',
49: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
50: 'CREATION_DATE=P',
51: to_char(sysdate,'YYYYMMDD') creation_date
52: from pay_payroll_actions mpa,
53: pay_payroll_actions apa,
54: pay_assignment_actions aac,
55: ff_archive_items ffi,
56: ff_database_items fdi
57: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
58: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
59: and apa.payroll_action_id = aac.payroll_action_id
60: and apa.action_status = 'C'
61: and ffi.context1 = aac.assignment_action_id /* Added joins for bug:3232300 */
62: and fdi.user_name = 'X_SG_LEGAL_ENTITY_SG_LEGAL_ENTITY_NAME'
69: aac.assignment_action_id,
70: 'APPLICATION_REFERENCE=P',
71: 'IR8S' application_reference,
72: 'BASIS_YEAR=P',
73: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
74: 'CREATION_DATE=P',
75: to_char(sysdate,'YYYYMMDD') creation_date
76: from pay_payroll_actions mpa,
77: pay_payroll_actions apa,
78: pay_assignment_actions aac
79: ,ff_archive_items ffi
80: ,ff_database_items fdi
81: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
82: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
83: and apa.payroll_action_id = aac.payroll_action_id
84: and apa.action_status = 'C'
85: and ffi.context1 = aac.assignment_action_id /* Added joins for bug:3232300 */
86: and fdi.user_name = 'X_SG_LEGAL_ENTITY_SG_LEGAL_ENTITY_NAME'
93: aac.assignment_action_id,
94: 'APPLICATION_REFERENCE=P',
95: 'IRA8A' application_reference,
96: 'BASIS_YEAR=P',
97: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
98: 'CREATION_DATE=P',
99: to_char(sysdate,'YYYYMMDD') creation_date
100: from pay_payroll_actions mpa,
101: pay_payroll_actions apa,
102: pay_assignment_actions aac,
103: ff_archive_items ffi,
104: ff_database_items fdi
105: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
106: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
107: and apa.payroll_action_id = aac.payroll_action_id
108: and apa.action_status = 'C'
109: and ffi.context1 = aac.assignment_action_id /* Added joins for bug:3232300 */
110: and fdi.user_name = 'X_SG_LEGAL_ENTITY_SG_LEGAL_ENTITY_NAME'
117: aac.assignment_action_id,
118: 'APPLICATION_REFERENCE=P',
119: 'IRA8B' application_reference,
120: 'BASIS_YEAR=P',
121: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
122: 'CREATION_DATE=P',
123: to_char(sysdate,'YYYYMMDD') creation_date
124: from pay_payroll_actions mpa,
125: pay_payroll_actions apa,
126: pay_assignment_actions aac,
127: ff_archive_items ffi,
128: ff_database_items fdi
129: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
130: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
131: and apa.payroll_action_id = aac.payroll_action_id
132: and apa.action_status = 'C'
133: and ffi.context1 = aac.assignment_action_id /* Added joins for bug:3232300 */
134: and fdi.user_name = 'X_SG_LEGAL_ENTITY_SG_LEGAL_ENTITY_NAME'
148: select distinct
149: 'ASSIGNMENT_ACTION_ID=C',
150: aac.assignment_action_id,
151: 'TAX_UNIT_ID=C',
152: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', apa.legislative_parameters) tax_unit_id,
153: 'BASIS_YEAR=P',
154: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
155: 'P_ASSIGNMENT_ACTION_ID=P',
156: to_char(mac.assignment_action_id),
150: aac.assignment_action_id,
151: 'TAX_UNIT_ID=C',
152: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', apa.legislative_parameters) tax_unit_id,
153: 'BASIS_YEAR=P',
154: pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters) basis_year,
155: 'P_ASSIGNMENT_ACTION_ID=P',
156: to_char(mac.assignment_action_id),
157: 'ASSIGNMENT_ID=P',
158: to_char(paa.assignment_id) assignment_id,
168: pay_payroll_actions apa,
169: pay_assignment_actions aac
170: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
171: and mpa.payroll_action_id = mac.payroll_action_id
172: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
173: and apa.payroll_action_id = aac.payroll_action_id
174: and paa.assignment_id = aac.assignment_id
175: and apa.action_status = 'C'
176: and aac.action_status = 'C'
173: and apa.payroll_action_id = aac.payroll_action_id
174: and paa.assignment_id = aac.assignment_id
175: and apa.action_status = 'C'
176: and aac.action_status = 'C'
177: and (paa.effective_start_date <= to_date('31/' || '12/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy')
178: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
179: and paa.assignment_id = mac.assignment_id
180: order by paa.person_id;
181:
174: and paa.assignment_id = aac.assignment_id
175: and apa.action_status = 'C'
176: and aac.action_status = 'C'
177: and (paa.effective_start_date <= to_date('31/' || '12/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy')
178: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
179: and paa.assignment_id = mac.assignment_id
180: order by paa.person_id;
181:
182: ---------------------------------------------------------------------
189: select distinct
190: 'ASSIGNMENT_ACTION_ID=C',
191: aac.assignment_action_id,
192: 'TAX_UNIT_ID=C',
193: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', apa.legislative_parameters) tax_unit_id,
194: 'DATE_EARNED=C',
195: ac3.context date_earned,
196: 'MONTH=P',
197: to_char(fnd_date.canonical_to_date(ac3.context),'MON') month,
209: ff_user_entities ffe,
210: ff_routes ffr
211: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
212: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
213: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
214: and apa.payroll_action_id = aac.payroll_action_id
215: and paa.assignment_id = aac.assignment_id
216: and aac.assignment_action_id = fai.context1
217: and fai.archive_item_id = ac2.archive_item_id and ac2.sequence_no = 2
219: and apa.action_status = 'C'
220: and fai.user_entity_id = ffe.user_entity_id
221: and ffe.route_id = ffr.route_id
222: and ffr.route_name = 'SG IRAS Month Balances Archive'
223: and (paa.effective_start_date <= to_date('31/' || '12/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy')
224: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
225: order by paa.person_id, fnd_date.canonical_to_date(ac3.context);
226:
227: ---------------------------------------------------------------------
220: and fai.user_entity_id = ffe.user_entity_id
221: and ffe.route_id = ffr.route_id
222: and ffr.route_name = 'SG IRAS Month Balances Archive'
223: and (paa.effective_start_date <= to_date('31/' || '12/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy')
224: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
225: order by paa.person_id, fnd_date.canonical_to_date(ac3.context);
226:
227: ---------------------------------------------------------------------
228: -- Passes parameters to SG_IR8S_WAGE_DETAILS
232: cursor ir8s_wage_details is
233: select distinct 'ASSIGNMENT_ACTION_ID=C',
234: aac.assignment_action_id,
235: 'TAX_UNIT_ID=C',
236: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', apa.legislative_parameters) tax_unit_id,
237: 'SOURCE_ID=C',
238: ac3.context source_id,
239: 'ASS_EXTRA_ID=P',
240: ac3.context ass_extra_id,
250: ff_archive_item_contexts ac2,
251: ff_archive_item_contexts ac3
252: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
253: and paa.person_id = pay_magtape_generic.get_parameter_value('PERSON_ID')
254: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
255: and apa.payroll_action_id = aac.payroll_action_id
256: and aac.assignment_id = paa.assignment_id
257: and aac.assignment_action_id = fai.context1
258: and fai.archive_item_id = ac2.archive_item_id and ac2.sequence_no = 2
264: and fai.context1 = fai1.context1
265: and fai1.user_entity_id = fdi.user_entity_id
266: and fdi.user_name = 'X_IR8S_C_INVALID_RECORDS'
267: and fai1.value = 'Y'
268: and (paa.effective_start_date <= to_date('31/' || '12/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy')
269: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
270: order by paa.person_id, ac3.context;
271:
272:
265: and fai1.user_entity_id = fdi.user_entity_id
266: and fdi.user_name = 'X_IR8S_C_INVALID_RECORDS'
267: and fai1.value = 'Y'
268: and (paa.effective_start_date <= to_date('31/' || '12/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy')
269: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
270: order by paa.person_id, ac3.context;
271:
272:
273: -- Bug 3501956. Modified to retrieve information from PER_PEOPLE_EXTRA_INFO
274: cursor a8b_esop_details is
275: select distinct 'ASSIGNMENT_ACTION_ID=C',
276: aac.assignment_action_id,
277: 'TAX_UNIT_ID=C',
278: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', apa.legislative_parameters) tax_unit_id,
279: 'SOURCE_ID=C',
280: ac3.context source_id,
281: 'PERSON_EXTRA_ID=P', -- 'ASS_EXTRA_ID=P',
282: ac3.context person_extra_id, -- ac3.context ass_extra_id,
291: ff_archive_item_contexts ac2,
292: ff_archive_item_contexts ac3
293: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
294: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
295: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
296: and apa.payroll_action_id = aac.payroll_action_id
297: and paa.assignment_id = aac.assignment_id
298: and apa.action_status = 'C'
299: and aac.assignment_action_id = fai.context1
304: from ff_database_items
305: where user_name = 'X_A8B_OPTION')
306: and fai.value = 'E'
307: /* Bug 2654499 */
308: and (paa.effective_start_date <= to_date('31/' || '12/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy')
309: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
310: and paa.assignment_id = mac.assignment_id /* Bug 2676415 */
311: order by paa.person_id, ac3.context;
312:
305: where user_name = 'X_A8B_OPTION')
306: and fai.value = 'E'
307: /* Bug 2654499 */
308: and (paa.effective_start_date <= to_date('31/' || '12/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy')
309: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
310: and paa.assignment_id = mac.assignment_id /* Bug 2676415 */
311: order by paa.person_id, ac3.context;
312:
313: -- Bug 3501956. Modified to retrieve information from PER_PEOPLE_EXTRA_INFO
314: cursor a8b_eesop_details is
315: select distinct 'ASSIGNMENT_ACTION_ID=C',
316: aac.assignment_action_id,
317: 'TAX_UNIT_ID=C',
318: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', apa.legislative_parameters) tax_unit_id,
319: 'SOURCE_ID=C',
320: ac3.context source_id,
321: 'PERSON_EXTRA_ID=P', -- 'ASS_EXTRA_ID=P',
322: ac3.context person_extra_id, -- ac3.context ass_extra_id,
331: ff_archive_item_contexts ac2,
332: ff_archive_item_contexts ac3
333: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
334: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
335: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
336: and apa.payroll_action_id = aac.payroll_action_id
337: and paa.assignment_id = aac.assignment_id
338: and apa.action_status = 'C'
339: and aac.assignment_action_id = fai.context1
344: from ff_database_items
345: where user_name = 'X_A8B_OPTION')
346: and fai.value = 'EE'
347: /* Bug 2654499 */
348: and (paa.effective_start_date <= to_date('31/' || '12/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy')
349: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
350: and paa.assignment_id = mac.assignment_id
351: order by paa.person_id, ac3.context;
352:
345: where user_name = 'X_A8B_OPTION')
346: and fai.value = 'EE'
347: /* Bug 2654499 */
348: and (paa.effective_start_date <= to_date('31/' || '12/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy')
349: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
350: and paa.assignment_id = mac.assignment_id
351: order by paa.person_id, ac3.context;
352:
353: -- Bug 3501956. Modified to retrieve information from PER_PEOPLE_EXTRA_INFO
354: cursor a8b_csop_details is
355: select distinct 'ASSIGNMENT_ACTION_ID=C',
356: aac.assignment_action_id,
357: 'TAX_UNIT_ID=C',
358: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', apa.legislative_parameters) tax_unit_id,
359: 'SOURCE_ID=C',
360: ac3.context source_id,
361: 'PERSON_EXTRA_ID=P', -- 'ASS_EXTRA_ID=P'
362: ac3.context person_extra_id, -- ac3.context ass_extra_id
371: ff_archive_item_contexts ac2,
372: ff_archive_item_contexts ac3
373: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
374: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
375: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
376: and apa.payroll_action_id = aac.payroll_action_id
377: and paa.assignment_id = aac.assignment_id
378: and apa.action_status = 'C'
379: and aac.assignment_action_id = fai.context1
384: from ff_database_items
385: where user_name = 'X_A8B_OPTION')
386: and fai.value = 'C'
387: /* Bug 2654499 */
388: and (paa.effective_start_date <= to_date('31/' || '12/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy')
389: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
390: and paa.assignment_id = mac.assignment_id
391: order by paa.person_id, ac3.context;
392:
385: where user_name = 'X_A8B_OPTION')
386: and fai.value = 'C'
387: /* Bug 2654499 */
388: and (paa.effective_start_date <= to_date('31/' || '12/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy')
389: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
390: and paa.assignment_id = mac.assignment_id
391: order by paa.person_id, ac3.context;
392:
393: --Bug 7415444, added new cursor for A8B NSOP details
394: cursor a8b_nsop_details is
395: select distinct 'ASSIGNMENT_ACTION_ID=C',
396: aac.assignment_action_id,
397: 'TAX_UNIT_ID=C',
398: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', apa.legislative_parameters) tax_unit_id,
399: 'SOURCE_ID=C',
400: ac3.context source_id,
401: 'PERSON_EXTRA_ID=P', -- 'ASS_EXTRA_ID=P'
402: ac3.context person_extra_id, -- ac3.context ass_extra_id
411: ff_archive_item_contexts ac2,
412: ff_archive_item_contexts ac3
413: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
414: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
415: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
416: and apa.payroll_action_id = aac.payroll_action_id
417: and paa.assignment_id = aac.assignment_id
418: and apa.action_status = 'C'
419: and aac.assignment_action_id = fai.context1
424: from ff_database_items
425: where user_name = 'X_A8B_OPTION')
426: and fai.value = 'N'
427: /* Bug 2654499 */
428: and (paa.effective_start_date <= to_date('31/' || '12/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy')
429: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
430: and paa.assignment_id = mac.assignment_id
431: order by paa.person_id, ac3.context;
432:
425: where user_name = 'X_A8B_OPTION')
426: and fai.value = 'N'
427: /* Bug 2654499 */
428: and (paa.effective_start_date <= to_date('31/' || '12/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy')
429: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
430: and paa.assignment_id = mac.assignment_id
431: order by paa.person_id, ac3.context;
432:
433:
436: cursor a8b_total_details is
437: select distinct 'ASSIGNMENT_ACTION_ID=C',
438: aac.assignment_action_id,
439: 'TAX_UNIT_ID=C',
440: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', apa.legislative_parameters) tax_unit_id,
441: 'PERSON_ID=P',
442: to_char(paa.person_id) person_id
443: from per_all_assignments_f paa,
444: pay_payroll_actions mpa,
449: ff_archive_item_contexts ac2,
450: ff_archive_item_contexts ac3
451: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
452: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
453: and apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', mpa.legislative_parameters)
454: and apa.payroll_action_id = aac.payroll_action_id
455: and paa.assignment_id = aac.assignment_id
456: and apa.action_status = 'C'
457: and aac.assignment_action_id = fai.context1
461: select user_entity_id
462: from ff_database_items
463: where user_name = 'X_A8B_OPTION')
464: /* Bug 2654499 */
465: and (paa.effective_start_date <= to_date('31/' || '12/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy')
466: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
467: and paa.assignment_id = mac.assignment_id
468: order by paa.person_id;
469: end pay_sg_iras_magtape;
462: from ff_database_items
463: where user_name = 'X_A8B_OPTION')
464: /* Bug 2654499 */
465: and (paa.effective_start_date <= to_date('31/' || '12/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy')
466: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
467: and paa.assignment_id = mac.assignment_id
468: order by paa.person_id;
469: end pay_sg_iras_magtape;