APPS.BIS_TARGET_LEVEL_PVT dependencies on BISBV_TARGET_LEVELS

Line 1000: from bisbv_target_levels

996: , COMPUTING_FUNCTION_ID
997: , REPORT_FUNCTION_ID
998: , UNIT_OF_MEASURE
999: , SYSTEM_FLAG
1000: from bisbv_target_levels
1001: where measure_id = l_Measure_id;
1002:
1003: cursor tar_level_fv IS
1004: select TARGET_LEVEL_ID

Line 1284: from bisbv_target_levels

1280: , l_Target_Level_rec.Computing_Function_Id
1281: , l_Target_Level_rec.Report_Function_ID
1282: , l_Target_Level_rec.Unit_Of_Measure
1283: , l_Target_Level_rec.system_flag
1284: from bisbv_target_levels
1285: where target_level_ID = p_Target_Level_rec.Target_Level_ID;
1286: -- 2528450
1287: ELSIF (NOT p_Target_Level_Rec.is_wf_info_needed) THEN
1288: SELECT INDICATOR_ID

Line 3024: FROM bisbv_Target_Levels

3020:
3021: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Short_Name)
3022: = FND_API.G_TRUE) then
3023: SELECT Target_Level_id into x_Target_Level_ID
3024: FROM bisbv_Target_Levels
3025: WHERE target_level_short_name = p_Target_Level_Short_Name;
3026: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Name)
3027: = FND_API.G_TRUE) then
3028: SELECT Target_Level_id into x_Target_Level_ID

Line 3029: FROM bisbv_Target_Levels

3025: WHERE target_level_short_name = p_Target_Level_Short_Name;
3026: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Name)
3027: = FND_API.G_TRUE) then
3028: SELECT Target_Level_id into x_Target_Level_ID
3029: FROM bisbv_Target_Levels
3030: WHERE target_level_name = p_Target_Level_Name;
3031: else
3032: -- POLPULATE ERROR TABLE
3033: --added last two params

Line 3089: , bisbv_target_levels il

3085: CURSOR ind_res IS
3086: select distinct ir.target_level_id, target_level_name
3087: from bis_indicator_resps ir
3088: , fnd_user_resp_groups ur
3089: , bisbv_target_levels il
3090: where ur.user_id = p_user_id
3091: and ir.responsibility_id = ur.responsibility_id
3092: AND ur.start_date <= sysdate
3093: AND nvl(ur.end_date, sysdate) >= sysdate

Line 3313: from bisbv_target_levels

3309: dimension4_level_id,
3310: dimension5_level_id,
3311: dimension6_level_id,
3312: dimension7_level_id
3313: from bisbv_target_levels
3314: where target_level_id = p_target_level_id;
3315:
3316: CURSOR cr_tl_sn_dim_level(p_target_level_short_name VARCHAR2) IS
3317: select

Line 3325: from bisbv_target_levels

3321: dimension4_level_id,
3322: dimension5_level_id,
3323: dimension6_level_id,
3324: dimension7_level_id
3325: from bisbv_target_levels
3326: where target_level_short_name = p_target_level_short_name;
3327:
3328: BEGIN
3329:

Line 3535: from bisbv_target_levels

3531: dimension4_level_id,
3532: dimension5_level_id,
3533: dimension6_level_id,
3534: dimension7_level_id
3535: from bisbv_target_levels
3536: where target_level_id = p_target_level_id;
3537:
3538: CURSOR cr_ol_sn_dim_level(p_target_level_short_name VARCHAR2) IS
3539: select

Line 3547: from bisbv_target_levels

3543: dimension4_level_id,
3544: dimension5_level_id,
3545: dimension6_level_id,
3546: dimension7_level_id
3547: from bisbv_target_levels
3548: where target_level_short_name = p_target_level_short_name;
3549:
3550: BEGIN
3551: