Begin
     select JOB_NAME, EMP_STATUS,PAY_CARD_NO,CARD_ISSUE_DATE,CONTRACT_END_DATE,CARD_EXPIRY_DATE,
     REMARKS, CONTRACT_START_DATE,SALARY,PEO_PER_CODE,COM_COM_CODE
     Into :MOL_EMPLOYEESES.JOB_NAME, :MOL_EMPLOYEESES.EMP_STATUS,
     :MOL_EMPLOYEESES.PAY_CARD_NO ,:MOL_EMPLOYEESES.CARD_ISSUE_DATE,:MOL_EMPLOYEESES.CONTRACT_END_DATE,
     :MOL_EMPLOYEESES.CARD_EXPIRY_DATE,
     :MOL_EMPLOYEESES.REMARKS, :MOL_EMPLOYEESES.CONTRACT_START_DATE, :MOL_EMPLOYEESES.SALARY,
     :MOL_EMPLOYEESES.PEO_PER_CODE, :MOL_EMPLOYEESES.COM_COM_CODE  
from MOL_EMPLOYEESES
where MOL_EMPLOYEESES.CARD_NO = :MOL_EMPLOYEESES.CARD_NO;
     select PER_NAME
     Into :MOL_EMPLOYEESES.PER_NAME 
from MOL_PEOPLES
where MOL_PEOPLES.PER_CODE = :MOL_EMPLOYEESES.PEO_PER_CODE;
    select COM_NAME
     Into :MOL_EMPLOYEESES.COM_NAME
from MOL_COMPANIESES
where MOL_COMPANIESES.COM_CODE = :MOL_EMPLOYEESES.COM_COM_CODE;

End;