APPS.AMS_AGENDAS_PVT dependencies on DUAL

Line 71: FROM DUAL;

67:
68:
69: CURSOR c_agenda_seq IS
70: SELECT ams_agendas_b_s.NEXTVAL
71: FROM DUAL;
72:
73: CURSOR c_agenda_count(l_agenda_id IN NUMBER) IS
74: SELECT count(*)
75: FROM ams_agendas_v

Line 1565: SELECT 1 FROM DUAL

1561: l_valid_flag VARCHAR2(1);
1562: l_dummy NUMBER;
1563:
1564: cursor c_track_name IS
1565: SELECT 1 FROM DUAL
1566: WHERE EXISTS (SELECT 1 from ams_agendas_v
1567: WHERE agenda_name = p_agenda_rec.agenda_name
1568: AND parent_id = p_agenda_rec.parent_id);
1569: