APPS.BSC_DIMENSION_LEVELS_PUB dependencies on BSC_SYS_DIM_LEVEL_RELS_V

Line 1310: from BSC_SYS_DIM_LEVEL_RELS_V

1306: ) IS
1307:
1308: CURSOR c_parents IS
1309: Select PARENT_SHORT_NAME
1310: from BSC_SYS_DIM_LEVEL_RELS_V
1311: where SHORT_NAME = UPPER(p_child_dim_level_short_name);
1312:
1313: v_parent varchar2(50);
1314: v_count number;

Line 1322: from BSC_SYS_DIM_LEVEL_RELS_V

1318: x_return_value := FND_API.G_FALSE;
1319:
1320: Select COUNT(1)
1321: into v_count
1322: from BSC_SYS_DIM_LEVEL_RELS_V
1323: where SHORT_NAME = UPPER(p_child_dim_level_short_name)
1324: and PARENT_SHORT_NAME = UPPER(p_parent_dim_level_short_name);
1325:
1326: if v_count <> 0 then

Line 1403: from BSC_SYS_DIM_LEVEL_RELS_V

1399: ) IS
1400:
1401: CURSOR c_parents IS
1402: Select PARENT_SHORT_NAME
1403: from BSC_SYS_DIM_LEVEL_RELS_V
1404: where SHORT_NAME = UPPER(p_child_dim_level_short_name);
1405:
1406: v_parent varchar2(50);
1407:

Line 1483: from BSC_SYS_DIM_LEVEL_RELS_V

1479: ,x_msg_data OUT NOCOPY varchar2
1480: ) IS
1481: CURSOR c_childs IS
1482: Select SHORT_NAME
1483: from BSC_SYS_DIM_LEVEL_RELS_V
1484: where PARENT_SHORT_NAME = UPPER(p_parent_dim_level_short_name);
1485:
1486: v_child varchar2(50);
1487:

Line 1572: FROM BSC_SYS_DIM_LEVEL_RELS_V

1568: x_return_status := FND_API.G_RET_STS_SUCCESS;
1569:
1570: SELECT COUNT(DIM_LEVEL_ID)
1571: INTO l_count
1572: FROM BSC_SYS_DIM_LEVEL_RELS_V
1573: WHERE SHORT_NAME = p_child_dim_level_short_name
1574: AND PARENT_SHORT_NAME = p_parent_dim_level_short_name ;
1575:
1576: IF (l_count <> 0) THEN