APPS.FA_AMORT_VAL_PKG SQL Statements

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

Line: 39

          select greatest(calendar_period_open_date,
                   least(sysdate, calendar_period_close_date)),
                   calendar_period_close_date, calendar_period_open_date
          from   fa_deprn_periods
          where  book_type_code = x_book
          and    period_close_date is null;

Line: 73

     select fiscal_year_name,deprn_calendar
     into fy_name, cal_type
     from fa_book_controls
     where book_type_code = x_book;

Line: 117

     select MAX(transaction_date_entered),MAX(date_effective)
     into   h_prior_transaction_date,h_prior_date_effective
     from   fa_transaction_headers
     where  asset_id = x_asset_id
     and    book_type_code = x_book;

Line: 129

     select count(*)
     into h_count
     from fa_deprn_periods pdp, fa_deprn_periods adp
     where pdp.book_type_code = x_book
     and pdp.book_type_code = adp.book_type_code
     and pdp.period_counter > adp.period_counter
     and h_prior_date_effective between pdp.period_open_date
             and nvl(pdp.period_close_date, to_date('31-12-4712','DD-MM-YYYY'))
     and x_new_amort_start_date between
             adp.calendar_period_open_date and adp.calendar_period_close_date;

Line: 150

     select MAX(date_effective)
     into   h_prior_date_effective
     from   fa_transaction_headers
     where  asset_id = x_asset_id
     and   book_type_code = x_book
     and   transaction_type_code in ('REVALUATION');

Line: 160

        select greatest(calendar_period_open_date,
                least(SYSDATE, calendar_period_close_date))
        into h_amort_date
        from fa_deprn_periods
        where book_type_code = X_book
        and h_prior_date_effective between
            period_open_date and
            nvl(period_close_date,sysdate);