DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_STAGES_PVT dependencies on AHL_MC_HEADERS_B

Line 3155: ahl_mc_headers_B mc, AHL_UNIT_CONFIG_HEADERS unit

3151: --To fetch all the stages associated to the passed visit type code.
3152: CURSOR get_visit_type_stages (p_visit_type_code IN VARCHAR2, p_visit_id IN NUMBER) IS
3153: SELECT distinct stg.visit_type_id, stg.duration, stg.visit_type_stage_id,stg.stage_number, stg.stage_name
3154: FROM ahl_visit_type_stages_vl stg, ahl_visit_types_b vt, ahl_visits_b visit,
3155: ahl_mc_headers_B mc, AHL_UNIT_CONFIG_HEADERS unit
3156: WHERE vt.visit_type_code = p_visit_type_code
3157: AND visit.visit_id = p_visit_id
3158: AND visit.item_instance_id = unit.CSI_ITEM_INSTANCE_ID
3159: AND vt.mc_id = mc.mc_id