[Home] [Help]
327: -- dpis ctr
328: -- ===================================================================
329: FUNCTION Get_Reval_Prd_Dpis_Ctr(p_book_code fa_books.book_type_code%TYPE,
330: p_asset_id fa_books.asset_id%TYPE,
331: p_reval_prd_ctr OUT NOCOPY fa_deprn_summary.period_counter%TYPE
332: )
333: RETURN BOOLEAN
334: IS
335:
362: AND date_ineffective IS NULL;
363:
364: l_dpis fa_books.date_placed_in_service%TYPE;
365: l_ret_flag BOOLEAN;
366: l_get_reval_period fa_deprn_summary.period_counter%TYPE;--c_get_reval_period%type;
367: l_dpis_prd_rec igi_iac_types.prd_rec;
368:
369:
370: BEGIN
576: -- this query should include non depreciating assets as well
577: -- and excludes all fully retired assets for a category
578: CURSOR c_get_assets_one_cat(n_book_code fa_books.book_type_code%TYPE,
579: n_category_id igi_iac_projections.category_id%TYPE DEFAULT NULL,
580: n_period_counter fa_deprn_summary.period_counter%TYPE)
581: IS
582: SELECT DISTINCT fh.asset_id asset_id
583: FROM fa_books fb,
584: fa_additions fh,
590: AND fb.asset_id=fh.asset_id
591: AND fb.period_counter_fully_retired IS NULL
592: AND fh.asset_type <> 'CIP'
593: -- AND fb.asset_id IN (SELECT asset_id
594: -- FROM fa_deprn_summary
595: -- WHERE book_type_code = n_book_code
596: -- AND period_counter = n_period_counter - 1
597: -- AND deprn_source_code <> 'BOOKS')
598: ORDER BY fh.asset_id;
600: -- Get all the assets that should be considered for projection
601: -- this query should include non depreciating assets as well
602: -- and excludes all fully retired assets for all categries
603: CURSOR c_get_assets_all_cat(n_book_code fa_books.book_type_code%TYPE,
604: n_period_counter fa_deprn_summary.period_counter%TYPE)
605: IS
606: SELECT DISTINCT fh.asset_id asset_id
607: FROM fa_books fb,
608: fa_additions fh,
613: AND fb.asset_id=fh.asset_id
614: AND fb.period_counter_fully_retired IS NULL
615: AND fh.asset_type <> 'CIP'
616: -- AND fb.asset_id IN (SELECT asset_id
617: -- FROM fa_deprn_summary
618: -- WHERE book_type_code = n_book_code
619: -- AND period_counter = n_period_counter - 1
620: -- AND deprn_source_code <> 'BOOKS')
621: ORDER BY fh.asset_id;