163:
164: cursor c_get_params is
165: select paa1.assignment_action_id, -- archiver asg action
166: ppa1.payroll_action_id, -- archiver pact
167: pay_ca_t4_reg.get_parameter('TYPE',ppa.legislative_parameters),
168: pay_ca_t4_reg.get_parameter('PRINT',ppa.legislative_parameters),
169: pay_ca_t4_reg.get_parameter('INSTRUCTIONS',ppa.legislative_parameters),
170: substr(paa.serial_number,1,2)
171: from pay_assignment_actions paa,
164: cursor c_get_params is
165: select paa1.assignment_action_id, -- archiver asg action
166: ppa1.payroll_action_id, -- archiver pact
167: pay_ca_t4_reg.get_parameter('TYPE',ppa.legislative_parameters),
168: pay_ca_t4_reg.get_parameter('PRINT',ppa.legislative_parameters),
169: pay_ca_t4_reg.get_parameter('INSTRUCTIONS',ppa.legislative_parameters),
170: substr(paa.serial_number,1,2)
171: from pay_assignment_actions paa,
172: pay_payroll_actions ppa,
165: select paa1.assignment_action_id, -- archiver asg action
166: ppa1.payroll_action_id, -- archiver pact
167: pay_ca_t4_reg.get_parameter('TYPE',ppa.legislative_parameters),
168: pay_ca_t4_reg.get_parameter('PRINT',ppa.legislative_parameters),
169: pay_ca_t4_reg.get_parameter('INSTRUCTIONS',ppa.legislative_parameters),
170: substr(paa.serial_number,1,2)
171: from pay_assignment_actions paa,
172: pay_payroll_actions ppa,
173: pay_assignment_actions paa1,