56: WHERE USER_NAME = p_user_name;
57:
58: SELECT APPLICATION_ID
59: INTO l_application_id
60: FROM FND_APPLICATION_VL
61: WHERE APPLICATION_NAME = p_application_name;
62:
63: SELECT responsibility_id
64: INTO l_resp_id
174:
175:
176: SELECT APPLICATION_ID
177: INTO l_application_id
178: FROM FND_APPLICATION_VL
179: WHERE APPLICATION_NAME = p_application_name;
180:
181:
182: SELECT responsibility_id