APPS.PMI_COMMON_PKG dependencies on BISBV_TARGETS

Line 181: l_target bisbv_targets.TARGET%TYPE;

177: CURSOR cur_target_lvl IS
178: SELECT TARGET_LEVEL_ID
179: FROM bisbv_target_levels
180: WHERE lower(target_level_short_name) = lower(p_target_shortname);
181: l_target bisbv_targets.TARGET%TYPE;
182: l_period_type gl_periods.period_type%type;
183: target_lvl_id bisbv_target_levels.TARGET_LEVEL_ID%TYPE;
184: time_lvl_id bisbv_targets.TIME_LEVEL_VALUE_ID%TYPE;
185: BEGIN

Line 184: time_lvl_id bisbv_targets.TIME_LEVEL_VALUE_ID%TYPE;

180: WHERE lower(target_level_short_name) = lower(p_target_shortname);
181: l_target bisbv_targets.TARGET%TYPE;
182: l_period_type gl_periods.period_type%type;
183: target_lvl_id bisbv_target_levels.TARGET_LEVEL_ID%TYPE;
184: time_lvl_id bisbv_targets.TIME_LEVEL_VALUE_ID%TYPE;
185: BEGIN
186: IF p_param_view_by = 1 THEN
187: IF p_period_num IS NOT NULL AND p_period_num <> 0 THEN
188: BEGIN

Line 226: FROM bisbv_targets

222: CLOSE cur_target_lvl;
223:
224: BEGIN
225: SELECT TARGET INTO l_target
226: FROM bisbv_targets
227: WHERE target_level_id = target_lvl_id and
228: ORG_LEVEL_VALUE_ID = p_ORG_LVL_ID AND
229: PLAN_ID = p_plan_id AND
230: DIM1_LEVEL_VALUE_ID = p_DIM1_LVL_ID AND