APPS.AMS_DCF_LEADS_TITLE SQL Statements

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

Line: 22

    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: 43

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

Line: 55

    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: 75

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

Line: 87

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

Line: 112

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

Line: 124

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

Line: 148

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

Line: 160

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

Line: 184

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

Line: 196

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

Line: 220

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

Line: 232

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

Line: 256

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

Line: 268

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

Line: 306

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

Line: 332

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

Line: 336

               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: 355

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