APPS.IGI_IAC_YTD_PRE_PROCESS_PKG SQL Statements

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

Line: 24

    select sum(nvl(fdd.deprn_amount,0)-nvl(fdd.deprn_adjustment_amount,0)) deprn_YTD
    from fa_deprn_detail fdd
    where fdd.distribution_id = cp_distribution_id
    and fdd.book_type_code like cp_book_type_code
    and fdd.asset_id = cp_asset_id
    and fdd.period_counter in (select period_counter from fa_deprn_periods
                                where book_type_code = cp_book_type_code
                                and fiscal_year = (select decode(period_num,1,fiscal_year-1,fiscal_year)
                                                    from fa_deprn_periods
                                                    where period_close_date is NULL
                                                    and book_type_code = cp_book_type_code))
    group by fdd.asset_id,fdd.distribution_id;

Line: 38

    SELECT DISTINCT asset_id
    FROM igi_iac_transaction_headers
    WHERE book_type_code = p_book_type_code;

Line: 43

    select (nvl(deprn_amount,0) - nvl(deprn_adjustment_amount,0)) deprn_amount,
            deprn_reserve,
            period_counter
    from fa_deprn_detail
    where book_type_code = p_book_type_code
    and asset_id = cp_asset_id
    and distribution_id = cp_distribution_id
    and period_counter = (select max(period_counter)
                            from fa_deprn_summary
                            where book_type_code = p_book_type_code
                            and asset_id = cp_asset_id);

Line: 56

    SELECT *
    FROM igi_iac_det_balances
    WHERE book_type_code = p_book_type_code
    AND asset_id = cp_asset_id
    AND adjustment_id = cp_adjustment_id;

Line: 63

    SELECT period_counter
    FROM igi_iac_det_balances
    WHERE book_type_code = p_book_type_code
    AND asset_id = cp_asset_id
    AND adjustment_id = cp_adjustment_id
    AND distribution_id = cp_distribution_id;

Line: 71

    SELECT 'X'
    FROM igi_iac_fa_deprn
    WHERE book_type_code = p_book_type_code
    AND rownum = 1;

Line: 80

    Select *
    From igi_iac_fa_deprn
    Where book_type_code = p_book_type_code
    and asset_id = cp_asset_id
    and distribution_id = cp_distribution_id
    and adjustment_id = cp_adjustment_id
    and period_counter = cp_period_counter;

Line: 92

    SELECT nvl(period_counter_fully_reserved, 0)
    FROM   fa_books
    WHERE  asset_id = cp_asset_id
    AND    book_type_code = cp_book_type_code
    AND    transaction_header_id_out IS NULL
    AND    date_ineffective IS NULL;

Line: 228

                    igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'        Inserting record for latest adjustment');

Line: 240

                    IGI_IAC_FA_DEPRN_PKG.insert_row (
                    x_rowid                    => l_rowid,
                    x_adjustment_id            => l_adjustment_id,
                    x_asset_id                 => l_asset.asset_id,
                    x_distribution_id          => l_dist.distribution_id,
                    x_book_type_code           => p_book_type_code,
                    x_period_counter           => l_dist.period_counter,
                    x_deprn_period             => l_deprn_amount,
                    x_deprn_ytd                => l_deprn_ytd,
                    x_deprn_reserve            => l_deprn_reserve,
                    x_active_flag              => l_dist.active_flag,
                    x_mode                     => 'R' );

Line: 257

                    igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'        Inserting record for latest adjustment');

Line: 269

                    IGI_IAC_FA_DEPRN_PKG.insert_row (
                    x_rowid                    => l_rowid,
                    x_adjustment_id            => l_adjustment_id,
                    x_asset_id                 => l_asset.asset_id,
                    x_distribution_id          => l_dist.distribution_id,
                    x_book_type_code           => p_book_type_code,
                    x_period_counter           => l_dist.period_counter,
                    x_deprn_period             => l_deprn_amount,
                    x_deprn_ytd                => l_deprn_ytd,
                    x_deprn_reserve            => l_deprn_reserve,
                    x_active_flag              => l_dist.active_flag,
                    x_mode                     => 'R' );

Line: 292

                        igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'        Inserting record for previous adjustment');

Line: 304

                        IGI_IAC_FA_DEPRN_PKG.insert_row (
                        x_rowid                    => l_rowid,
                        x_adjustment_id            => l_prev_adjustment_id,
                        x_asset_id                 => l_asset.asset_id,
                        x_distribution_id          => l_dist.distribution_id,
                        x_book_type_code           => p_book_type_code,
                        x_period_counter           => l_prev_adj_period,
                        x_deprn_period             => l_deprn_amount,
                        x_deprn_ytd                => l_deprn_ytd,
                        x_deprn_reserve            => l_deprn_reserve,
                        x_active_flag              => l_dist.active_flag,
                        x_mode                     => 'R' );

Line: 321

                        igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'        Inserting record for previous adjustment');

Line: 333

                        IGI_IAC_FA_DEPRN_PKG.insert_row (
                            x_rowid                    => l_rowid,
                            x_adjustment_id            => l_prev_adjustment_id,
                            x_asset_id                 => l_asset.asset_id,
                            x_distribution_id          => l_dist.distribution_id,
                            x_book_type_code           => p_book_type_code,
                            x_period_counter           => l_prev_adj_period,
                            x_deprn_period             => l_deprn_amount,
                            x_deprn_ytd                => l_deprn_ytd,
                            x_deprn_reserve            => l_deprn_reserve,
                            x_active_flag              => l_dist.active_flag,
                            x_mode                     => 'R' );