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 519: FROM dual;

515: l_isValidationFailed BOOLEAN DEFAULT false;
516:
517: CURSOR c_seq IS
518: SELECT Ahl_vwp_stages_B_S.NEXTVAL
519: FROM dual;
520:
521: -- To find whether id already exists
522: CURSOR c_id_exists (x_id IN NUMBER) IS
523: SELECT 1

Line 2003: FROM dual;

1999:
2000: -- To find the next id value from visit sequence
2001: CURSOR c_seq IS
2002: SELECT Ahl_vwp_stages_B_S.NEXTVAL
2003: FROM dual;
2004:
2005: -- To find whether id already exists
2006: CURSOR c_id_exists (x_id IN NUMBER) IS
2007: SELECT 1

Line 2375: SELECT 1 from dual WHERE exists(

2371:
2372: -- Added by amagrawa based on review comments
2373: -- To find if the all visit tasks dept has department shifts defined
2374: CURSOR c_task_dep_exist (x_visit_id IN NUMBER) IS
2375: SELECT 1 from dual WHERE exists(
2376: SELECT visit_task_id from ahl_visit_tasks_b
2377: Where department_id is not null
2378: and visit_id = x_visit_id
2379: and nvl(status_code,'X')<>'DELETED'