DBA Data[Home] [Help]

APPS.BIS_PORTLET_PMREGION dependencies on BIS_TARGET_LEVELS

Line 4321: FROM BIS_TARGET_LEVELS

4317: -- mdamle 01/15/2001 - Use Dim6 and Dim7
4318: /*
4319: SELECT org_level_id
4320: INTO l_org_level_id
4321: FROM BIS_TARGET_LEVELS
4322: WHERE target_level_id = l_indlevel_ID;
4323:
4324: l_org_level_id := BIS_INDICATOR_REGION_UI_PVT.getOrgLevelID(l_indlevel_id);
4325:

Line 6205: , bis_target_levels bt

6201: , bp.SHORT_NAME
6202: , bu.LABEL
6203: FROM
6204: bis_user_ind_selections bu
6205: , bis_target_levels bt
6206: , BISBV_BUSINESS_PLANS bp
6207: WHERE
6208: bu.IND_SELECTION_ID = p_ind_sel
6209: AND bu.TARGET_LEVEL_ID = bt.TARGET_LEVEL_ID

Line 7302: ,bis_target_levels z

7298: NULL) time_dimension_level_id
7299: FROM
7300: bis_indicator_dimensions x
7301: ,bis_dimensions y
7302: ,bis_target_levels z
7303: WHERE x.dimension_id = y.dimension_id
7304: AND y.short_name=BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_tarid,NULL)
7305: AND x.indicator_id = z.indicator_id
7306: AND z.target_level_id = p_tarid;