APPS.AHL_VWP_RULES_PVT dependencies on DUAL

Line 1207: FROM DUAL;

1203: -- PRAKKUM :: 14-JUL-2011 :: VWPE 12730539
1204: -- To find whether visit is old or new
1205: CURSOR c_get_old_visit_dets (vst_id IN NUMBER) IS
1206: SELECT AHL_VWP_VISITS_PVT.Is_Old_Visit(vst_id) IS_OLD_VISIT
1207: FROM DUAL;
1208:
1209: l_is_old_visit VARCHAR2(1) := 'N';
1210:
1211: -- SKPATHAK :: Bug 13574991 :: 16-FEB-2012 :: FPed all fixes on R121 codeline

Line 1723: FROM dual;

1719: IS
1720: -- Define local cursors
1721: CURSOR c_seq_t IS
1722: SELECT Ahl_Visit_Tasks_B_S.NEXTVAL
1723: FROM dual;
1724:
1725: CURSOR c_id_exists_t (c_id IN NUMBER) IS
1726: SELECT 1
1727: FROM Ahl_Visit_Tasks_VL

Line 2011: SELECT ahl_task_links_s.nextval INTO l_task_link_id FROM DUAL;

2007: 'Value of precedence constraint is ' || l_prec_constraint);
2008: END IF;
2009:
2010: IF l_tsk_flag = 'Y' THEN
2011: SELECT ahl_task_links_s.nextval INTO l_task_link_id FROM DUAL;
2012:
2013: IF l_task_rec.attribute_category = Fnd_Api.G_MISS_CHAR THEN
2014: l_task_rec.attribute_category := NULL;
2015: END IF;

Line 2280: FROM DUAL;

2276: -- PRAKKUM :: 14-JUL-2011 :: VWPE 12730539
2277: -- To find whether visit is old or new
2278: CURSOR c_get_old_visit_dets (vst_id IN NUMBER) IS
2279: SELECT AHL_VWP_VISITS_PVT.Is_Old_Visit(vst_id) IS_OLD_VISIT
2280: FROM DUAL;
2281:
2282: l_is_old_visit VARCHAR2(1) := 'N';
2283:
2284: MR_Route_Tbl MR_Route_Tbl_Type;