APPS.IGIRX_IAC_PROJ SQL Statements

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

Line: 31

 SELECT book_type_code,
        start_period_counter,
        end_period,
        revaluation_period
 FROM igi_iac_projections
 WHERE projection_id = n_projection_id;

Line: 41

 SELECT dp.projection_id,
        dp.period_counter proj_period_counter,
        dp.category_id,
        fc.description cat_desc,
        dp.fiscal_year,
        dp.company,
        dp.cost_center,
        dp.asset_id,
        fad.asset_number,
        fad.description asset_desc,
        dp.latest_reval_cost,
        dp.deprn_period,
        dp.deprn_ytd,
        substr(dp.asset_exception,1,30) exception_code
 FROM   igi_iac_proj_details dp,
        fa_additions fad,
        fa_categories fc
 WHERE  dp.projection_id = n_proj_id
 AND    fad.asset_id = dp.asset_id
 AND    dp.category_id = fc.category_id
 ORDER BY dp.asset_id, dp.period_counter;

Line: 137

    SELECT category_flex_structure, asset_key_flex_structure
    INTO   l_cat_struct, l_assetkey_struct
    FROM   fa_system_controls;

Line: 150

    SELECT sob.set_of_books_id,
           substr(sob.currency_code,1,15),
           substr(sob.name,1 ,80)
    INTO  l_sob_id,
          l_currency_code,
          l_organization_name
    FROM  fa_book_controls bc,
          gl_sets_of_books sob,
          fnd_currencies cur
    WHERE  bc.book_type_code = l_get_proj.book_type_code
    AND    sob.set_of_books_id = bc.set_of_books_id
    AND    sob.currency_code = cur.currency_code;

Line: 276

                                              'SELECT',
                                              'MINOR_CATEGORY');

Line: 286

          l_sql := 'SELECT ' ||l_min_cat||
                   ' FROM fa_categories cat
                   WHERE cat.category_id = :1';

Line: 313

        SELECT meaning
        INTO   l_exception_desc
        FROM IGI_LOOKUPS
        WHERE lookup_type = 'IGI_IAC_PROJ_EXCEPTIONS'
        AND lookup_code = l_proj_data.exception_code;

Line: 328

   igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserting.......');

Line: 331

      INSERT INTO igi_iac_proj_rep_itf(
            projection_id,
            book_type_code,
            start_period,
            end_period,
            proj_period,
            fiscal_year,
            periodic_index,
            reval_index,
            reval_period_name,
            company,
            cost_center,
            category_id,
            major_category,
            minor_category,
            category,
            category_desc,
            asset_number,
            asset_desc,
            deprn_period,
            deprn_ytd,
            latest_reval_cost,
            exception_code,
            exception_desc,
            request_id,
            set_of_books_id,
            functional_currency_code,
            organization_name,
            created_by,
            creation_date,
            last_update_login,
            last_updated_by ,
            last_update_date,
            period_counter
          ) VALUES (
            p_projection_id,
            l_rxi_proj_rec.book_type_code(i),
            l_rxi_proj_rec.start_period(i),
            l_rxi_proj_rec.end_period(i),
            l_rxi_proj_rec.proj_period(i),
            l_rxi_proj_rec.fiscal_year(i),
            l_rxi_proj_rec.periodic_index(i),
            l_rxi_proj_rec.reval_index(i),
            l_rxi_proj_rec.reval_period_name(i),
            l_rxi_proj_rec.company(i),
            l_rxi_proj_rec.cost_center(i),
            l_rxi_proj_rec.category_id(i),
            l_rxi_proj_rec.major_category(i),
            l_rxi_proj_rec.minor_category(i),
            l_rxi_proj_rec.category(i),
            l_rxi_proj_rec.category_desc(i),
            l_rxi_proj_rec.asset_number(i),
            l_rxi_proj_rec.asset_desc(i),
            l_rxi_proj_rec.deprn_period(i),
            l_rxi_proj_rec.deprn_ytd(i),
            l_rxi_proj_rec.latest_reval_cost(i),
            l_rxi_proj_rec.exception_code(i),
            l_rxi_proj_rec.exception_desc(i),
            p_request_id,
            l_sob_id,
            l_currency_code,
            l_organization_name,
            l_user_id,
            sysdate,
            l_login_id,
            l_user_id ,
            sysdate,
            l_rxi_proj_rec.period_counter(i)
          );

Line: 404

          DELETE FROM igi_iac_projections
          WHERE projection_id = p_projection_id;

Line: 407

          DELETE FROM igi_iac_proj_details
          WHERE projection_id = p_projection_id;