424: --
425: l_start_dt := TO_DATE(l_start_date,'YYYY/MM/DD');
426: l_end_dt := TO_DATE(l_end_date,'YYYY/MM/DD');
427: --
428: pay_core_files.write_to_magtape_lob('');
429: pay_core_files.write_to_magtape_lob('
430: --
431: FOR csr_archive_act_rec in csr_archive_act(l_payroll_id
432: ,l_consolidation_set_id
425: l_start_dt := TO_DATE(l_start_date,'YYYY/MM/DD');
426: l_end_dt := TO_DATE(l_end_date,'YYYY/MM/DD');
427: --
428: pay_core_files.write_to_magtape_lob('');
429: pay_core_files.write_to_magtape_lob('
431: FOR csr_archive_act_rec in csr_archive_act(l_payroll_id
432: ,l_consolidation_set_id
433: ,l_start_dt
444: ,P_DOCUMENT_TYPE => 'PAYSLIP'
445: ,P_XML => l_xml);
446: --
447: --hr_utility.trace('#### act_id '||csr_archive_act_rec.action_context_id);
448: pay_core_files.write_to_magtape_lob(l_xml);
449: --
450: END LOOP;
451: pay_core_files.write_to_magtape_lob('');
452: --
447: --hr_utility.trace('#### act_id '||csr_archive_act_rec.action_context_id);
448: pay_core_files.write_to_magtape_lob(l_xml);
449: --
450: END LOOP;
451: pay_core_files.write_to_magtape_lob('');
452: --
453: END xml_asg;
454: --
455: END pay_payslip_report;