DBA Data[Home] [Help]

APPS.CEP_STANDARD dependencies on GL_SETS_OF_BOOKS

Line 206: from gl_sets_of_books g

202: decode(g.mrc_sob_type_code, 'N', NULL,
203: decode(l_multi_cur, 'N', NULL,
204: ': ' || substr(g.currency_code, 1, 5)))
205: into l_wnd_context
206: from gl_sets_of_books g
207: , ce_system_parameters c
208: where c.set_of_books_id = g.set_of_books_id;
209: EXCEPTION
210: WHEN NO_DATA_FOUND THEN

Line 246: from gl_sets_of_books g,

242: decode(g.mrc_sob_type_code, 'N', substr(h.name, 54, 7),
243: decode(l_multi_cur, 'N', substr(h.name, 54, 7),
244: ': ' || substr(g.currency_code, 1, 5)))
245: into l_wnd_context
246: from gl_sets_of_books g,
247: ce_system_parameters c,
248: XLE_FP_OU_LEDGER_V xo,
249: hr_operating_units h
250: where h.organization_id = to_number(p_org_id)

Line 268: from gl_sets_of_books g,

264: decode(g.mrc_sob_type_code, 'N', substr(h.name, 54, 7),
265: decode(l_multi_cur, 'N', substr(h.name, 54, 7),
266: ': ' || substr(g.currency_code, 1, 5)))
267: into l_wnd_context
268: from gl_sets_of_books g,
269: ce_system_parameters c,
270: XLE_ENTITY_PROFILES h
271: where h.LEGAL_ENTITY_ID = to_number(p_legal_entity_id)
272: and h.LEGAL_ENTITY_ID = c.LEGAL_ENTITY_ID