DBA Data[Home] [Help]

APPS.CEP_STANDARD dependencies on XLE_ENTITY_PROFILES

Line 270: XLE_ENTITY_PROFILES h

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
273: and c.set_of_books_id = g.set_of_books_id;
274: EXCEPTION

Line 460: l_final_query := 'SELECT 1 from fnd_grants grt, fnd_objects obj, wf_user_roles rol, xle_entity_profiles le ' ||

456: BEGIN
457:
458: l_cursor_id := DBMS_SQL.open_cursor;
459:
460: l_final_query := 'SELECT 1 from fnd_grants grt, fnd_objects obj, wf_user_roles rol, xle_entity_profiles le ' ||
461: 'where grt.object_id = obj.object_id and obj.obj_name = ''' || p_security_mode || ''' and ' ||
462: 'GRANTEE_TYPE = '''||'GROUP'||''' and GRANTEE_KEY = rol.role_name and ' ||
463: 'rol.user_name in ((select fnd_global.user_name from dual) UNION ALL '||
464: '(select incrns.name from wf_local_roles incrns, fnd_user f '||