DROP PROCEDURE OFFICEUSER.SP_OFFICEUSER_INSERT_PAYROLL

CREATE OR REPLACE PROCEDURE OFFICEUSER.SP_OFFICEUSER_INSERT_PAYROLL

IS

CURSOR

C_EMP

IS

SELECT DISTINCT(EMP_NO) as emp_no FROM EMPLOYEE_PAYROLL_MASTER;

CURSOR

C_EMP_INSERT(empNo in number)

IS

...