APPS.FA_BASIS_OVERRIDE_INIT_PKG SQL Statements

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

Line: 218

    select dp.period_counter
    from   FA_DEPRN_PERIODS dp
    where  dp.book_type_code = l_book_type_code
    and    dp.fiscal_year = l_fiscal_year
    and    dp.period_num = l_period_number;

Line: 229

    select dp.period_counter
    from   FA_MC_DEPRN_PERIODS dp
    where  dp.book_type_code = l_book_type_code
    and    dp.fiscal_year = l_fiscal_year
    and    dp.period_num = l_period_number
    and    dp.set_of_books_id = p_set_of_books_id;

Line: 240

    select bk.deprn_method_code,
           bk.life_in_months
    from   FA_BOOKS bk
    where  bk.asset_id = l_asset_id
    and    bk.book_type_code = l_book_type_code
    and    bk.date_ineffective is null;

Line: 251

    select bk.deprn_method_code,
           bk.life_in_months
    from   FA_MC_BOOKS bk
    where  bk.asset_id = l_asset_id
    and    bk.book_type_code = l_book_type_code
    and    bk.date_ineffective is null
    and    bk.set_of_books_id = p_set_of_books_id;