APPS.AHL_VISIT_TYPE_PVT dependencies on AHL_VISIT_TYPE_STAGES_TL

Line 91: DELETE FROM AHL_VISIT_TYPE_STAGES_TL

87: FROM AHL_VISIT_TYPE_STAGES_B AVTSB
88: WHERE VISIT_TYPE_ID = p_visit_type_id);
89:
90: -- Delete Stages from TL
91: DELETE FROM AHL_VISIT_TYPE_STAGES_TL
92: WHERE VISIT_TYPE_STAGE_ID IN (SELECT VISIT_TYPE_STAGE_ID
93: FROM AHL_VISIT_TYPE_STAGES_B AVTSB
94: WHERE VISIT_TYPE_ID = p_visit_type_id);
95:

Line 694: AHL_VISIT_TYPE_STAGES_TL

690: WHERE VISIT_TYPE_STAGE_ID = stage_rec.VISIT_TYPE_STAGE_ID;
691:
692: -- Insert into Stages _TL table
693: INSERT INTO
694: AHL_VISIT_TYPE_STAGES_TL
695: (VISIT_TYPE_STAGE_ID ,
696: STAGE_NAME ,
697: LANGUAGE ,
698: SOURCE_LANG ,

Line 717: FROM AHL_VISIT_TYPE_STAGES_TL

713: G_LAST_UPDATED_BY ,
714: G_CREATION_DATE ,
715: G_CREATED_BY ,
716: G_LAST_UPDATE_LOGIN
717: FROM AHL_VISIT_TYPE_STAGES_TL
718: WHERE VISIT_TYPE_STAGE_ID = stage_rec.VISIT_TYPE_STAGE_ID;
719:
720: -- Each stage has many stage types associated. So new records are created for them
721: -- Insert into Associated Stage Type table