APPS.AMS_DCF_TITLE SQL Statements

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

Line: 28

        select meaning into vScaleByMeaning from ams_lookups where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;

Line: 48

    select to_char(start_date,'mm-dd') ||' to '|| to_char(end_date,'mm-dd') into xPeriod from bim_r_periods where calc_type = 'FIXED' and period_type = vPeriod;

Line: 71

    select
       meaning into vRepName
    from
       fnd_lookup_values
    where
       lookup_type= 'BIM_DBC_DCF_TITLES'
       and lookup_code = vCompCode
       and language = userenv('LANG');

Line: 82

    select to_char(start_date,'mm-dd') ||' to '|| to_char(end_date,'mm-dd') into xPeriod from bim_r_periods where calc_type = 'FIXED' and period_type = vPeriod;

Line: 102

    select
       meaning into vRepName
    from
       fnd_lookup_values
    where
       lookup_type= 'BIM_DBC_DCF_TITLES'
       and lookup_code = vCompCode
       and language = userenv('LANG');

Line: 115

        select substr(vPeriod,0,INSTR(vPeriod,'|')-1) into xRetString from dual;

Line: 138

    select
       meaning into vRepName
    from
       fnd_lookup_values
    where
       lookup_type= 'BIM_DBC_DCF_TITLES'
       and lookup_code = vCompCode
       and language = userenv('LANG');

Line: 151

        select substr(vPeriod,0,INSTR(vPeriod,'|')-1) into xRetString from dual;

Line: 178

    select
       meaning into vRepName
    from
       fnd_lookup_values
    where
       lookup_type= 'BIM_DBC_DCF_TITLES'
       and lookup_code = vCompCode
       and language = userenv('LANG');

Line: 192

        select meaning into vScaleByMeaning from ams_lookups
         where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;

Line: 219

    select
       meaning into vRepName
    from
       fnd_lookup_values
    where
       lookup_type= 'BIM_DBC_DCF_TITLES'
       and lookup_code = vCompCode
       and language = userenv('LANG');

Line: 233

        select meaning into vScaleByMeaning from ams_lookups
         where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;

Line: 260

    select
       meaning into vRepName
    from
       fnd_lookup_values
    where
       lookup_type= 'BIM_DBC_DCF_TITLES'
       and lookup_code = vCompCode
       and language = userenv('LANG');

Line: 274

        select meaning into vScaleByMeaning from ams_lookups
         where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;

Line: 302

    select
       meaning into vRepName
    from
       fnd_lookup_values
    where
       lookup_type= 'BIM_DBC_DCF_TITLES'
       and lookup_code = vCompCode
       and language = userenv('LANG');

Line: 316

        select meaning into vScaleByMeaning from ams_lookups
         where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;

Line: 353

    select
       meaning into vRepName
    from
       fnd_lookup_values
    where
       lookup_type= 'BIM_DBC_DCF_TITLES'
       and lookup_code = vCompCode
       and language = userenv('LANG');

Line: 381

    select fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE') into vCurrency from dual;

Line: 383

       select substr(vDefPeriod,0,INSTR(vDefPeriod,'-',10)-1) into xRetString from dual;

Line: 384

       select year, qtr into xYear, xQtr
             from bim_r_fd_dim_sum_mv where year||'-'||qtr = xRetString and rownum < 2;

Line: 391

           select year, qtr,month,display_type into xYear, xQtr, xMonth,xDisplayType
             from bim_r_fd_dim_sum_mv where year||'-'||qtr||'-'||month||'-'||display_type = vContext
             and rownum < 2;

Line: 395

               select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||
                      to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod
                 from bim_r_periods where calc_type = 'ROLLING' and period_type = xDisplayType;

Line: 409

           select year, qtr,month,display_type into xYear, xQtr, xMonth,xDisplayType
             from bim_r_fd_dim_sum_mv where year||'-'||qtr||'-'||month||'-'||display_type = vContext
             and rownum < 2;

Line: 413

               select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||
                      to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod
                 from bim_r_periods where calc_type = 'ROLLING' and period_type = xDisplayType;

Line: 427

           select year, qtr,month into xYear, xQtr, xMonth
             from BIM_R_EVEN_DIM_SUM_MV where year||'-'||qtr||'-'||month = vContext and rownum < 2;

Line: 437

           select year, qtr,month into xYear, xQtr, xMonth
             from BIM_R_CAMP_DIM_SUM_MV where year||'-'||qtr||'-'||month = vContext and rownum < 2;

Line: 478

    select
       meaning into vRepName
    from
       fnd_lookup_values
    where
       lookup_type= 'BIM_DBC_DCF_TITLES'
       and lookup_code = vCompCode
       and language = userenv('LANG');

Line: 489

    select substr(vContext,INSTR(vContext,'-',-1)+1) into xIncr from dual;

Line: 491

    select start_date ||'-'|| end_date into xPeriod from bim_r_periods where calc_type = 'ROLLING' and period_type = xIncr;

Line: 511

    select
       meaning into vRepName
    from
       fnd_lookup_values
    where
       lookup_type= 'BIM_DBC_DCF_TITLES'
       and lookup_code = vCompCode
       and language = userenv('LANG');

Line: 522

       select to_char(current_count_value,'999,999,999,999') into xCount from bim_r_camp_act_bin_mv a
       where a.aggregate_by = 'INCREMENT'
       and a.year is not null
       and a.qtr is not null
       and a.month is not null
       AND a.display_type is not null and rownum < 2;

Line: 529

       select /*+ index_desc(A, BIM_R_CAMP_ACT_BIN_MV_N4) */
       TO_CHAR(A.current_count_value,'999,999,999,999') into xCount
       from BIM_R_CAMP_ACT_BIN_MV A
       where  A.AGGREGATE_BY = 'MONTH'  AND A.YEAR IS NOT NULL
       AND A.QTR IS NOT NULL AND A.MONTH IS NOT NULL
       AND A.DISPLAY_TYPE IS NOT NULL
       and rownum <2;

Line: 597

    select
       meaning into vRepName
    from
       fnd_lookup_values
    where
       lookup_type= 'BIM_DBC_DCF_TITLES'
       and lookup_code = vCompCode
       and language = userenv('LANG');

Line: 622

       select substr(vDefPeriod,0,INSTR(vDefPeriod,'-',10)-1) into xRetString from dual;

Line: 623

       select year, qtr into xYear, xQtr
             from bim_r_fd_dim_sum_mv where year||'-'||qtr = xRetString and rownum < 2;

Line: 630

           select year, qtr,month,display_type into xYear, xQtr, xMonth,xDisplayType
             from bim_r_fd_dim_sum_mv where year||'-'||qtr||'-'||month||'-'||display_type = vContext
             and rownum < 2;

Line: 634

               select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||
                      to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod
                 from bim_r_periods where calc_type = 'ROLLING' and period_type = xDisplayType;

Line: 648

           select year, qtr,month,display_type into xYear, xQtr, xMonth,xDisplayType
             from bim_r_fd_dim_sum_mv where year||'-'||qtr||'-'||month||'-'||display_type = vContext
             and rownum < 2;

Line: 652

               select to_char(start_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) ||' ' ||vTo||' '||
                      to_char(end_date,fnd_profile.VALUE('ICX_DATE_FORMAT_MASK')) into xPeriod
                 from bim_r_periods where calc_type = 'ROLLING' and period_type = xDisplayType;

Line: 666

           select year, qtr,month into xYear, xQtr, xMonth
             from BIM_R_EVEN_DIM_SUM_MV where year||'-'||qtr||'-'||month = vContext and rownum < 2;

Line: 676

           select year, qtr,month into xYear, xQtr, xMonth
             from BIM_R_CAMP_DIM_SUM_MV where year||'-'||qtr||'-'||month = vContext and rownum < 2;