APPS.EGO_PUB_WS_DEST SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 37

        SELECT  USER_ID
        INTO    l_fnd_user_id
        FROM    FND_USER
        WHERE   USER_NAME = p_fnd_user_name;

Line: 48

        SELECT  RESPONSIBILITY_ID
          INTO    l_resp_id
          FROM    FND_RESPONSIBILITY
          WHERE   RESPONSIBILITY_KEY = p_resp_name;

Line: 60

        SELECT  APPLICATION_ID
          INTO    l_resp_appl_id
          FROM    FND_APPLICATION
          WHERE   APPLICATION_SHORT_NAME = p_resp_appl_name;