DBA Data[Home] [Help]

APPS.CEP_STANDARD dependencies on GL_SETS_OF_BOOKS

Line 209: from gl_sets_of_books g

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

Line 249: from gl_sets_of_books g,

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

Line 271: from gl_sets_of_books g,

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