APPS.AHL_VWP_VISITS_PVT dependencies on DUAL

Line 489: FROM dual;

485:
486: -- To find the next id value from visit sequence
487: CURSOR c_seq IS
488: SELECT Ahl_Visits_B_S.NEXTVAL
489: FROM dual;
490:
491: -- To find whether id already exists
492: CURSOR c_id_exists (x_id IN NUMBER) IS
493: SELECT 1 FROM Ahl_Visits_VL

Line 1421: FROM dual;

1417: -- Define local Cursors
1418: -- To find the next id value from visit sequence
1419: CURSOR c_seq IS
1420: SELECT Ahl_Visits_B_S.NEXTVAL
1421: FROM dual;
1422:
1423: -- To find whether id already exists
1424: CURSOR c_id_exists (x_id IN NUMBER) IS
1425: SELECT 1 FROM Ahl_Visits_VL

Line 4005: /* SELECT 'X' FROM DUAL

4001: l_visit_rec c_Visit%ROWTYPE;
4002:
4003: -- To find whether the visit has any materials
4004: CURSOR c_Material(x_visit_id IN NUMBER) IS
4005: /* SELECT 'X' FROM DUAL
4006: WHERE exists (select 'X' from AHL_SCHEDULE_MATERIALS_V where VISIT_ID = x_visit_id);*/
4007:
4008: -- AnRaj: Changed for fixing the perf bug 4919502
4009: SELECT 'x' FROM ahl_schedule_materials

Line 5203: SELECT 'X' FROM DUAL

5199: AND NVL(STATUS_CODE,'X') <> 'DELETED';
5200:
5201: -- To check if any other active visits have this SR associated
5202: CURSOR c_check_SR (x_visit_id IN NUMBER, x_sr_id IN NUMBER) IS
5203: SELECT 'X' FROM DUAL
5204: WHERE exists ( select a.visit_id
5205: from ahl_visits_b a, ahl_visit_tasks_b b
5206: where a.visit_id <> x_visit_id
5207: and a.visit_id = b.visit_id