APPS.CEP_STANDARD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 173

  SELECT 	nvl(multi_org_flag, 'N')
  ,		nvl(multi_currency_flag, 'N')
  INTO 		l_multi_org
  ,		l_multi_cur
  FROM		fnd_product_groups;

Line: 201

      select 	g.short_name ||
		  decode(g.mrc_sob_type_code, 'N', NULL,
                    decode(l_multi_cur, 'N', NULL,
		      ': ' || substr(g.currency_code, 1, 5)))
      into 	l_wnd_context
      from 	gl_sets_of_books g
      ,	 	ce_system_parameters c
      where	c.set_of_books_id = g.set_of_books_id;

Line: 241

        select 	substr(h.name, 1, 53) ||
                  decode(g.mrc_sob_type_code, 'N', substr(h.name, 54, 7),
		    decode(l_multi_cur, 'N', substr(h.name, 54, 7),
                      ': ' || substr(g.currency_code, 1, 5)))
        into 	l_wnd_context
        from 	gl_sets_of_books g,
		ce_system_parameters c,
		XLE_FP_OU_LEDGER_V   xo,
		hr_operating_units h
        where     h.organization_id = to_number(p_org_id)
        --where     h.organization_id = to_number(l_id)
        --and      h.organization_id = c.org_id
        and      h.organization_id = xo.OPERATING_UNIT_ID
	and      xo.LEGAL_ENTITY_ID = c.LEGAL_ENTITY_ID
        and       c.set_of_books_id = g.set_of_books_id;

Line: 263

        select 	substr(h.name, 1, 53) ||
                  decode(g.mrc_sob_type_code, 'N', substr(h.name, 54, 7),
		    decode(l_multi_cur, 'N', substr(h.name, 54, 7),
                      ': ' || substr(g.currency_code, 1, 5)))
        into 	l_wnd_context
        from 	gl_sets_of_books g,
		ce_system_parameters c,
		XLE_ENTITY_PROFILES  h
        where     h.LEGAL_ENTITY_ID = to_number(p_legal_entity_id)
        and      h.LEGAL_ENTITY_ID =  c.LEGAL_ENTITY_ID
        and       c.set_of_books_id = g.set_of_books_id;

Line: 311

  select nvl(float_days,0)
  into fd
  from ce_transaction_codes ctc
  where ctc.trx_code = p_trx_code
  and   ctc.bank_account_id = p_bank_account_id;

Line: 460

    l_final_query := 'SELECT 1 from fnd_grants grt, fnd_objects obj, wf_user_roles rol, xle_entity_profiles le ' ||
                     'where grt.object_id = obj.object_id and obj.obj_name = ''' || p_security_mode || ''' and ' ||
                     'GRANTEE_TYPE = '''||'GROUP'||''' and GRANTEE_KEY = rol.role_name and  ' ||
                     'rol.user_name in ((select fnd_global.user_name from dual) UNION ALL '||
            	     '(select incrns.name from wf_local_roles incrns, fnd_user f '||
                     'where '''|| 'HZ_PARTY' ||''' = incrns.orig_system and f.user_name = fnd_global.user_name '||
                     'and f.person_party_id  = incrns.orig_system_id and incrns.partition_id = 9)) '||
 		     'and   INSTANCE_PK1_VALUE = to_char(le.legal_entity_id) '||
                     'and   le.legal_entity_id = '|| to_char(p_le_id);

Line: 539

      select  APPLICATION_SHORT_NAME
      into    l_appl_name
      from    FND_APPLICATION
      where   APPLICATION_ID = FND_GLOBAL.resp_appl_id;

Line: 552

    delete ce_security_profiles_gt;

Line: 554

    insert into ce_security_profiles_gt
	(organization_type,
	 organization_id,
	 name)
    select organization_type,
	   organization_id,
	   name
    from ce_security_profiles_v;

Line: 581

    delete ce_security_profiles_gt;

Line: 583

    insert into ce_security_profiles_gt
	(organization_type,
	 organization_id,
	 name)
    ( select organization_type,
	   organization_id,
	   name
    from ce_security_profiles_v
    union
    select  'BUSINESS_GROUP',
             org.BUSINESS_GROUP_ID,
             org.NAME
    from hr_organization_information oi,
         hr_all_organization_units org
    WHERE   oi.organization_id = org.organization_id
    and  oi.org_information_context = 'CLASS'
    AND   oi.org_information1 = 'HR_BG');