APPS.EDW_TIME_PKG dependencies on GL_SETS_OF_BOOKS

Line 23: gl_sets_of_books sob

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
27:

Line 89: gl_sets_of_books sob

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
93:

Line 150: gl_sets_of_books sob,

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
154: and maps.accounting_date = trunc(cal_date)

Line 215: gl_sets_of_books gl

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;
218:
219: -- Cursor for Single org install

Line 226: gl_sets_of_books gl

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;
229:
230: begin