APPS.BSC_MO_INDICATOR_PKG dependencies on BSC_IM_UTILS

Line 405: if bsc_im_utils.is_column_in_object(l_join_dimensions(i), 'LANGUAGE') then

401: IF (b_dimensions_joined) THEN
402: get_join_info(p_keys, l_zmv_keys, p_zero_code_states, p_dimensions, l_join_dimensions, l_join_parents, l_join_dimensions_fk, l_zmv_fk);
403: FOR i IN l_join_dimensions.first..l_join_dimensions.last LOOP
404: l_from_clause := l_from_clause || ' '||l_join_dimensions(i)||' '||l_join_dimensions(i)||',';
405: if bsc_im_utils.is_column_in_object(l_join_dimensions(i), 'LANGUAGE') then
406: l_where_clause := l_where_clause||l_join_dimensions(i)||'.language='''||BSC_IM_UTILS.get_lang||''''||' AND ';
407: end if;
408: END LOOP;
409: -- add rest of the joins

Line 406: l_where_clause := l_where_clause||l_join_dimensions(i)||'.language='''||BSC_IM_UTILS.get_lang||''''||' AND ';

402: get_join_info(p_keys, l_zmv_keys, p_zero_code_states, p_dimensions, l_join_dimensions, l_join_parents, l_join_dimensions_fk, l_zmv_fk);
403: FOR i IN l_join_dimensions.first..l_join_dimensions.last LOOP
404: l_from_clause := l_from_clause || ' '||l_join_dimensions(i)||' '||l_join_dimensions(i)||',';
405: if bsc_im_utils.is_column_in_object(l_join_dimensions(i), 'LANGUAGE') then
406: l_where_clause := l_where_clause||l_join_dimensions(i)||'.language='''||BSC_IM_UTILS.get_lang||''''||' AND ';
407: end if;
408: END LOOP;
409: -- add rest of the joins
410: FOR i IN l_join_dimensions.first..l_join_dimensions.last-1 LOOP