APPS.ZPB_AW SQL Statements

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

Line: 199

      select BUSINESS_AREA_ID
         into l_business_area_id
         from ZPB_CURRENT_USER_V;

Line: 204

   select ANNOTATION_AW
      into l_annotation_aw
      from ZPB_BUSINESS_AREAS
      where BUSINESS_AREA_ID = l_business_area_id;

Line: 245

      select BUSINESS_AREA_ID
         into l_business_area_id
         from ZPB_CURRENT_USER_V;

Line: 252

      select SHADOW_ID
         into l_user
         from ZPB_CURRENT_USER_V;

Line: 258

      select PERSONAL_AW
         into l_personal_aw
         from ZPB_USERS
         where BUSINESS_AREA_ID = l_business_area_id
         and USER_ID = l_user;

Line: 289

      select BUSINESS_AREA_ID
         into l_business_area_id
         from ZPB_CURRENT_USER_V;

Line: 294

   select DATA_AW
      into l_shared_aw
      from ZPB_BUSINESS_AREAS
      where BUSINESS_AREA_ID = l_business_area_id;

Line: 314

   select ORACLE_USERNAME
    into G_SCHEMA
    from FND_ORACLE_USERID a,
      FND_APPLICATION b,
      FND_PRODUCT_INSTALLATIONS c
    where a.ORACLE_ID = c.ORACLE_ID
      and c.APPLICATION_ID = b.APPLICATION_ID
      and b.APPLICATION_SHORT_NAME = 'ZPB';

Line: 510

   select BUSINESS_AREA_ID
      into l_business_area_id
      from ZPB_ANALYSIS_CYCLES
      where ANALYSIS_CYCLE_ID = p_analysis_cycle_id;

Line: 517

         select max(BUSINESS_AREA_ID)
                 into l_business_area_id
                 from ZPB_ANALYSIS_CYCLES
                 where CURRENT_INSTANCE_ID = p_analysis_cycle_id;

Line: 614

         select PERSONAL_AW
            into l_pers_AW
            from ZPB_USERS
            where BUSINESS_AREA_ID =
              sys_context('ZPB_CONTEXT', 'business_area_id')
            and USER_ID = p_user;