DBA Data[Home] [Help]

APPS.GME_COMMON_PVT dependencies on DUAL

Line 203: FROM DUAL

199:
200: CURSOR cur_get_user (v_user_id NUMBER)
201: IS
202: SELECT 1
203: FROM DUAL
204: WHERE EXISTS (SELECT 1
205: FROM fnd_user
206: WHERE user_id = v_user_id);
207:

Line 3160: FROM DUAL

3156: END IF;
3157:
3158: SELECT COUNT (1)
3159: INTO l_assoc_count
3160: FROM DUAL
3161: WHERE EXISTS (SELECT 1
3162: FROM gme_batch_step_items
3163: WHERE material_detail_id = p_material_detail_id);
3164:

Line 4569: FROM DUAL

4565: l_is_auto := 0;
4566: ELSIF l_release_type = 3 THEN
4567: SELECT COUNT (1)
4568: INTO l_dep_count
4569: FROM DUAL
4570: WHERE EXISTS (SELECT 1
4571: FROM gme_batch_step_items
4572: WHERE material_detail_id = p_line_id);
4573: