DBA Data[Home] [Help]

APPS.AHL_VWP_RULES_PVT dependencies on AHL_VISIT_STAGE_TYP_ASOC

Line 1184: FROM ahl_mr_routes mr, ahl_visit_stage_typ_asoc assoc, ahl_vwp_stages_b stage

1180: --VWP ER-12424063:: tchimira :: 17-FEB -2011 :: start
1181: -- cursor to fetch the stage_id of the stage, which has stage type associated that matches with the stage type of the passed task's route-MR association.
1182: CURSOR c_stage_id (c_visit_id IN NUMBER, c_mr_route_id IN NUMBER) IS
1183: SELECT stage.stage_id
1184: FROM ahl_mr_routes mr, ahl_visit_stage_typ_asoc assoc, ahl_vwp_stages_b stage
1185: WHERE assoc.stage_id = stage.stage_id
1186: AND stage.visit_id = c_visit_id
1187: AND assoc.stage_type_code = mr.stage_type_code
1188: AND mr.mr_route_id = c_mr_route_id