APPS.FII_FLEX_MAPPING dependencies on EDW_LOCAL_SET_OF_BOOKS

Line 15: /* EDW_LOCAL_SET_OF_BOOKS cache */

11: g_mc_current_structure_id number(15) := -1;
12: g_mc_current_structure varchar2(20) := null;
13:
14: /***********************************************************/
15: /* EDW_LOCAL_SET_OF_BOOKS cache */
16: /***********************************************************/
17: type valid_set_of_books_cache is table
18: of varchar2(40)
19: index by binary_integer;

Line 219: from edw_local_set_of_books loc,

215: select loc.set_of_books_id loc_sob,
216: equi.equi_set_of_books_id equi_sob,
217: parent.set_of_books_id parent_sob,
218: parent.instance parent_instance
219: from edw_local_set_of_books loc,
220: edw_local_equi_set_of_books equi,
221: edw_local_set_of_books parent
222: where loc.instance = g_local_instance
223: and equi.edw_set_of_books_id (+) = loc.edw_set_of_books_id

Line 221: edw_local_set_of_books parent

217: parent.set_of_books_id parent_sob,
218: parent.instance parent_instance
219: from edw_local_set_of_books loc,
220: edw_local_equi_set_of_books equi,
221: edw_local_set_of_books parent
222: where loc.instance = g_local_instance
223: and equi.edw_set_of_books_id (+) = loc.edw_set_of_books_id
224: and parent.edw_set_of_books_id (+) = equi.equi_set_of_books_id;
225: