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 849: SELECT * FROM Ahl_Visits_VL

845: c_upd_Task_rec c_Task%ROWTYPE;
846:
847: -- To find visit related information
848: CURSOR c_Visit (x_id IN NUMBER) IS
849: SELECT * FROM Ahl_Visits_VL
850: WHERE VISIT_ID = x_id;
851: c_Visit_rec c_Visit%ROWTYPE;
852:
853: BEGIN