DBA Data[Home] [Help]

APPS.BIS_POSTACTUAL dependencies on BIS_TARGET_LEVELS

Line 51: FROM bis_target_levels tg

47: -- check if target_level, organization IS valid
48: --
49: SELECT tg.target_level_id
50: INTO l_target_level_id
51: FROM bis_target_levels tg
52: WHERE tg.short_name = x_target_lvl_short_name;
53:
54: IF x_organization_id <> -1 THEN
55: SELECT DISTINCT o.organization_id

Line 200: FROM bis_target_levels_v

196: -- get time_level
197: --
198: SELECT target_level_id, time_level_name
199: INTO l_target_level_id, l_time_level_name
200: FROM bis_target_levels_v
201: WHERE short_name = p_target_lvl_short_name;
202:
203: -- get organization and the start date and end date of the current period
204: --

Line 357: BIS_TARGET_LEVELS TL

353: SELECT sob.period_set_name
354: FROM gl_periods gl,
355: gl_sets_of_books sob,
356: bis_levels l,
357: BIS_TARGET_LEVELS TL
358: WHERE
359: UPPER(TL.short_name) = UPPER(p_target_lvl_short_name)
360: AND TL.time_level_id = l.level_id
361: AND upper(l.short_name) = UPPER(gl.period_type)