APPS.EDW_GL_ACCT_M_T dependencies on EDW_FLEX_SEG_MAPPINGS_V

Line 150: FROM EDW_FLEX_SEG_MAPPINGS_V

146: from edw_segment_classes t1, edw_set_of_books t2
147: where t1.edw_set_of_books_id = t2.edw_set_of_books_id
148: and (t1.segment_name,t2.chart_of_accounts_id,lower(t2.instance)) in
149: (select segment_name,structure_num,lower(instance_code)
150: FROM EDW_FLEX_SEG_MAPPINGS_V
151: WHERE DIMENSION_SHORT_NAME=g_dimension_name);
152: loop
153: l_table_counter :=l_table_counter +1;
154: fetch cur_edw_account_class

Line 1537: FROM EDW_FLEX_SEG_MAPPINGS_V

1533: FROM edw_vbh_roots e1, edw_set_of_books e2
1534: WHERE e1.edw_set_of_books_id=e2.edw_set_of_books_id
1535: and e1.segment_name =(
1536: select segment_name
1537: FROM EDW_FLEX_SEG_MAPPINGS_V
1538: WHERE DIMENSION_SHORT_NAME=g_dimension_name
1539: and structure_num=e2.chart_of_accounts_id
1540: and lower(instance_code)=lower(e2.instance));
1541: LOOP