DBA Data[Home] [Help]

APPS.GME_COMMON_PVT dependencies on DUAL

Line 289: FROM DUAL

285:
286: CURSOR cur_get_user (v_user_id NUMBER)
287: IS
288: SELECT 1
289: FROM DUAL
290: WHERE EXISTS (SELECT 1
291: FROM fnd_user
292: WHERE user_id = v_user_id);
293:

Line 3419: FROM DUAL

3415: END IF;
3416:
3417: SELECT COUNT (1)
3418: INTO l_assoc_count
3419: FROM DUAL
3420: WHERE EXISTS (SELECT 1
3421: FROM gme_batch_step_items
3422: WHERE material_detail_id = p_material_detail_id);
3423:

Line 4828: FROM DUAL

4824: l_is_auto := 0;
4825: ELSIF l_release_type = 3 THEN
4826: SELECT COUNT (1)
4827: INTO l_dep_count
4828: FROM DUAL
4829: WHERE EXISTS (SELECT 1
4830: FROM gme_batch_step_items
4831: WHERE material_detail_id = p_line_id);
4832: