APPS.PMI_COMMON_PKG dependencies on GL_PERIODS

Line 182: l_period_type gl_periods.period_type%type;

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
186: IF p_param_view_by = 1 THEN

Line 190: FROM gl_periods

186: IF p_param_view_by = 1 THEN
187: IF p_period_num IS NOT NULL AND p_period_num <> 0 THEN
188: BEGIN
189: SELECT p_period_set_name || '+' || period_name INTO time_lvl_id
190: FROM gl_periods
191: WHERE period_type = p_period_type AND
192: period_set_name = p_period_set_name AND
193: start_Date BETWEEN p_from_date AND p_to_date AND
194: period_num = p_period_num AND

Line 205: FROM gl_periods

201: END IF;
202: ELSE
203: BEGIN
204: SELECT p_period_set_name || '+' || period_name INTO time_lvl_id
205: FROM gl_periods
206: WHERE period_type = p_period_type AND
207: period_set_name = p_period_set_name AND
208: start_Date BETWEEN p_from_date AND p_to_date AND
209: ADJUSTMENT_PERIOD_FLAG <> 'Y' ;