APPS.AHL_PRD_VISITS_PVT dependencies on AHL_PRD_VISITS_V

Line 212: SELECT * FROM AHL_PRD_VISITS_V

208:
209: -- Define local cursors
210: -- To find out required search visit details
211: CURSOR c_visit (x_id IN NUMBER) IS
212: SELECT * FROM AHL_PRD_VISITS_V
213: WHERE VISIT_ID = x_id;
214: c_visit_rec c_visit%ROWTYPE;
215:
216: -- To find out all visit/template details