DBA Data[Home] [Help]

APPS.BIS_UTIL dependencies on BIS_LEVELS_TL

Line 1195: ELSIF ( UPPER(p_table_name) = 'BIS_LEVELS_TL') THEN

1191: WHERE dim.short_name = p_key_value
1192: AND dim_tl.dimension_id = dim.dimension_id
1193: AND dim_tl.language = USERENV('LANG');
1194:
1195: ELSIF ( UPPER(p_table_name) = 'BIS_LEVELS_TL') THEN
1196: SELECT lev_tl.last_update_date, lev_tl.last_updated_by INTO l_db_last_update_date, l_db_last_updated_by
1197: FROM bis_levels_tl lev_tl, bis_levels lev
1198: WHERE lev.short_name = p_key_value
1199: AND lev.level_id = lev_tl.level_id

Line 1197: FROM bis_levels_tl lev_tl, bis_levels lev

1193: AND dim_tl.language = USERENV('LANG');
1194:
1195: ELSIF ( UPPER(p_table_name) = 'BIS_LEVELS_TL') THEN
1196: SELECT lev_tl.last_update_date, lev_tl.last_updated_by INTO l_db_last_update_date, l_db_last_updated_by
1197: FROM bis_levels_tl lev_tl, bis_levels lev
1198: WHERE lev.short_name = p_key_value
1199: AND lev.level_id = lev_tl.level_id
1200: AND USERENV('LANG') = lev_tl.language;
1201: