APPS.FA_DELETION_PVT SQL Statements

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

Line: 34

             name       => 'FA_ADD_CANT_DELETE'
             ,p_log_level_rec => p_log_level_rec);

Line: 40

      select count(1)
      into l_count
      from fa_additions_b
      where parent_asset_id = px_asset_hdr_rec.asset_id;

Line: 48

             name       => 'FA_ADD_CANT_DELETE_PARENT'
             ,p_log_level_rec => p_log_level_rec);

Line: 57

         select count(*)
           into l_count
           from fa_books
          where book_type_code = px_asset_hdr_rec.book_type_code
            and group_asset_id = px_asset_hdr_rec.asset_id;

Line: 66

                 name       => '***FA_DELETE_GORUP_ASSET***'
                ,p_log_level_rec => p_log_level_rec);

Line: 73

         select count(*)
           into l_count
           from fa_books
          where asset_id       = px_asset_hdr_rec.asset_id
            and book_type_code = px_asset_hdr_rec.book_type_code
            and group_asset_id is not null;

Line: 83

                 name       => '***FA_DELETE_GORUP_MEMBER***'
                ,p_log_level_rec => p_log_level_rec);

Line: 88

         select count(*)
           into l_count
           from fa_asset_invoices
          where asset_id = px_asset_hdr_rec.asset_id
            and feeder_system_name = 'ORACLE PROJECTS';

Line: 97

                 name       => 'FA_ADD_CANT_DELETE_PROJECT'
                 ,p_log_level_rec => p_log_level_rec);

Line: 109

      SELECT count(*)
        INTO l_count
        FROM FA_ADDITIONS_B
       WHERE LEASE_ID = p_asset_desc_rec.lease_id
         AND ASSET_CATEGORY_ID =
             ANY (SELECT CATEGORY_ID
                    FROM FA_CATEGORIES
                   WHERE CATEGORY_TYPE = 'LEASEHOLD IMPROVEMENT');

Line: 122

              name       => 'FA_ADD_DELETE_LHOLD'
              ,p_log_level_rec => p_log_level_rec);

Line: 134

      select count(*)
        into l_count
        from fa_transaction_headers   th,
             xla_transaction_entities en,
             xla_events               ev,
             fa_book_controls         bc
       where bc.book_type_code              = px_asset_hdr_rec.book_type_code
         and th.book_type_code              = bc.distribution_source_book
         and th.asset_id                    = px_asset_hdr_rec.asset_id
         and en.application_id              = 140
         and en.ledger_id                   = bc.set_of_books_id
         and en.entity_code                 = 'TRANSACTIONS'
         and nvl(en.source_id_int_1, (-99)) = th.transaction_header_id
         and en.valuation_method            = px_asset_hdr_rec.book_type_code
         and ev.application_id              = 140
         and ev.entity_id                   = en.entity_id
         and ev.event_status_code           = 'P';

Line: 157

              name       => 'FA_ADD_CANT_DELETE');

Line: 164

      select count(*)
        into l_count
        from fa_transaction_headers   th,
             xla_transaction_entities en,
             xla_events               ev,
             fa_book_controls         bc
       where bc.book_type_code              = px_asset_hdr_rec.book_type_code
         and th.book_type_code              = px_asset_hdr_rec.book_type_code
         and th.asset_id                    = px_asset_hdr_rec.asset_id
         and en.application_id              = 140
         and en.ledger_id                   = bc.set_of_books_id
         and en.entity_code                 = 'TRANSACTIONS'
         and nvl(en.source_id_int_1, (-99)) = th.transaction_header_id
         and en.valuation_method            = px_asset_hdr_rec.book_type_code
         and ev.application_id              = 140
         and ev.entity_id                   = en.entity_id
         and ev.event_status_code           = 'P';

Line: 187

              name       => 'FA_ADD_CANT_DELETE');

Line: 192

      select count(*)
        into l_count
        from xla_transaction_entities en,
             xla_events               ev,
             fa_book_controls         bc
       where bc.distribution_source_book    = px_asset_hdr_rec.book_type_code
         and en.application_id              = 140
         and en.ledger_id                   = bc.set_of_books_id
         and en.entity_code                 = 'DEPRECIATION'
         and nvl(en.source_id_int_1, (-99)) = px_asset_hdr_rec.asset_id
         and nvl(en.source_id_char_1, ' ')  = bc.book_type_code
         and ev.application_id              = 140
         and ev.entity_id                   = en.entity_id
         and ev.event_status_code           = 'P';

Line: 212

              name       => 'FA_ADD_CANT_DELETE');

Line: 220

      select count(*)
        into l_count
        from fa_transaction_headers   th,
             xla_transaction_entities en,
             xla_events               ev,
             fa_book_controls         bc
       where bc.distribution_source_book    = px_asset_hdr_rec.book_type_code
         and th.book_type_code              = bc.book_type_code
         and th.asset_id                    = px_asset_hdr_rec.asset_id
         and en.application_id              = 140
         and en.ledger_id                   = bc.set_of_books_id
         and en.entity_code                 = 'INTER_ASSET_TRANSACTIONS'
         and nvl(en.source_id_int_1, (-99)) = th.trx_reference_id
         and en.valuation_method            = px_asset_hdr_rec.book_type_code
         and ev.application_id              = 140
         and ev.entity_id                   = en.entity_id;

Line: 242

              name       => 'FA_ADD_CANT_DELETE');