214:
215: CURSOR csr_get_chk_no IS
216: SELECT paa_chk.serial_number
217: FROM pay_assignment_actions paa_xfr,
218: pay_action_interlocks pai_xfr,
219: pay_action_interlocks pai_chk,
220: pay_assignment_actions paa_chk,
221: pay_payroll_actions ppa_chk
222: WHERE paa_xfr.assignment_action_id = pai_xfr.locking_action_id
215: CURSOR csr_get_chk_no IS
216: SELECT paa_chk.serial_number
217: FROM pay_assignment_actions paa_xfr,
218: pay_action_interlocks pai_xfr,
219: pay_action_interlocks pai_chk,
220: pay_assignment_actions paa_chk,
221: pay_payroll_actions ppa_chk
222: WHERE paa_xfr.assignment_action_id = pai_xfr.locking_action_id
223: AND pai_xfr.locked_action_id = pai_chk.locked_action_id