APPS.EDW_TIME_PKG dependencies on EDW_LOCAL_INSTANCE

Line 22: from edw_local_instance ins,

18: cursor c1 is
19: select ins.instance_code,
20: sob.accounted_period_type,
21: sob.period_set_name
22: from edw_local_instance ins,
23: gl_sets_of_books sob
24: where set_of_books_id = p_set_of_books_id;
25:
26: begin

Line 88: from edw_local_instance ins,

84:
85: cursor c1 is
86: select ins.instance_code,
87: sob.period_set_name
88: from edw_local_instance ins,
89: gl_sets_of_books sob
90: where set_of_books_id = p_set_of_books_id;
91:
92: begin

Line 149: from edw_local_instance ins,

145: cursor c1 is
146: select ins.instance_code,
147: maps.period_set_name,
148: maps.period_name
149: from edw_local_instance ins,
150: gl_sets_of_books sob,
151: gl_date_period_map maps
152: where maps.period_set_name = sob.period_set_name
153: and maps.period_type = sob.accounted_period_type

Line 213: from edw_local_instance ins,

209: cursor c1 is
210: select ins.instance_code,
211: gl.period_set_name,
212: imp.pa_period_type
213: from edw_local_instance ins,
214: pa_implementations_all imp,
215: gl_sets_of_books gl
216: where imp.org_id = p_org_id
217: and gl.set_of_books_id = imp.set_of_books_id;

Line 224: from edw_local_instance ins,

220: cursor c2 is
221: select ins.instance_code,
222: gl.period_set_name,
223: imp.pa_period_type
224: from edw_local_instance ins,
225: pa_implementations_all imp,
226: gl_sets_of_books gl
227: where imp.org_id is NULL
228: and gl.set_of_books_id = imp.set_of_books_id;