Hiii,
I had written procedure which will display missing data from a table

Code:
CREATE OR REPLACE PROCEDURE GETEMPLOYEE_INFO
(
P_CPNCOD in varchar2,
P_PAYDAT in date,
P_PAYTYP in varchar2,
P_ERV out varchar2)
is
R_DI_FILLODINF NUMBER(20);
BEGIN
   FOR i IN (SELECT * FROM DI_ELEMOD)
   LOOP
     SELECT COUNT(*) INTO R_DI_FILLODINF
     FROM DI_FILLODINF
...