APPS.JTM_CON_QUERY_REQUEST_PKG dependencies on ASG_USER

Line 36: FROM asg_user au

32: --Bug 4924543
33: CURSOR c_item_resources( b_pub_item_name VARCHAR2 )
34: IS
35: SELECT au.resource_id
36: FROM asg_user au
37: , asg_user_pub_resps aupr
38: , asg_pub_item api
39: WHERE au.user_name = aupr.user_name
40: AND aupr.pub_name = api.pub_name

Line 37: , asg_user_pub_resps aupr

33: CURSOR c_item_resources( b_pub_item_name VARCHAR2 )
34: IS
35: SELECT au.resource_id
36: FROM asg_user au
37: , asg_user_pub_resps aupr
38: , asg_pub_item api
39: WHERE au.user_name = aupr.user_name
40: AND aupr.pub_name = api.pub_name
41: AND api.name = b_pub_item_name

Line 128: from asg_user u, asg_user_Pub_resps r

124: , v_module => 'jtm_message_log_pkg');
125: END IF;
126:
127: select u.user_id BULK COLLECT INTO l_csl_tab_user
128: from asg_user u, asg_user_Pub_resps r
129: where u.user_name = r.user_name
130: and r.pub_name = 'JTM';
131:
132: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

Line 142: from asg_user u, asg_user_Pub_resps r

138: , v_module => 'jtm_message_log_pkg');
139: END IF;
140:
141: select u.user_id BULK COLLECT INTO l_csm_tab_user
142: from asg_user u, asg_user_Pub_resps r
143: where u.user_name = r.user_name
144: and r.pub_name = 'JTM_HANDHELD';
145:
146: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN