APPS.FA_TRANSFER_PUB SQL Statements

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

Line: 36

   SELECT bc.book_type_code
     FROM fa_books bks,
          fa_book_controls bc
    WHERE bks.book_type_code = bc.distribution_source_book
      AND bks.book_type_code = bc.book_type_code
      AND bks.asset_id       = p_asset_id
      AND bks.transaction_header_id_out is null;

Line: 184

     select fa_transaction_headers_s.nextval
       into px_trans_rec.transaction_header_id
       from dual;

Line: 190

     px_trans_rec.who_info.last_update_date := sysdate;

Line: 360

        select start_date, end_date
        into l_fy_start_Date, l_fy_end_date
        from fa_fiscal_year
        where fiscal_year = l_fiscal_year
        and fiscal_year_name = l_fiscal_year_name;

Line: 404

        SELECT count(1)
        INTO   l_count
        FROM   FA_TRANSACTION_HEADERS th,
               FA_DEPRN_PERIODS dp
        WHERE  th.asset_id = nvl(p_asset_hdr_rec.asset_id, -1)
        AND    th.book_type_code = nvl(p_asset_hdr_rec.book_type_code,'XX')
        AND    th.transaction_type_code||'' = 'TRANSFER'
        AND    th.transaction_date_entered < dp.calendar_period_open_date
        AND    th.date_effective > dp.period_open_date
        AND    px_trans_rec.transaction_date_entered <
                                dp.calendar_period_open_date
        AND    dp.book_type_code = nvl(p_asset_hdr_rec.book_type_code, 'XX')
        AND    dp.period_close_date IS NULL;

Line: 427

        SELECT count(1)
        INTO   l_count
        FROM   FA_BOOKS bk, FA_DEPRN_PERIODS dp
        WHERE  bk.asset_id = p_asset_hdr_rec.asset_id
        AND    bk.book_type_code = p_asset_hdr_rec.book_type_code
        AND    nvl(period_counter_fully_reserved, 99) <>
                          nvl(period_counter_life_complete, 99)
        AND    bk.date_ineffective IS NULL
        AND    dp.book_type_code = bk.book_type_code
        AND    px_trans_rec.transaction_date_entered <
                                   dp.calendar_period_open_date
        AND    dp.period_close_date IS NULL;

Line: 450

           SELECT   count(1)
             INTO   l_count
             FROM   FA_TRANSACTION_HEADERS th,
                    FA_DEPRN_PERIODS dp,
                    FA_BOOK_CONTROLS bc
             WHERE  th.asset_id = nvl(p_asset_hdr_rec.asset_id, -1)
               AND  th.book_type_code = nvl(p_asset_hdr_rec.book_type_code,'XX')
               AND  th.transaction_type_code||'' = 'TRANSFER'
               AND  th.transaction_date_entered < dp.calendar_period_open_date
               AND  th.date_effective > dp.period_open_date
               AND  px_trans_rec.transaction_date_entered < dp.calendar_period_open_date
               AND  dp.book_type_code = bc.book_type_code
               AND  dp.period_close_date IS NULL
               AND  bc.DISTRIBUTION_SOURCE_BOOK =  nvl(p_asset_hdr_rec.book_type_code,'XX')  ;