APPS.AMS_EVENTOFFER_PVT dependencies on DUAL

Line 330: FROM DUAL;

326: WHERE user_id = l_user_id;
327:
328: CURSOR c_evo_seq IS
329: SELECT ams_event_offers_all_b_s.NEXTVAL
330: FROM DUAL;
331:
332: CURSOR c_evo_count(evo_id IN NUMBER) IS
333: SELECT count(*)
334: FROM ams_event_offers_all_b

Line 3223: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from ams_source_codes

3219: IS
3220: l_valid_flag VARCHAR2(1);
3221: l_dummy NUMBER;
3222: cursor c_src_code(src_code_in IN VARCHAR2) IS
3223: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from ams_source_codes
3224: where SOURCE_CODE = src_code_in);
3225: BEGIN
3226: x_return_status := FND_API.g_ret_sts_success;
3227: