APPS.FA_TOFES_YUD_ALEF_PKG SQL Statements

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

Line: 62

  SELECT SUM(DECODE(DEBIT_CREDIT_FLAG, 'CR', ADJUSTMENT_AMOUNT * (-1), ADJUSTMENT_AMOUNT))
    INTO ln_amount
    FROM FA_ADJUSTMENTS_MRC_V
   WHERE BOOK_TYPE_CODE   = P_BOOK_NAME
     AND ASSET_ID    = p_asset_id_in
     AND ADJUSTMENT_TYPE  = 'COST'
     AND SOURCE_TYPE_CODE = 'ADJUSTMENT'
     AND PERIOD_COUNTER_ADJUSTED BETWEEN p_lex_begin_period_counter AND p_lex_end_period_counter;

Line: 73

  SELECT SUM(DECODE(DEBIT_CREDIT_FLAG, 'CR', ADJUSTMENT_AMOUNT * (-1), ADJUSTMENT_AMOUNT))
    INTO ln_amount
    FROM FA_ADJUSTMENTS
   WHERE BOOK_TYPE_CODE   = P_BOOK_NAME
     AND ASSET_ID    = p_asset_id_in
     AND ADJUSTMENT_TYPE  = 'COST'
     AND SOURCE_TYPE_CODE = 'ADJUSTMENT'
     AND PERIOD_COUNTER_ADJUSTED BETWEEN p_lex_begin_period_counter AND p_lex_end_period_counter;

Line: 102

   SELECT count(PERIOD_COUNTER)
   INTO ln_number
   FROM FA_DEPRN_SUMMARY_MRC_V
   WHERE book_type_code = p_book_name
   AND asset_id = p_asset_id_in
   AND period_counter BETWEEN p_lex_begin_period_counter AND p_lex_end_period_counter
   AND deprn_source_code = 'DEPRN'
   AND deprn_amount <> 0;

Line: 112

   SELECT count(PERIOD_COUNTER)
   INTO ln_number
   FROM fa_Deprn_summary
   WHERE book_type_code = p_book_name
   AND asset_id = p_asset_id_in
   AND period_counter BETWEEN p_lex_begin_period_counter AND p_lex_end_period_counter
   AND deprn_source_code = 'DEPRN'
   AND deprn_amount <> 0;

Line: 136

  /*SELECT SUM(DEPRN_AMOUNT)
    INTO ln_amount
    FROM FA_DEPRN_SUMMARY
   WHERE BOOK_TYPE_CODE = P_BOOK_NAME
     AND ASSET_ID     = p_asset_id_in
     AND PERIOD_COUNTER BETWEEN p_lex_begin_period_counter AND p_lex_end_period_counter;*/

Line: 144

   SELECT sum(deprn_amount)
      INTO ln_amount
      FROM FA_DEPRN_SUMMARY_MRC_V
      WHERE BOOK_TYPE_CODE = P_BOOK_NAME
      AND ASSET_ID     = p_asset_id_in
      AND DEPRN_SOURCE_CODE = 'DEPRN'
      AND PERIOD_COUNTER  BETWEEN p_lex_begin_period_counter AND p_lex_end_period_counter;

Line: 152

   SELECT sum(deprn_amount)
      INTO ln_amount
      FROM FA_DEPRN_SUMMARY
      WHERE BOOK_TYPE_CODE = P_BOOK_NAME
      AND ASSET_ID     = p_asset_id_in
      AND DEPRN_SOURCE_CODE = 'DEPRN'
      AND PERIOD_COUNTER  BETWEEN p_lex_begin_period_counter AND p_lex_end_period_counter;

Line: 177

  /*SELECT SUM(DEPRN_AMOUNT)
    INTO ln_amount
    FROM FA_DEPRN_SUMMARY
   WHERE BOOK_TYPE_CODE = P_BOOK_NAME
     AND ASSET_ID     = p_asset_id_in
     AND PERIOD_COUNTER BETWEEN p_lex_begin_period_counter AND p_lex_end_period_counter;*/

Line: 185

  SELECT DEPRN_ADJUSTMENT_AMOUNT
    INTO ln_amount
    FROM FA_DEPRN_SUMMARY_MRC_V
   WHERE BOOK_TYPE_CODE = P_BOOK_NAME
     AND ASSET_ID     = p_asset_id_in
     AND period_counter = p_period_counter
     AND PERIOD_COUNTER > (SELECT MAX(fdp.period_counter)
  FROM FA_DEPRN_PERIODS_MRC_V fdp
  WHERE FDP.book_type_code = P_BOOK_NAME
  AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
           FROM FA_DEPRN_PERIODS_MRC_V
         WHERE book_type_code = P_BOOK_NAME
         AND  period_close_date IS NOT NULL));

Line: 200

  SELECT DEPRN_ADJUSTMENT_AMOUNT
    INTO ln_amount
    FROM FA_DEPRN_SUMMARY
   WHERE BOOK_TYPE_CODE = P_BOOK_NAME
     AND ASSET_ID     = p_asset_id_in
     AND period_counter = p_period_counter
     AND PERIOD_COUNTER > (SELECT MAX(fdp.period_counter)
  FROM fa_deprn_periods fdp
  WHERE FDP.book_type_code = P_BOOK_NAME
  AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
           FROM FA_DEPRN_PERIODS
         WHERE book_type_code = P_BOOK_NAME
         AND  period_close_date IS NOT NULL));

Line: 234

  SELECT SUM(DEPRN_AMOUNT)
    INTO ln_amount
    FROM FA_DEPRN_SUMMARY_MRC_V
   WHERE BOOK_TYPE_CODE = P_BOOK_NAME
     AND ASSET_ID     = p_asset_id_in
     AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
    FROM FA_DEPRN_PERIODS_MRC_V fdp
   WHERE FDP.book_type_code = P_BOOK_NAME
     AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
                              FROM FA_DEPRN_PERIODS_MRC_V
                                                 WHERE book_type_code = P_BOOK_NAME
                                                   AND  period_close_date IS NOT NULL));

Line: 249

  SELECT SUM(DEPRN_AMOUNT)
    INTO ln_amount
    FROM FA_DEPRN_SUMMARY
   WHERE BOOK_TYPE_CODE = P_BOOK_NAME
     AND ASSET_ID     = p_asset_id_in
     AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
    FROM FA_DEPRN_PERIODS fdp
   WHERE FDP.book_type_code = P_BOOK_NAME
     AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
                              FROM FA_DEPRN_PERIODS
                                                 WHERE book_type_code = P_BOOK_NAME
                                                   AND  period_close_date IS NOT NULL));

Line: 282

  SELECT SUM(DEPRN_ADJUSTMENT_AMOUNT)
    INTO ln_amount
    FROM FA_DEPRN_SUMMARY_MRC_V
   WHERE BOOK_TYPE_CODE = P_BOOK_NAME
     AND ASSET_ID     = p_asset_id_in
     AND PERIOD_COUNTER = P_PERIOD_COUNTER
     AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
    FROM FA_DEPRN_PERIODS_MRC_V fdp
   WHERE FDP.book_type_code = P_BOOK_NAME
     AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
                              FROM FA_DEPRN_PERIODS_MRC_V
                                                 WHERE book_type_code = P_BOOK_NAME
                                                   AND period_close_date IS NOT NULL));

Line: 297

  SELECT SUM(DEPRN_ADJUSTMENT_AMOUNT)
    INTO ln_amount
    FROM FA_DEPRN_SUMMARY
   WHERE BOOK_TYPE_CODE = P_BOOK_NAME
     AND ASSET_ID     = p_asset_id_in
     AND PERIOD_COUNTER = P_PERIOD_COUNTER
     AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
    FROM fa_deprn_periods fdp
   WHERE FDP.book_type_code = P_BOOK_NAME
     AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
                              FROM FA_DEPRN_PERIODS
                                                 WHERE book_type_code = P_BOOK_NAME
                                                   AND period_close_date IS NOT NULL));

Line: 328

 SELECT INVOICE_DATE
   INTO ld_date
   FROM AP_INVOICES_ALL
  WHERE INVOICE_ID IN (SELECT FAI.INVOICE_ID
                         FROM FA_ASSET_INVOICES FAI
                             ,FA_ADDITIONS_B FA
                             ,FA_BOOKS FB
                       WHERE FAI.ASSET_ID = FA.ASSET_ID
                         AND FA.ASSET_ID = FB.ASSET_ID
                         AND FA.ASSET_ID = p_asset_id_in
                         AND FB.BOOK_TYPE_CODE = P_BOOK_NAME)
                         AND VENDOR_ID IN (SELECT FAI.PO_VENDOR_ID
                        FROM FA_ASSET_INVOICES FAI
                            ,FA_ADDITIONS_B FA
                            ,FA_BOOKS FB
                       WHERE FAI.ASSET_ID = FA.ASSET_ID
                                             AND FA.ASSET_ID = FB.ASSET_ID
                                             AND FA.ASSET_ID = p_asset_id_in
                                             AND FB.BOOK_TYPE_CODE = P_BOOK_NAME);

Line: 352

  SELECT FB.DATE_PLACED_IN_SERVICE
    INTO ld_date
    FROM FA_ADDITIONS_B FA
        ,FA_BOOKS     FB
   WHERE FA.ASSET_ID = FB.ASSET_ID
     AND FA.ASSET_ID = p_asset_id_in
     AND FB.BOOK_TYPE_CODE = P_BOOK_NAME
     AND FB.TRANSACTION_HEADER_ID_OUT IS NULL;

Line: 384

   select mrc_sob_type_code, currency_code
   into P_MRCSOBTYPE, lp_currency_code
   from gl_sets_of_books
   where set_of_books_id = p_ca_set_of_books_id;

Line: 409

  SELECT PERIOD_COUNTER
    INTO p_lex_begin_period_counter
    FROM FA_DEPRN_PERIODS_MRC_V
   WHERE BOOK_TYPE_CODE  = P_BOOK_NAME
     AND PERIOD_NAME  = P_BEGIN_PERIOD;

Line: 416

  SELECT PERIOD_COUNTER
    INTO p_lex_end_period_counter
    FROM FA_DEPRN_PERIODS_MRC_V
   WHERE BOOK_TYPE_CODE  = P_BOOK_NAME
     AND PERIOD_NAME  = P_END_PERIOD;

Line: 423

  SELECT Accounting_flex_structure
    INTO lc_acct_flex_struc
    FROM FA_BOOK_CONTROLS_MRC_V
   WHERE book_type_code = P_BOOK_NAME;

Line: 430

  SELECT PERIOD_COUNTER
    INTO p_lex_begin_period_counter
    FROM FA_DEPRN_PERIODS
   WHERE BOOK_TYPE_CODE  = P_BOOK_NAME
     AND PERIOD_NAME  = P_BEGIN_PERIOD;

Line: 437

  SELECT PERIOD_COUNTER
    INTO p_lex_end_period_counter
    FROM FA_DEPRN_PERIODS
   WHERE BOOK_TYPE_CODE  = P_BOOK_NAME
     AND PERIOD_NAME  = P_END_PERIOD;

Line: 444

  SELECT Accounting_flex_structure
    INTO lc_acct_flex_struc
    FROM FA_BOOK_CONTROLS
   WHERE book_type_code = P_BOOK_NAME;