APPS.BIS_INDICATOR_REGION_UI_PVT dependencies on BISBV_TARGET_LEVELS

Line 870: ,bisbv_target_levels d

866: ,c.indicator_id
867: FROM bis_user_ind_selections a
868: ,fnd_user_resp_groups b
869: ,bis_indicators c
870: ,bisbv_target_levels d
871: WHERE a.user_id = g_user_id
872: AND a.plug_id = p_plug_id
873: AND a.user_id = b.user_id
874: AND b.start_date <= sysdate

Line 3652: -- FROM BISBV_TARGET_LEVELS

3648: -- to paint at the top of the page
3649: -- mdamle 01/15/2001 - Use getPerformanceMeasureName() instead
3650: -- SELECT target_level_name
3651: -- INTO l_indlevel_name
3652: -- FROM BISBV_TARGET_LEVELS
3653: -- WHERE TARGET_LEVEL_ID = l_indlevel_id;
3654: l_indlevel_name := getPerformanceMeasureName(l_indlevel_id);
3655:
3656: -- Set the set of books id for GL dimension levels

Line 5393: FROM bisbv_target_levels tlv, bis_levels blv

5389:
5390: CURSOR cur_notimelvl (p_tarid IN PLS_INTEGER)
5391: IS
5392: SELECT tlv.target_level_id
5393: FROM bisbv_target_levels tlv, bis_levels blv
5394: WHERE tlv.target_level_id = p_tarid
5395: AND (
5396: tlv.dimension1_level_id = blv.level_id
5397: OR tlv.dimension2_level_id = blv.level_id

Line 5465: FROM bisbv_target_levels

5461:
5462: CURSOR cur_compute_tar
5463: IS
5464: SELECT computing_function_id
5465: FROM bisbv_target_levels
5466: WHERE target_level_id = p_target_level_id;
5467:
5468: rec_compute_tar cur_compute_tar%ROWTYPE;
5469: BEGIN

Line 7179: ,bisbv_target_levels d

7175: CURSOR c1 IS
7176: SELECT distinct DECODE(b.user_id, NULL, 0, 1)
7177: FROM
7178: fnd_user_resp_groups b
7179: ,bisbv_target_levels d
7180: ,bis_indicator_resps e
7181: WHERE
7182: b.user_id = p_cur_user_id
7183: AND d.target_level_id = p_target_level_id

Line 7299: FROM bisbv_target_levels

7295:
7296: -- Cursor to get the computing function id
7297: CURSOR c_comp_tar (p_target_level_id pls_integer) IS
7298: SELECT computing_function_id
7299: FROM bisbv_target_levels
7300: WHERE target_level_id = p_target_level_id;
7301:
7302:
7303: -- Cursor to get the target ranges