APPS.AHL_VWP_UNPLAN_TASKS_PVT dependencies on AHL_VISITS_VL

Line 287: SELECT * FROM AHL_VISITS_VL

283: WHERE Inventory_Item_ID = c_item_id AND MR_HEADER_ID = c_mr_header_id;
284:
285: -- To find visit related information
286: CURSOR c_visit(c_visit_id IN NUMBER) IS
287: SELECT * FROM AHL_VISITS_VL
288: WHERE VISIT_ID = c_visit_id;
289: c_visit_rec c_visit%ROWTYPE;
290:
291: -- Added by rnahata for Issue 105

Line 574: FROM Ahl_Visits_VL

570:
571: -- To find visit related information
572: CURSOR c_Visit (p_visit_id IN NUMBER) IS
573: SELECT Any_Task_Chg_Flag,visit_id
574: FROM Ahl_Visits_VL
575: WHERE VISIT_ID = p_visit_id;
576: l_visit_csr_rec c_Visit%ROWTYPE;
577:
578: -- yazhou 11Nov2005 starts

Line 889: SELECT * FROM Ahl_Visits_VL

885: c_upd_Task_rec c_Task%ROWTYPE;
886:
887: -- To find visit related information
888: CURSOR c_Visit (x_id IN NUMBER) IS
889: SELECT * FROM Ahl_Visits_VL
890: WHERE VISIT_ID = x_id;
891: c_Visit_rec c_Visit%ROWTYPE;
892:
893: BEGIN