APPS.AHL_VISIT_TYPE_PVT dependencies on AHL_VISIT_TYPES_TL

Line 101: DELETE FROM AHL_VISIT_TYPES_TL

97: DELETE FROM AHL_VISIT_TYPE_STAGES_B
98: WHERE VISIT_TYPE_ID = p_visit_type_id;
99:
100: -- Delete Visit Types from TL
101: DELETE FROM AHL_VISIT_TYPES_TL
102: WHERE VISIT_TYPE_ID = p_visit_type_id;
103:
104: -- Delete Visit Types
105: DELETE FROM AHL_VISIT_TYPES_B

Line 587: AHL_VISIT_TYPES_TL

583: WHERE VISIT_TYPE_ID = p_par_visit_type_id;
584:
585: -- Insert Into Visit Type _TL table
586: INSERT INTO
587: AHL_VISIT_TYPES_TL
588: (VISIT_TYPE_ID ,
589: DESCRIPTION ,
590: LANGUAGE ,
591: SOURCE_LANG ,

Line 610: FROM AHL_VISIT_TYPES_TL

606: G_LAST_UPDATED_BY ,
607: G_CREATION_DATE ,
608: G_CREATED_BY ,
609: G_LAST_UPDATE_LOGIN
610: FROM AHL_VISIT_TYPES_TL
611: WHERE visit_type_id = p_par_visit_type_id;
612:
613: /* MANESING::Component Maintenance Planning Project, 05-Jul-2011, following insertions to Stage related
614: * tables are not needed for Component Visit Types as there won't be any Stage associated with them.