DBA Data[Home] [Help]

APPS.BIS_PORTLET_PMREGION dependencies on BISBV_TARGET_LEVELS

Line 1069: ,bisbv_target_levels d --1850860

1065: ,c.comparison_source --2157402
1066: ,c.indicator_id --2174470
1067: FROM bis_user_ind_selections a
1068: ,bis_indicators c --1850860
1069: ,bisbv_target_levels d --1850860
1070: WHERE a.plug_id = p_plug_id -- most selective first
1071: AND a.user_id = l_user_id
1072: AND d.target_level_id = a.target_level_id --1850860
1073: AND d.measure_id = c.indicator_id --1850860

Line 4306: -- FROM BISBV_TARGET_LEVELS

4302: -- to paint at the top of the page
4303: -- mdamle 01/15/2001 - Use getPerformanceMeasureName() instead
4304: -- SELECT target_level_name
4305: -- INTO l_indlevel_name
4306: -- FROM BISBV_TARGET_LEVELS
4307: -- WHERE TARGET_LEVEL_ID = l_indlevel_id;
4308: l_indlevel_name := BIS_INDICATOR_REGION_UI_PVT.getPerformanceMeasureName(l_indlevel_id);
4309:
4310: -- Set the set of books id for GL dimension levels

Line 7171: FROM bisbv_target_levels

7167:
7168: -- Cursor to get the computing function id
7169: CURSOR c_comp_tar (p_target_level_id pls_integer) IS
7170: SELECT computing_function_id
7171: FROM bisbv_target_levels
7172: WHERE target_level_id = p_target_level_id;
7173:
7174:
7175: -- Cursor to get the target ranges