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_RULES_PVT dependencies on AHL_VWP_STAGES_VL

Line 2249: FROM ahl_vwp_stages_vl

2245:
2246: CURSOR c_stage(p_stage_number IN NUMBER, p_visit_id IN NUMBER) IS
2247: SELECT stage_id,
2248: stage_name
2249: FROM ahl_vwp_stages_vl
2250: WHERE stage_num = p_stage_number
2251: AND visit_id = p_visit_id;
2252:
2253: CURSOR c_mr_title(p_mr_id IN NUMBER) IS

Line 3501: FROM AHL_VWP_STAGES_VL

3497: CURSOR c_sum_stage_duration (c_stage_name VARCHAR2,
3498: c_visit_id NUMBER)
3499: IS
3500: SELECT sum(duration)
3501: FROM AHL_VWP_STAGES_VL
3502: WHERE visit_id = c_visit_id
3503: AND stage_num < (select stage_num
3504: from AHL_VWP_STAGES_VL
3505: WHERE stage_name = c_stage_name

Line 3504: from AHL_VWP_STAGES_VL

3500: SELECT sum(duration)
3501: FROM AHL_VWP_STAGES_VL
3502: WHERE visit_id = c_visit_id
3503: AND stage_num < (select stage_num
3504: from AHL_VWP_STAGES_VL
3505: WHERE stage_name = c_stage_name
3506: AND visit_id = c_visit_id);
3507: --
3508:

Line 4266: FROM AHL_VWP_STAGES_VL stage, AHL_VISIT_TASKS_B task1

4262: --Cursor to get the stage details for a given task
4263: CURSOR c_stage_details(p_task_id IN NUMBER)
4264: IS
4265: SELECT task1.visit_task_id, stage.STAGE_ID, stage.STAGE_NAME
4266: FROM AHL_VWP_STAGES_VL stage, AHL_VISIT_TASKS_B task1
4267: WHERE task1.stage_id = stage.stage_id
4268: AND task1.visit_task_id IN ( SELECT task.visit_task_id
4269: FROM AHL_VISIT_TASKS_B task
4270: WHERE task.task_type_code IN ('PLANNED','UNPLANNED')