DBA Data[Home] [Help]

APPS.CEP_STANDARD dependencies on XLE_ENTITY_PROFILES

Line 273: XLE_ENTITY_PROFILES h

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

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

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