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_TIMES_PVT dependencies on AHL_VWP_STAGES_B

Line 335: from ahl_vwp_stages_b

331: --Cursor for deriving the task's stage dates
332: CURSOR get_stage_details(c_visit_id IN number)
333: IS
334: SELECT planned_start_date, planned_end_date, stage_id
335: from ahl_vwp_stages_b
336: where visit_id = c_visit_id;
337:
338:
339: -- Define local variables

Line 534: from ahl_vwp_stages_b st, ahl_visit_tasks_b vt

530: --Cursor for deriving all the stage dates
531: CURSOR get_stage_dates(p_task_ID IN number)
532: IS
533: SELECT st.planned_start_date, st.planned_end_date
534: from ahl_vwp_stages_b st, ahl_visit_tasks_b vt
535: where st.stage_id = vt.stage_id
536: AND vt.visit_task_id = p_task_id;
537:
538: -- Define local variables