Unable to access HRMS secured views when inoveked through self service HRSSA

Hello Friends,

We are using HRSSA workflow, but a little customized version. The functions in the workflow calling a custom package use secured views, at times the transaction error with "no data found" and sometimes it goes through fine. See below query from custom package we call in sshr.

  BEGIN

    SELECT SUBSTR(name,1,3) INTO l_requisition_name

          FROM hr_organization_units ---> secured view                          

         WHERE organization_id = l_organization_id;

     EXCEPTION

     WHEN OTHERS THEN

      Wf_Core.CONTEXT('coc_hr_wf', 'Create_Job_Requisition-1', itemtype, itemkey);

  

      RAISE;

     END; 

We get the error "no data found" here. If I change the view to table (