APPS.AHL_VWP_VISITS_STAGES_PVT dependencies on AHL_VISITS_B

Line 884: SELECT status_code FROM AHL_VISITS_B

880: l_planned_order_flag VARCHAR2(1);
881: l_is_old_visit VARCHAR2(1) := 'N';--VWPE 12730539:: PRAKKUM :: 08-JUL-2011
882:
883: CURSOR c_check_visit_status(C_VISIT_ID NUMBER) IS
884: SELECT status_code FROM AHL_VISITS_B
885: WHERE VISIT_ID = C_VISIT_ID
886: AND STATUS_CODE IN ('DRAFT','PLANNING', 'PARTIALLY RELEASED', 'RELEASED' );
887:
888: -- Commented based on review comments

Line 917: FROM AHL_VISITS_B

913: -- To find visit related information
914: CURSOR c_visit (c_visit_id IN NUMBER)
915: IS
916: SELECT START_DATE_TIME , department_id, AHL_VWP_VISITS_PVT.Is_Old_Visit(VISIT_ID) IS_OLD_VISIT
917: FROM AHL_VISITS_B
918: WHERE VISIT_ID = c_visit_id;--VWPE 12730539:: PRAKKUM :: 08-JUL-2011
919:
920: l_visit_dets c_visit%RowType;
921:

Line 1387: FROM AHL_VISITS_B

1383: -- To find visit related information
1384: CURSOR c_visit (c_visit_id IN NUMBER)
1385: IS
1386: SELECT AHL_VWP_VISITS_PVT.Is_Old_Visit(VISIT_ID) IS_OLD_VISIT
1387: FROM AHL_VISITS_B
1388: WHERE VISIT_ID = c_visit_id;
1389:
1390: l_visit_dets c_visit%RowType;
1391:

Line 3154: FROM ahl_visit_type_stages_vl stg, ahl_visit_types_b vt, ahl_visits_b visit,

3150:
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

Line 4128: from AHL_VISITS_B VST, AHL_VWP_STAGES_B STG

4124: SELECT VST.VISIT_ID,STAGE_ID,
4125: VST.department_id DEPT_ID, nvl(STG.duration,0) DURATION,
4126: CASE WHEN nvl(VST.start_date_time,STG.earliest_start_date) >= nvl(STG.earliest_start_date,VST.start_date_time)
4127: THEN VST.start_date_time ELSE STG.earliest_start_date END MAX_START_DATE
4128: from AHL_VISITS_B VST, AHL_VWP_STAGES_B STG
4129: WHERE VST.VISIT_ID = STG.VISIT_ID
4130: AND VST.VISIT_ID = vst_id
4131: AND STG.STAGE_ID = stg_id;
4132:

Line 6185: FROM ahl_visits_b vst,

6181:
6182: --To get invalid stages whose end date falls beyond visit end date
6183: CURSOR get_invalid_stages(c_visit_id IN NUMBER) IS
6184: SELECT stg.stage_id,stg.stage_num,stg.planned_end_date,vst.close_date_time
6185: FROM ahl_visits_b vst,
6186: ahl_vwp_stages_b stg
6187: WHERE vst.visit_id = stg.visit_id
6188: AND TRUNC(stg.planned_end_date,'MI') > TRUNC(nvl(vst.close_date_time,stg.planned_end_date),'MI')
6189: AND vst.visit_id = c_visit_id

Line 6309: SELECT VISIT_ID, UNIT_SCHEDULE_ID FROM AHL_VISITS_B

6305: -- However this calculation won't consider dept. shifts or holidays in to account. So to keep things consistent, stage dates calc. also won't consider dept. shifts or holidays
6306: -- into account.
6307: --
6308: CURSOR GET_VISIT_DETS ( C_VISIT_ID IN NUMBER ) IS
6309: SELECT VISIT_ID, UNIT_SCHEDULE_ID FROM AHL_VISITS_B
6310: WHERE VISIT_ID = C_VISIT_ID;
6311:
6312: l_visit_dets_rec GET_VISIT_DETS%RowType;
6313: