APPS.FA_REC_PVT_PKG1 SQL Statements

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

Line: 111

    SELECT count(*)
      INTO l_is_retired
      FROM FA_BOOKS   BK,
           FA_BOOK_CONTROLS BC
     WHERE
           BK.ASSET_ID = p_asset_id AND
           BK.PERIOD_COUNTER_FULLY_RETIRED IS NOT NULL AND
           BK.DATE_INEFFECTIVE IS NULL AND
           BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE AND
           BC.DATE_INEFFECTIVE IS NULL;

Line: 131

    SELECT count(1) INTO l_pending_retirements
    FROM fa_retirements
    WHERE asset_id = p_asset_id
    AND status IN ('PENDING', 'REINSTATE')
    AND rownum < 2;

Line: 180

	    SELECT asset_type FROM FA_ADDITIONS
    	    WHERE asset_id = p_asset_id;

Line: 183

	    SELECT capitalize_flag, category_type
    	    FROM FA_CATEGORIES WHERE category_id = p_old_category_id;

Line: 186

	    SELECT lease_id FROM FA_ADDITIONS
	    WHERE asset_id = p_asset_id;

Line: 189

	    SELECT units FROM FA_ASSET_HISTORY
	    WHERE asset_id = p_asset_id
	    AND date_ineffective IS NULL;

Line: 193

	    SELECT sum(units_assigned) FROM FA_DISTRIBUTION_HISTORY
	    WHERE asset_id = p_asset_id
	    AND date_ineffective is NULL;

Line: 217

    SELECT count(*) INTO l_check_count1
    FROM FA_CATEGORY_BOOKS cb, FA_BOOKS bk, fa_book_controls bc
    WHERE bk.asset_id = p_asset_id
    AND bk.date_ineffective IS NULL
    AND bk.book_type_code = cb.book_type_code
    AND cb.category_id = p_new_category_id
    AND bc.book_type_code = bk.book_type_code
    AND nvl(bc.date_ineffective,sysdate) >= sysdate;

Line: 227

    SELECT count(*) INTO l_check_count2
    FROM FA_BOOKS bk, FA_BOOK_CONTROLS bc
    WHERE bk.asset_id = p_asset_id
    AND bk.date_ineffective IS NULL
    AND bk.book_type_code = bc.book_type_code
    AND nvl(bc.date_ineffective,sysdate) >= sysdate;

Line: 317

            SELECT      max(transaction_date_entered)
            FROM        FA_TRANSACTION_HEADERS
            WHERE       asset_id = p_asset_id
            AND         book_type_code = p_book_type_code
            AND         transaction_type_code not like '%/VOID';

Line: 324

            SELECT      max(date_effective)
            FROM        FA_TRANSACTION_HEADERS
            WHERE       asset_id = p_asset_id
            AND         book_type_code = p_book_type_code;

Line: 347

    SELECT count(1) INTO check_another_trans
    FROM FA_DEPRN_PERIODS pdp, FA_DEPRN_PERIODS adp
    WHERE pdp.book_type_code = p_book_type_code
    AND pdp.book_type_code = adp.book_type_code
    AND pdp.period_counter > adp.period_counter
    AND prior_date_effective between pdp.period_open_date
            and nvl(pdp.period_close_date, to_date('31-12-4712','DD-MM-YYYY'))
    AND p_trans_date between
            adp.calendar_period_open_date and adp.calendar_period_close_date;