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 DUAL

Line 1191: FROM dual;

1187:
1188: -- To find the next id value from visit sequence
1189: CURSOR c_seq IS
1190: SELECT Ahl_vwp_stages_B_S.NEXTVAL
1191: FROM dual;
1192:
1193: -- To find whether id already exists
1194: CURSOR c_id_exists (x_id IN NUMBER) IS
1195: SELECT 1

Line 1491: SELECT 1 from dual WHERE exists(

1487:
1488: -- Added by amagrawa based on review comments
1489: -- To find if the all visit tasks dept has department shifts defined
1490: CURSOR c_task_dep_exist (x_visit_id IN NUMBER) IS
1491: SELECT 1 from dual WHERE exists(
1492: SELECT visit_task_id from ahl_visit_tasks_b
1493: Where department_id is not null
1494: and visit_id = x_visit_id
1495: and nvl(status_code,'X')<>'DELETED'