APPS.IGI_IAC_REVAL_VALIDATION SQL Statements

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

Line: 23

    select max(period_counter) period_counter
    from  fa_deprn_summary
    where asset_id              = fp_asset_id
    and   book_type_code        = fp_book_type_code
    ;

Line: 59

    select revaluation_factor
    from igi_iac_reval_asset_rules
    where asset_id       = fp_asset_id
    and   book_type_code = fp_book_type_code
    and   revaluation_id = fp_revaluation_id;

Line: 85

    select 'x' valid_rec
    from  fa_books
    where asset_id              = fp_asset_id
    and   book_type_code        = fp_book_type_code
    and   cost                  = 0
    and   transaction_header_id_out is null
    ;

Line: 122

    select 'x'
    from  igi_iac_transaction_headers
    where asset_id              = fp_asset_id
    and   book_type_code        = fp_book_type_code
    and   period_counter        = fp_period_counter
    and   mass_Reference_id       <> fp_revaluation_id
    and   revaluation_type_flag in ( 'O', 'P' )
    and   fp_reval_type         = 'O'
    and adjustment_status <> 'OBSOLETE'
    ;

Line: 256

    SELECT mass_reference_id revaluation_id
    FROM  igi_iac_transaction_headers
    WHERE asset_id              = fp_asset_id
    AND   book_type_code        = fp_book_type_code
    AND   period_counter        = fp_period_counter
    AND   transaction_type_code = 'REVALUATION'
    AND   adjustment_status     = 'PREVIEW'
    AND   mass_Reference_id     <> fp_revaluation_id;

Line: 402

  select asset_number
  into   l_asset_num
  from   fa_additions
  where  asset_id = fp_asset_id
  ;