Get FND_GLOBAL.APPS_INITIALIZE Values

Select Fnd.User_Id,

       Fresp.Responsibility_Id,

       Fresp.Application_Id,

       Fresp.Responsibility_Name

  From Fnd_User Fnd, Fnd_Responsibility_Tl Fresp

 Where Fnd.User_Name = Upper (:Your_Name)  --'LOKANADHAM'

And Fresp.Responsibility_Name = Nvl (:Resp_Name, Fresp.Responsibility_Name)

--------------------------------------------or------------------------------------------------

  SELECT u.user_name user_name,

         a.application_name application,

         r.responsibility_name responsiblity,

         u.user_id,

         r.responsibility_id,

         r.application_id

    FROM fnd_user u,

         fnd_user_resp_groups g,

         fnd_application_tl a,

         fnd_responsibility_tl r

   WHERE     g.user_id = u.user_id

         AND g.responsibility_application_id = a.application_id

         AND a.application_id = r.application_id

         AND g.responsibility_id = r.responsibility_id

         AND u.user_name = UPPER (:user_name)---LOKANADHAM

         AND r.responsibility_name = NVL (:resp_name, r.responsibility_name)--AP Msf User

ORDER BY r.responsibility_name;