DBA Data[Home] [Help]

APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_VWP_STAGES_B

Line 3576: FROM ahl_visit_stage_typ_asoc assoc, ahl_visit_tasks_b task, ahl_vwp_stages_b stage

3572: Cursor get_stage_task (c_visit_id IN NUMBER,
3573: c_stage_type_code IN VARCHAR2)
3574: IS
3575: SELECT task.visit_task_id, stage.planned_start_date
3576: FROM ahl_visit_stage_typ_asoc assoc, ahl_visit_tasks_b task, ahl_vwp_stages_b stage
3577: WHERE (assoc.stage_id = task.stage_id
3578: OR task.stage_id IS NULL)
3579: AND task.task_type_code = 'STAGE'
3580: AND task.visit_id = c_visit_id