APPS.EDW_VBH_SETUP dependencies on EDW_CONS_SET_OF_BOOKS

Line 42: delete from edw_cons_set_of_books;

38: begin
39: l_stmt:='alter session set global_names = FALSE';
40: execute immediate l_stmt;
41: delete from edw_set_of_books;
42: delete from edw_cons_set_of_books;
43: delete from edw_equi_set_of_books;
44: delete from edw_vbh_roots;
45: delete from edw_segment_classes;
46: open l_source_instances_cur;

Line 203: from edw_cons_set_of_books';

199: CREATED_BY,
200: LAST_UPDATE_DATE,
201: LAST_UPDATED_BY ,
202: LAST_UPDATE_LOGIN
203: from edw_cons_set_of_books';
204: DBMS_SQL.parse(l_insert_cursor_id,l_insert_stmt,DBMS_SQL.V7);
205: l_rows_inserted:=DBMS_SQL.execute(l_insert_cursor_id);
206: commit;
207: DBMS_SQL.close_cursor(l_insert_cursor_id);

Line 650: from edw_cons_set_of_books

646: edw_vbh_setup.LOOKUP_DB_LINK(p_instance,l_status,l_err_msg,l_db_link);
647: open l_cur_edw_cons for
648: select parent_edw_set_of_books_id, child_edw_set_of_books_id,
649: consolidation_id
650: from edw_cons_set_of_books
651: where child_edw_set_of_books_id
652: in (select edw_set_of_books_id from edw_vbh_roots where segment_name=p_segment_name)
653: and parent_edw_set_of_books_id=p_edw_sob_id;
654:

Line 715: from edw_cons_set_of_books

711: close l_cur_edw_cons;
712:
713: open l_cur_edw_cons for
714: select parent_edw_set_of_books_id,child_edw_set_of_books_id,consolidation_id
715: from edw_cons_set_of_books
716: where parent_edw_set_of_books_id in (select edw_set_of_books_id from edw_vbh_roots where segment_name=p_segment_name)
717: and child_edw_set_of_books_id =p_edw_sob_id;
718: loop
719: fetch l_cur_edw_cons into l_parent_edw_sob_id,l_child_edw_sob_id,l_consolidation_id;