APPS.BSC_KPI_PVT dependencies on BSC_SYS_IMAGES

Line 7350: FROM bsc_sys_images

7346: RAISE FND_API.G_EXC_ERROR;
7347: END IF;
7348:
7349: DELETE
7350: FROM bsc_sys_images
7351: WHERE image_id IN (
7352: SELECT image_id
7353: FROM bsc_kpi_graphs
7354: WHERE indicator =p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id

Line 7842: FROM BSC_SYS_IMAGES

7838: l_short_name BSC_KPIS_VL.short_name%TYPE;
7839:
7840: CURSOR c_sys_images IS
7841: SELECT image_id
7842: FROM BSC_SYS_IMAGES
7843: WHERE image_id NOT IN
7844: ( SELECT DISTINCT(image_id)
7845: FROM BSC_SYS_IMAGES_MAP_TL
7846: );

Line 7845: FROM BSC_SYS_IMAGES_MAP_TL

7841: SELECT image_id
7842: FROM BSC_SYS_IMAGES
7843: WHERE image_id NOT IN
7844: ( SELECT DISTINCT(image_id)
7845: FROM BSC_SYS_IMAGES_MAP_TL
7846: );
7847:
7848: BEGIN
7849: FND_MSG_PUB.Initialize;

Line 7900: FROM BSC_SYS_IMAGES_MAP_TL

7896: AND tab_view_id = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7897:
7898:
7899: DELETE
7900: FROM BSC_SYS_IMAGES_MAP_TL
7901: WHERE SOURCE_TYPE = 2
7902: AND SOURCE_CODE = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
7903: AND TYPE = BSC_SIMULATION_VIEW_PUB.c_TYPE;
7904:

Line 7912: FROM BSC_SYS_IMAGES

7908: FOR cd IN c_sys_images LOOP
7909: l_CustView_Rec.Bsc_Image_Id := cd.image_id;
7910:
7911: DELETE
7912: FROM BSC_SYS_IMAGES
7913: WHERE IMAGE_ID = l_CustView_Rec.Bsc_Image_Id;
7914:
7915: END LOOP;
7916: