APPS.GL_JAHE_PKG dependencies on GL_AHE_DETAIL_RANGES_GT

Line 274: from gl_ahe_detail_ranges_gt

270: has_value NUMBER := null; -- 1 if there are flex values between ranges
271: -- cursor for fetching current ranges
272: CURSOR child_range (parent VARCHAR2) IS
273: SELECT child_flex_value_low, child_flex_value_high
274: from gl_ahe_detail_ranges_gt
275: where parent_flex_value = parent
276: and status = 'C'
277: order by child_flex_value_low, child_flex_value_high;
278: BEGIN

Line 304: INSERT INTO gl_ahe_detail_ranges_gt

300: AND flex_value < low
301: AND rownum <= 1;
302:
303: -- no exception => found values in between => end of merge
304: INSERT INTO gl_ahe_detail_ranges_gt
305: (parent_flex_value,
306: child_flex_value_low,
307: child_flex_value_high,
308: status)

Line 321: INSERT INTO gl_ahe_detail_ranges_gt

317: end;
318: has_value := null;
319: END IF;
320: END LOOP;
321: INSERT INTO gl_ahe_detail_ranges_gt
322: (parent_flex_value,
323: child_flex_value_low,
324: child_flex_value_high,
325: status)