270: p_xml_blob BLOB;
271: cursor c_get_params is
272: select paa1.assignment_action_id, -- archiver asg action
273: ppa1.payroll_action_id, -- archiver pact
274: pay_ca_t4_reg.get_parameter('TYPE',ppa.legislative_parameters),
275: pay_ca_t4_reg.get_parameter('PRINT',ppa.legislative_parameters),
276: pay_ca_t4_reg.get_parameter('INSTRUCTIONS',ppa.legislative_parameters),
277: substr(paa.serial_number,1,2)
278: from pay_assignment_actions paa,
271: cursor c_get_params is
272: select paa1.assignment_action_id, -- archiver asg action
273: ppa1.payroll_action_id, -- archiver pact
274: pay_ca_t4_reg.get_parameter('TYPE',ppa.legislative_parameters),
275: pay_ca_t4_reg.get_parameter('PRINT',ppa.legislative_parameters),
276: pay_ca_t4_reg.get_parameter('INSTRUCTIONS',ppa.legislative_parameters),
277: substr(paa.serial_number,1,2)
278: from pay_assignment_actions paa,
279: pay_payroll_actions ppa,
272: select paa1.assignment_action_id, -- archiver asg action
273: ppa1.payroll_action_id, -- archiver pact
274: pay_ca_t4_reg.get_parameter('TYPE',ppa.legislative_parameters),
275: pay_ca_t4_reg.get_parameter('PRINT',ppa.legislative_parameters),
276: pay_ca_t4_reg.get_parameter('INSTRUCTIONS',ppa.legislative_parameters),
277: substr(paa.serial_number,1,2)
278: from pay_assignment_actions paa,
279: pay_payroll_actions ppa,
280: pay_assignment_actions paa1,