APPS.AHL_VWP_VISITS_PVT dependencies on DUAL

Line 546: FROM dual;

542:
543: -- To find the next id value from visit sequence
544: CURSOR c_seq IS
545: SELECT Ahl_Visits_B_S.NEXTVAL
546: FROM dual;
547:
548: -- To find whether id already exists
549: CURSOR c_id_exists (x_id IN NUMBER) IS
550: SELECT 1 FROM Ahl_Visits_VL

Line 1693: FROM dual;

1689: -- Define local Cursors
1690: -- To find the next id value from visit sequence
1691: CURSOR c_seq IS
1692: SELECT Ahl_Visits_B_S.NEXTVAL
1693: FROM dual;
1694:
1695: -- To find whether id already exists
1696: CURSOR c_id_exists (x_id IN NUMBER) IS
1697: SELECT 1 FROM Ahl_Visits_VL

Line 3547: select AHL_VWP_VISITS_PVT.Is_Old_Visit(p_visit_id) IS_OLD_VISIT FROM DUAL;

3543: l_latest_wo_end_date DATE; */
3544:
3545: -- PRAKKUM :: 28-JUN-2011 :: VWPE :: ER 12730539 :: To find visit is old or new
3546: CURSOR c_is_old_visit(p_visit_id IN NUMBER) IS
3547: select AHL_VWP_VISITS_PVT.Is_Old_Visit(p_visit_id) IS_OLD_VISIT FROM DUAL;
3548:
3549: l_is_old_visit_dets c_is_old_visit%RowType;
3550:
3551: -- TCHIMIRA ::28-JUN-2011 :: VWP: ER:12673125 :: START

Line 5247: /* SELECT 'X' FROM DUAL

5243: l_visit_rec c_Visit%ROWTYPE;
5244:
5245: -- To find whether the visit has any materials
5246: CURSOR c_Material(x_visit_id IN NUMBER) IS
5247: /* SELECT 'X' FROM DUAL
5248: WHERE exists (select 'X' from AHL_SCHEDULE_MATERIALS_V where VISIT_ID = x_visit_id);*/
5249:
5250: -- AnRaj: Changed for fixing the perf bug 4919502
5251: SELECT 'x' FROM ahl_schedule_materials

Line 6851: SELECT 'X' FROM DUAL

6847: AND NVL(STATUS_CODE,'X') <> 'DELETED';
6848:
6849: -- To check if any other active visits have this SR associated
6850: CURSOR c_check_SR (x_visit_id IN NUMBER, x_sr_id IN NUMBER) IS
6851: SELECT 'X' FROM DUAL
6852: WHERE exists ( select a.visit_id
6853: from ahl_visits_b a, ahl_visit_tasks_b b
6854: where a.visit_id <> x_visit_id
6855: and a.visit_id = b.visit_id