APPS.PMI_COMMON_PKG dependencies on BISBV_TARGET_LEVELS

Line 179: FROM bisbv_target_levels

175: RETURN NUMBER IS
176:
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;

Line 183: target_lvl_id bisbv_target_levels.TARGET_LEVEL_ID%TYPE;

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
186: IF p_param_view_by = 1 THEN
187: IF p_period_num IS NOT NULL AND p_period_num <> 0 THEN