APPS.BIS_UTIL dependencies on BIS_DIMENSIONS

Line 1183: IF ( UPPER(p_table_name) = 'BIS_DIMENSIONS') THEN

1179: END IF;
1180:
1181: --Using static sql's becoz dynamic sql's has performance impact
1182:
1183: IF ( UPPER(p_table_name) = 'BIS_DIMENSIONS') THEN
1184: SELECT last_update_date, last_updated_by INTO l_db_last_update_date, l_db_last_updated_by
1185: FROM bis_dimensions
1186: WHERE short_name = p_key_value;
1187:

Line 1185: FROM bis_dimensions

1181: --Using static sql's becoz dynamic sql's has performance impact
1182:
1183: IF ( UPPER(p_table_name) = 'BIS_DIMENSIONS') THEN
1184: SELECT last_update_date, last_updated_by INTO l_db_last_update_date, l_db_last_updated_by
1185: FROM bis_dimensions
1186: WHERE short_name = p_key_value;
1187:
1188: ELSIF ( UPPER(p_table_name) = 'BIS_DIMENSIONS_TL') THEN
1189: SELECT dim_tl.last_update_date, dim_tl.last_updated_by INTO l_db_last_update_date, l_db_last_updated_by

Line 1188: ELSIF ( UPPER(p_table_name) = 'BIS_DIMENSIONS_TL') THEN

1184: SELECT last_update_date, last_updated_by INTO l_db_last_update_date, l_db_last_updated_by
1185: FROM bis_dimensions
1186: WHERE short_name = p_key_value;
1187:
1188: ELSIF ( UPPER(p_table_name) = 'BIS_DIMENSIONS_TL') THEN
1189: SELECT dim_tl.last_update_date, dim_tl.last_updated_by INTO l_db_last_update_date, l_db_last_updated_by
1190: FROM bis_dimensions_tl dim_tl, bis_dimensions dim
1191: WHERE dim.short_name = p_key_value
1192: AND dim_tl.dimension_id = dim.dimension_id

Line 1190: FROM bis_dimensions_tl dim_tl, bis_dimensions dim

1186: WHERE short_name = p_key_value;
1187:
1188: ELSIF ( UPPER(p_table_name) = 'BIS_DIMENSIONS_TL') THEN
1189: SELECT dim_tl.last_update_date, dim_tl.last_updated_by INTO l_db_last_update_date, l_db_last_updated_by
1190: FROM bis_dimensions_tl dim_tl, bis_dimensions dim
1191: WHERE dim.short_name = p_key_value
1192: AND dim_tl.dimension_id = dim.dimension_id
1193: AND dim_tl.language = USERENV('LANG');
1194:

Line 1270: FROM bis_dimensions bis_dim, bsc_sys_dim_groups_vl bsc_dim, bis_levels_vl bis_lvl, bsc_sys_dim_levels_b bsc_lvl, bsc_sys_dim_levels_by_group lvl_by_grp

1266: c_dim_object_rec refCursorType;
1267:
1268: l_dim_objects_sql VARCHAR2(1000) :=
1269: 'SELECT bis_lvl.short_name, bis_lvl.name
1270: FROM bis_dimensions bis_dim, bsc_sys_dim_groups_vl bsc_dim, bis_levels_vl bis_lvl, bsc_sys_dim_levels_b bsc_lvl, bsc_sys_dim_levels_by_group lvl_by_grp
1271: WHERE bis_dim.dim_grp_id = bsc_dim.dim_group_id
1272: AND bis_lvl.short_name = bsc_lvl.short_name
1273: AND bsc_dim.dim_group_id = lvl_by_grp.dim_group_id
1274: AND bsc_lvl.dim_level_id = lvl_by_grp.dim_level_id

Line 1535: FROM bsc_sys_dim_levels_b bsc_lvl, bis_dimensions bis_dim, bsc_sys_dim_levels_by_group lvl_by_grp

1531: l_view_name_rec c_view_name%ROWTYPE;
1532:
1533: CURSOR c_all_enabled IS
1534: SELECT total_flag
1535: FROM bsc_sys_dim_levels_b bsc_lvl, bis_dimensions bis_dim, bsc_sys_dim_levels_by_group lvl_by_grp
1536: WHERE bsc_lvl.dim_level_id = lvl_by_grp.dim_level_id
1537: AND bis_dim.dim_grp_id = lvl_by_grp.dim_group_id
1538: AND bsc_lvl.short_name = p_dim_object
1539: AND bis_dim.short_name = p_dimension;

Line 1699: l_dimension BIS_DIMENSIONS.SHORT_NAME%TYPE;

1695: l_return_status VARCHAR2(10);
1696: l_msg_count NUMBER;
1697: l_msg_data VARCHAR2(255);
1698: l_Dim_Value VARCHAR(1000) := NULL;
1699: l_dimension BIS_DIMENSIONS.SHORT_NAME%TYPE;
1700:
1701: BEGIN
1702:
1703: BIS_PMV_BSC_API_PUB.Get_DimLevel_Viewby(

Line 2451: FROM bsc_sys_dim_groups_vl sys_dim_group, bsc_sys_dim_levels_vl sys_dim_levels, bsc_sys_dim_levels_by_group sys_dim_level_group, bis_levels bis_level, bis_dimensions bis_dim

2447: l_num NUMBER;
2448:
2449: CURSOR c_dim_plus_dimlevel_rel_cursor(l_dim VARCHAR2, l_dim_level VARCHAR2) IS
2450: SELECT 1
2451: FROM bsc_sys_dim_groups_vl sys_dim_group, bsc_sys_dim_levels_vl sys_dim_levels, bsc_sys_dim_levels_by_group sys_dim_level_group, bis_levels bis_level, bis_dimensions bis_dim
2452: WHERE sys_dim_group.dim_group_id = sys_dim_level_group.dim_group_id
2453: AND sys_dim_levels.dim_level_id = sys_dim_level_group.dim_level_id
2454: AND sys_dim_group.dim_group_id = bis_dim.dim_grp_id
2455: AND sys_dim_levels.short_name = bis_level.short_name