APPS.EDW_GL_ACCT_M_T dependencies on EDW_VBH_ROOTS

Line 906: from edw_vbh_roots)

902: select *
903: from edw_set_of_books
904: where edw_set_of_books_id not in (
905: select edw_set_of_books_id
906: from edw_vbh_roots)
907: and edw_set_of_books_id not in (
908: select edw_set_of_books_id
909: from edw_equi_set_of_books)
910: and edw_set_of_books_id not in (

Line 1329: Type t_vbh_root_table is table of edw_vbh_roots.root_value1%type

1325: type edw_gl_acct1_m.l1_type%TYPE,
1326: description edw_gl_acct1_m.l1_description%TYPE);
1327: l_root_value_desc_pair t_value_desc_pair_rec;
1328:
1329: Type t_vbh_root_table is table of edw_vbh_roots.root_value1%type
1330: index by binary_integer;
1331: l_vbh_root_table t_vbh_root_table;
1332:
1333:

Line 1334: l_vbh_root_sob_id edw_vbh_roots.edw_set_of_books_id%TYPE ;

1330: index by binary_integer;
1331: l_vbh_root_table t_vbh_root_table;
1332:
1333:
1334: l_vbh_root_sob_id edw_vbh_roots.edw_set_of_books_id%TYPE ;
1335:
1336: TYPE t_cur_vbh_root_ref IS REF CURSOR;
1337: cur_vbh_roots t_cur_vbh_root_ref;
1338:

Line 1533: FROM edw_vbh_roots e1, edw_set_of_books e2

1529: setTimer(l_roots_timestamp);
1530: OPEN cur_vbh_roots for
1531: SELECT distinct e1.edw_set_of_books_id,e1.root_value1,e1.root_value2,
1532: e1.root_value3,e1.root_value4
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