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_VISITS_STAGES_PVT dependencies on AHL_VISITS_VL

Line 128: SELECT START_DATE_TIME , department_id FROM AHL_VISITS_VL

124:
125: -- To find visit related information
126: CURSOR c_visit (x_id IN NUMBER)
127: IS
128: SELECT START_DATE_TIME , department_id FROM AHL_VISITS_VL
129: WHERE VISIT_ID = x_id;
130: --
131: CURSOR C_STAGE(C_VISIT_ID number)
132: is

Line 1461: SELECT * FROM AHL_VISITS_VL

1457:
1458: -- Define local cursors
1459: -- To find out all visit/template details
1460: CURSOR c_visit(x_id IN NUMBER) IS
1461: SELECT * FROM AHL_VISITS_VL
1462: WHERE VISIT_ID = x_id;
1463: c_visit_rec c_visit%ROWTYPE;
1464:
1465: -- To find whether dept shifts exist for the dept