APPS.BSC_COMMON_DIMENSIONS_PVT dependencies on BSC_SYS_COM_DIM_LEVELS

Line 74: FROM bsc_sys_com_dim_levels

70:
71: IF (l_dim_level_id IS NOT NULL AND l_dim_level_index IS NOT NULL) THEN
72:
73: SELECT count(0) INTO l_row_cnt
74: FROM bsc_sys_com_dim_levels
75: WHERE tab_id = p_tab_id
76: AND dim_level_id = l_dim_level_id
77: AND dim_level_index = l_dim_level_index;
78:

Line 104: INTO bsc_sys_com_dim_levels (tab_id, dim_level_index, dim_level_id, parent_level_index, parent_dim_level_id)

100: ,x_parent_level_index => l_parent_level_index
101: );
102:
103: INSERT
104: INTO bsc_sys_com_dim_levels (tab_id, dim_level_index, dim_level_id, parent_level_index, parent_dim_level_id)
105: VALUES(p_tab_id, l_dim_level_index, l_dim_level_id, l_parent_level_index, l_parent_level_id);
106: END IF;
107: END IF;
108: END LOOP;

Line 171: FROM bsc_sys_com_dim_levels

167: x_return_status := FND_API.G_RET_STS_SUCCESS;
168:
169: IF (p_tab_id IS NOT NULL ) THEN
170: DELETE
171: FROM bsc_sys_com_dim_levels
172: WHERE tab_id = p_tab_id;
173:
174: END IF;
175: IF (p_commit = FND_API.G_TRUE) THEN

Line 592: FROM bsc_sys_com_dim_levels

588: IF(p_level_index >0) THEN
589: x_parent_level_index := p_level_index -1;
590: SELECT dim_level_id
591: INTO x_parent_level_id
592: FROM bsc_sys_com_dim_levels
593: WHERE tab_id = p_tab_id
594: AND dim_level_index = x_parent_level_index;
595: END IF;
596: