79:
80: begin
81:
82: /* get payroll_action,report_group,record_id,legislation_code */
83: pactid:=pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
84: if (pactid is NULL)
85: then
86: pactid:=pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
87: end if;
82: /* get payroll_action,report_group,record_id,legislation_code */
83: pactid:=pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
84: if (pactid is NULL)
85: then
86: pactid:=pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
87: end if;
88: seq:=pay_magtape_generic.get_parameter_value('rec_sequence');
89: mag_block:=pay_magtape_generic.get_parameter_value('magnetic_block_id');
90:
84: if (pactid is NULL)
85: then
86: pactid:=pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
87: end if;
88: seq:=pay_magtape_generic.get_parameter_value('rec_sequence');
89: mag_block:=pay_magtape_generic.get_parameter_value('magnetic_block_id');
90:
91:
92: select grp.legislation_code,prg.report_group_id
85: then
86: pactid:=pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
87: end if;
88: seq:=pay_magtape_generic.get_parameter_value('rec_sequence');
89: mag_block:=pay_magtape_generic.get_parameter_value('magnetic_block_id');
90:
91:
92: select grp.legislation_code,prg.report_group_id
93: into leg_code ,rep_grp