eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on AHL_VISITS_VL

Line 302: SELECT * FROM AHL_VISITS_VL

298: l_msg_count NUMBER;
299:
300: -- To find visit related information
301: CURSOR c_visit(x_id IN NUMBER) IS
302: SELECT * FROM AHL_VISITS_VL
303: WHERE VISIT_ID = x_id;
304: c_visit_rec c_visit%ROWTYPE;
305:
306: BEGIN

Line 540: FROM Ahl_Visits_VL

536:
537: -- To find visit related information
538: CURSOR c_Visit (p_visit_id IN NUMBER) IS
539: SELECT Any_Task_Chg_Flag, Visit_Id
540: FROM Ahl_Visits_VL
541: WHERE VISIT_ID = p_visit_id;
542: l_visit_csr_rec c_Visit%ROWTYPE;
543:
544: -- To find if this Unit has been planned in other visits already

Line 1303: SELECT * FROM Ahl_Visits_VL

1299: l_department_id NUMBER;
1300:
1301: -- To find visit related information
1302: CURSOR c_Visit (x_id IN NUMBER) IS
1303: SELECT * FROM Ahl_Visits_VL
1304: WHERE VISIT_ID = x_id;
1305: c_Visit_rec c_Visit%ROWTYPE;
1306:
1307: -- To find task related information