77: lpad(nvl(substr(hoi.org_information1,1,3),' '),3,0) tax_office_no,
78: decode(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
79: nvl(upper(substr(hoi.org_information6,1,13)),' ') acc_ref_no,
80: hoi.org_information7 econ,
81: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIN_SUB'),1,20) final_submission
82: from pay_payroll_actions pact,
83: hr_organization_information hoi
84: where pact.payroll_action_id=pactid
85: and pact.business_group_id = hoi.organization_id
2364: IS
2365:
2366:
2367: cursor csr_parameter_info is
2368: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
2369: /*ppa.effective_date*/
2370: sysdate
2371: from pay_payroll_actions ppa
2372: ,pay_assignment_actions paa