DBA Data[Home] [Help]

APPS.WMS_LMS_UTILS dependencies on WMS_ELS_NON_TRACKED_USERS

Line 145: --select from the WMS_ELS_NON_TRACKED_USERS and see that

141: IF g_debug=1 THEN
142: debug('The value of user_id '|| p_user_id,'IS_USER_NON_TRACKED');
143: END IF;
144:
145: --select from the WMS_ELS_NON_TRACKED_USERS and see that
146: -- is the user_id has been defined as a phantom user or not.
147:
148: SELECT 1
149: INTO l_user_id

Line 150: FROM WMS_ELS_NON_TRACKED_USERS

146: -- is the user_id has been defined as a phantom user or not.
147:
148: SELECT 1
149: INTO l_user_id
150: FROM WMS_ELS_NON_TRACKED_USERS
151: WHERE USER_ID = P_USER_ID
152: AND ORGANIZATION_ID= P_ORG_ID;
153:
154: -- A row is returned so return true(the user is a phantom user)