APPS.AHL_VISIT_TYPE_PVT dependencies on AHL_VST_TYP_STG_TYP_ASOC

Line 76: DELETE FROM AHL_VST_TYP_STG_TYP_ASOC

72: -- All the Stages associated to the visit type
73: -- Visit Type record
74:
75: -- Delete Stage Types
76: DELETE FROM AHL_VST_TYP_STG_TYP_ASOC
77: WHERE VISIT_TYPE_STAGE_ID IN (SELECT VISIT_TYPE_STAGE_ID
78: FROM AHL_VISIT_TYPE_STAGES_B AVTSB
79: WHERE VISIT_TYPE_ID = p_visit_type_id);
80:

Line 207: FROM AHL_VST_TYP_STG_TYP_ASOC AVTSTA,

203: -- stages of the visit_type
204: CURSOR count_stage_type(c_visit_type_id IN Number) IS
205: SELECT AVTSB.STAGE_NUMBER,
206: COUNT(VISIT_TYP_STAGE_TYP_ASOC_ID) as Count
207: FROM AHL_VST_TYP_STG_TYP_ASOC AVTSTA,
208: AHL_VISIT_TYPE_STAGES_B AVTSB
209: WHERE AVTSB.VISIT_TYPE_STAGE_ID = AVTSTA.VISIT_TYPE_STAGE_ID(+)
210: AND AVTSB.VISIT_TYPE_ID = c_visit_type_id
211: group by AVTSB.STAGE_NUMBER;

Line 723: AHL_VST_TYP_STG_TYP_ASOC

719:
720: -- Each stage has many stage types associated. So new records are created for them
721: -- Insert into Associated Stage Type table
722: INSERT INTO
723: AHL_VST_TYP_STG_TYP_ASOC
724: (VISIT_TYP_STAGE_TYP_ASOC_ID ,
725: VISIT_TYPE_STAGE_ID ,
726: STAGE_TYPE_CODE ,
727: SECURITY_GROUP_ID ,

Line 751: AHL_VST_TYP_STG_TYP_ASOC_S.nextVal,

747: ATTRIBUTE14 ,
748: ATTRIBUTE15
749: )
750: SELECT
751: AHL_VST_TYP_STG_TYP_ASOC_S.nextVal,
752: L_STAGE_ID ,
753: STAGE_TYPE_CODE ,
754: SECURITY_GROUP_ID ,
755: G_LAST_UPDATE_DATE ,

Line 776: FROM AHL_VST_TYP_STG_TYP_ASOC

772: ATTRIBUTE12 ,
773: ATTRIBUTE13 ,
774: ATTRIBUTE14 ,
775: ATTRIBUTE15
776: FROM AHL_VST_TYP_STG_TYP_ASOC
777: WHERE VISIT_TYPE_STAGE_ID = stage_rec.VISIT_TYPE_STAGE_ID;
778:
779: END LOOP;
780:

Line 944: FROM AHL_VST_TYP_STG_TYP_ASOC STG_TYP, AHL_VISIT_TYPE_STAGES_B STAGES, AHL_VISIT_TYPES_B VST_TYP

940:
941: UNION ALL
942:
943: SELECT MAX(STG_TYP.LAST_UPDATE_DATE) LAST_UPDATE_DATE
944: FROM AHL_VST_TYP_STG_TYP_ASOC STG_TYP, AHL_VISIT_TYPE_STAGES_B STAGES, AHL_VISIT_TYPES_B VST_TYP
945: WHERE VST_TYP.VISIT_TYPE_ID = STAGES.VISIT_TYPE_ID
946: AND STAGES.VISIT_TYPE_STAGE_ID = STG_TYP.VISIT_TYPE_STAGE_ID
947: AND VST_TYP.VISIT_TYPE_ID = C_VISIT_TYPE_ID) QRSLT;
948: