eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_IAC_PROJ_PKG dependencies on FA_BOOKS

Line 60: FUNCTION Non_Depreciating_Asset(x_asset_id IN fa_books.asset_id%TYPE,

56: -- ===================================================================
57: -- FUNCTION Non_Depreciating_Asset: The function will check if the
58: -- asset is a non depreciating asset
59: -- ===================================================================
60: FUNCTION Non_Depreciating_Asset(x_asset_id IN fa_books.asset_id%TYPE,
61: x_book_code IN fa_books.book_type_code%TYPE)
62: RETURN BOOLEAN AS
63: l_exists NUMBER := 0;
64:

Line 61: x_book_code IN fa_books.book_type_code%TYPE)

57: -- FUNCTION Non_Depreciating_Asset: The function will check if the
58: -- asset is a non depreciating asset
59: -- ===================================================================
60: FUNCTION Non_Depreciating_Asset(x_asset_id IN fa_books.asset_id%TYPE,
61: x_book_code IN fa_books.book_type_code%TYPE)
62: RETURN BOOLEAN AS
63: l_exists NUMBER := 0;
64:
65: BEGIN

Line 69: FROM fa_books

65: BEGIN
66:
67: SELECT count(*)
68: INTO l_exists
69: FROM fa_books
70: WHERE depreciate_flag = 'NO'
71: AND transaction_header_id_out IS NULL
72: AND book_type_code = x_book_code
73: AND asset_id = x_asset_id;

Line 93: p_book_type_code IN fa_books.book_type_code%type,

89: -- PROCEDURE Submit_Report_Request: Procedure to submit the
90: -- concurrent request for running the Projections report
91: -- ===================================================================
92: PROCEDURE submit_report_request(p_projection_id IN igi_iac_projections.projection_id%type,
93: p_book_type_code IN fa_books.book_type_code%type,
94: p_reval_period_num IN igi_iac_projections.revaluation_period%type,
95: p_concat_cat IN varchar2,
96: p_start_period_name IN varchar2,
97: p_end_period_name IN varchar2,

Line 250: FUNCTION Get_Price_Index_Val(p_book_code fa_books.book_type_code%TYPE,

246: -- ===================================================================
247: -- FUNCTION Get_Price_Index_Val: get the price index value for the book,
248: -- category and period
249: -- ===================================================================
250: FUNCTION Get_Price_Index_Val(p_book_code fa_books.book_type_code%TYPE,
251: p_category_id fa_category_books.category_id%TYPE,
252: p_period_ctr fa_deprn_periods.period_counter%TYPE,
253: p_price_index_val OUT NOCOPY igi_iac_cal_idx_values.current_price_index_value%TYPE
254: )

Line 259: CURSOR c_get_calendar(n_book_type_code fa_books.book_type_code%TYPE)

255: RETURN BOOLEAN
256: IS
257:
258: -- To get deprn calendar
259: CURSOR c_get_calendar(n_book_type_code fa_books.book_type_code%TYPE)
260: IS
261: SELECT deprn_calendar
262: FROM fa_book_controls
263: WHERE book_type_code = n_book_type_code;

Line 266: CURSOR c_get_price_index_value(n_book_code fa_books.book_type_code%TYPE,

262: FROM fa_book_controls
263: WHERE book_type_code = n_book_type_code;
264:
265: -- To get the price index value for a given period
266: CURSOR c_get_price_index_value(n_book_code fa_books.book_type_code%TYPE,
267: n_category_id fa_category_books.category_id%TYPE,
268: n_start_date fa_calendar_periods.start_date%TYPE,
269: n_end_date fa_calendar_periods.end_date%TYPE,
270: n_calendar_type fa_calendar_periods.calendar_type%TYPE

Line 329: FUNCTION Get_Reval_Prd_Dpis_Ctr(p_book_code fa_books.book_type_code%TYPE,

325: -- return the DPIS period_counter
326: -- the parameter l_reval_prd_ctr returns the either reval_prd or
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

Line 330: p_asset_id fa_books.asset_id%TYPE,

326: -- the parameter l_reval_prd_ctr returns the either reval_prd or
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

Line 337: CURSOR c_get_reval_period(n_book_code fa_books.book_type_code%TYPE,

333: RETURN BOOLEAN
334: IS
335:
336: -- get the revaluation period counter
337: CURSOR c_get_reval_period(n_book_code fa_books.book_type_code%TYPE,
338: n_asset_id fa_books.asset_id%TYPE
339: )
340: IS
341: SELECT MAX(irr.period_counter) period_counter

Line 338: n_asset_id fa_books.asset_id%TYPE

334: IS
335:
336: -- get the revaluation period counter
337: CURSOR c_get_reval_period(n_book_code fa_books.book_type_code%TYPE,
338: n_asset_id fa_books.asset_id%TYPE
339: )
340: IS
341: SELECT MAX(irr.period_counter) period_counter
342: FROM igi_iac_revaluation_rates irr

Line 354: CURSOR c_get_dpis(n_book_code fa_books.book_type_code%TYPE,

350: AND adjustment_status<>'PREVIEW');
351:
352:
353: -- Cursor to get the Date Placed in Service of the asset
354: CURSOR c_get_dpis(n_book_code fa_books.book_type_code%TYPE,
355: n_asset_id fa_books.asset_id%TYPE
356: )
357: IS
358: SELECT date_placed_in_service

Line 355: n_asset_id fa_books.asset_id%TYPE

351:
352:
353: -- Cursor to get the Date Placed in Service of the asset
354: CURSOR c_get_dpis(n_book_code fa_books.book_type_code%TYPE,
355: n_asset_id fa_books.asset_id%TYPE
356: )
357: IS
358: SELECT date_placed_in_service
359: FROM fa_books

Line 359: FROM fa_books

355: n_asset_id fa_books.asset_id%TYPE
356: )
357: IS
358: SELECT date_placed_in_service
359: FROM fa_books
360: WHERE book_type_code = n_book_code
361: AND asset_id = n_asset_id
362: AND date_ineffective IS NULL;
363:

Line 364: l_dpis fa_books.date_placed_in_service%TYPE;

360: WHERE book_type_code = n_book_code
361: AND asset_id = n_asset_id
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:

Line 414: p_book_code IN fa_books.book_type_code%TYPE,

410: -- PROCEDURE Get_Next_Period_Ctr: Procedure will retrieve the next
411: -- period counter
412: -- ===================================================================
413: PROCEDURE Get_Next_Period_Ctr(p_period_rec IN igi_iac_types.prd_rec,
414: p_book_code IN fa_books.book_type_code%TYPE,
415: p_next_period_ctr OUT NOCOPY fa_deprn_periods.period_counter%TYPE)
416: IS
417:
418: -- get the number of periods per fiscal year

Line 426: CURSOR c_get_calendar(n_book_code fa_books.book_type_code%TYPE)

422: FROM fa_calendar_types
423: WHERE calendar_type = n_calendar;
424:
425: -- Get deprn calendar
426: CURSOR c_get_calendar(n_book_code fa_books.book_type_code%TYPE)
427: IS
428: SELECT deprn_calendar
429: FROM fa_book_controls
430: WHERE book_type_code = n_book_code;

Line 471: FUNCTION Chk_Asset_Life( p_book_code fa_books.book_type_code%TYPE,

467: -- ===================================================================
468: -- FUNCTION Chk_Asset_Life: Find if the life of asset is completed in
469: -- the given period
470: -- ===================================================================
471: FUNCTION Chk_Asset_Life( p_book_code fa_books.book_type_code%TYPE,
472: p_period_counter fa_deprn_periods.period_counter%TYPE,
473: p_asset_id fa_books.asset_id%TYPE,
474: l_last_period_counter OUT NOCOPY fa_deprn_periods.period_counter%TYPE
475: )

Line 473: p_asset_id fa_books.asset_id%TYPE,

469: -- the given period
470: -- ===================================================================
471: FUNCTION Chk_Asset_Life( p_book_code fa_books.book_type_code%TYPE,
472: p_period_counter fa_deprn_periods.period_counter%TYPE,
473: p_asset_id fa_books.asset_id%TYPE,
474: l_last_period_counter OUT NOCOPY fa_deprn_periods.period_counter%TYPE
475: )
476: RETURN BOOLEAN
477: IS

Line 479: CURSOR c_get_asset_det(n_book_code fa_books.book_type_code%TYPE,

475: )
476: RETURN BOOLEAN
477: IS
478:
479: CURSOR c_get_asset_det(n_book_code fa_books.book_type_code%TYPE,
480: n_asset_id fa_books.asset_id%TYPE
481: )
482: IS
483: SELECT date_placed_in_service,

Line 480: n_asset_id fa_books.asset_id%TYPE

476: RETURN BOOLEAN
477: IS
478:
479: CURSOR c_get_asset_det(n_book_code fa_books.book_type_code%TYPE,
480: n_asset_id fa_books.asset_id%TYPE
481: )
482: IS
483: SELECT date_placed_in_service,
484: life_in_months

Line 485: FROM fa_books

481: )
482: IS
483: SELECT date_placed_in_service,
484: life_in_months
485: FROM fa_books
486: WHERE book_type_code = n_book_code
487: AND date_ineffective is NULL -- Bug 5850597
488: AND asset_id = n_asset_id;
489:

Line 490: CURSOR c_get_periods_in_year(n_book_code fa_books.book_type_code%TYPE)

486: WHERE book_type_code = n_book_code
487: AND date_ineffective is NULL -- Bug 5850597
488: AND asset_id = n_asset_id;
489:
490: CURSOR c_get_periods_in_year(n_book_code fa_books.book_type_code%TYPE)
491: IS
492: SELECT number_per_fiscal_year
493: FROM fa_calendar_types
494: WHERE calendar_type = (SELECT deprn_calendar

Line 578: CURSOR c_get_assets_one_cat(n_book_code fa_books.book_type_code%TYPE,

574:
575: -- Get all the assets that should be considered for projection
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

Line 583: FROM fa_books fb,

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,
585: igi_iac_category_books fcb
586: WHERE fb.book_type_code = n_book_code
587: AND fb.book_type_code = fcb.book_type_code

Line 603: CURSOR c_get_assets_all_cat(n_book_code fa_books.book_type_code%TYPE,

599:
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,

Line 607: FROM fa_books fb,

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,
609: igi_iac_category_books fcb
610: WHERE fb.book_type_code = n_book_code
611: AND fb.book_type_code = fcb.book_type_code

Line 626: CURSOR c_get_asset_all(n_book_type_code fa_books.book_type_code%TYPE,

622:
623: -- Get all the latest records for the given asset of the given book for which the deprn had
624: -- been run
625: -- get the information from the distribution level
626: CURSOR c_get_asset_all(n_book_type_code fa_books.book_type_code%TYPE,
627: n_asset_id fa_books.asset_id%TYPE )
628: IS
629: SELECT ad.asset_id,
630: dh.code_combination_id,

Line 627: n_asset_id fa_books.asset_id%TYPE )

623: -- Get all the latest records for the given asset of the given book for which the deprn had
624: -- been run
625: -- get the information from the distribution level
626: CURSOR c_get_asset_all(n_book_type_code fa_books.book_type_code%TYPE,
627: n_asset_id fa_books.asset_id%TYPE )
628: IS
629: SELECT ad.asset_id,
630: dh.code_combination_id,
631: ah.category_id,

Line 638: fa_Books bk ,

634: sum(nvl(id.Deprn_Period+dd.deprn_amount-dd.deprn_adjustment_amount, 0)) deprn_period,
635: sum(nvl(id.Deprn_YTD+ifd.deprn_ytd, 0)) deprn_ytd,
636: 'IAC' source_type
637: FROM fa_additions ad ,
638: fa_Books bk ,
639: fa_distribution_history dh,
640: fa_deprn_Detail dd ,
641: igi_iac_det_balances id ,
642: igi_iac_fa_deprn ifd,

Line 688: fa_Books bk,

684: sum(nvl(dd.deprn_amount,0)-nvl(dd.deprn_adjustment_amount,0)) deprn_period,
685: sum(nvl(dd.ytd_deprn,0)) deprn_ytd,
686: 'FA' source_type
687: FROM fa_additions ad,
688: fa_Books bk,
689: fa_distribution_history dh,
690: fa_deprn_Detail dd,
691: gl_code_combinations cc,
692: fa_categories cf,

Line 732: fa_Books bk,

728: 0 deprn_period,
729: 0 deprn_ytd,
730: 'NONDEPFA' source_type
731: FROM fa_additions ad,
732: fa_Books bk,
733: fa_distribution_history dh,
734: fa_deprn_Detail dd,
735: gl_code_combinations cc,
736: fa_categories cf,

Line 771: fa_Books bk,

767: sum(nvl(dd.deprn_amount,0)-nvl(dd.deprn_adjustment_amount,0)) deprn_period,
768: sum(nvl(dd.ytd_deprn,0)) deprn_ytd,
769: 'FULLRSVDFA' source_type
770: FROM fa_additions ad,
771: fa_Books bk,
772: fa_distribution_history dh,
773: fa_deprn_Detail dd,
774: gl_code_combinations cc,
775: fa_categories cf,

Line 792: FROM fa_books

788: AND dh.asset_id = ah.asset_id
789: AND nvl(dh.date_ineffective,sysdate+1) > ah.date_effective
790: AND nvl(dh.date_ineffective,sysdate+1) <= nvl(ah.date_ineffective,sysdate+1)
791: AND dd.period_counter = (SELECT period_counter_fully_reserved
792: FROM fa_books
793: WHERE book_type_code = n_book_type_code
794: AND asset_id = n_asset_id
795: AND date_ineffective IS NULL
796: AND transaction_header_id_out IS NULL)

Line 803: CURSOR c_iac_non_deprn(n_asset_id fa_books.asset_id%TYPE,

799: ah.category_id,
800: dd.period_counter;
801:
802: -- cursor to get non depreciating IAC data
803: CURSOR c_iac_non_deprn(n_asset_id fa_books.asset_id%TYPE,
804: n_book_code fa_books.book_type_code%TYPE)
805: IS
806: SELECT NVL(SUM(NVL(dd.adjustment_cost,0)),0)
807: FROM igi_iac_det_balances dd,

Line 804: n_book_code fa_books.book_type_code%TYPE)

800: dd.period_counter;
801:
802: -- cursor to get non depreciating IAC data
803: CURSOR c_iac_non_deprn(n_asset_id fa_books.asset_id%TYPE,
804: n_book_code fa_books.book_type_code%TYPE)
805: IS
806: SELECT NVL(SUM(NVL(dd.adjustment_cost,0)),0)
807: FROM igi_iac_det_balances dd,
808: fa_books fb

Line 808: fa_books fb

804: n_book_code fa_books.book_type_code%TYPE)
805: IS
806: SELECT NVL(SUM(NVL(dd.adjustment_cost,0)),0)
807: FROM igi_iac_det_balances dd,
808: fa_books fb
809: WHERE dd.book_type_code = fb.book_type_code
810: AND dd.asset_id = fb.asset_id
811: AND dd.book_type_code = n_book_code
812: AND dd.asset_id = n_asset_id

Line 822: /* CURSOR c_iac_full_rsvd(n_asset_id fa_books.asset_id%TYPE,

818: AND ith.asset_id = n_Asset_id
819: AND ith.adjustment_status NOT IN( 'PREVIEW', 'OBSOLETE'));
820:
821: -- cursor to get fully reserved IAC data
822: /* CURSOR c_iac_full_rsvd(n_asset_id fa_books.asset_id%TYPE,
823: n_book_code fa_books.book_type_code%TYPE)
824: IS
825: SELECT NVL(SUM(NVL(dd.adjustment_cost,0)),0) adjustment_cost,
826: NVL(sum(nvl(dd.Deprn_Period, 0)),0) deprn_period,

Line 823: n_book_code fa_books.book_type_code%TYPE)

819: AND ith.adjustment_status NOT IN( 'PREVIEW', 'OBSOLETE'));
820:
821: -- cursor to get fully reserved IAC data
822: /* CURSOR c_iac_full_rsvd(n_asset_id fa_books.asset_id%TYPE,
823: n_book_code fa_books.book_type_code%TYPE)
824: IS
825: SELECT NVL(SUM(NVL(dd.adjustment_cost,0)),0) adjustment_cost,
826: NVL(sum(nvl(dd.Deprn_Period, 0)),0) deprn_period,
827: NVL(sum(nvl(dd.Deprn_YTD+ifd.deprn_ytd, 0)),0) deprn_ytd

Line 830: fa_books fb

826: NVL(sum(nvl(dd.Deprn_Period, 0)),0) deprn_period,
827: NVL(sum(nvl(dd.Deprn_YTD+ifd.deprn_ytd, 0)),0) deprn_ytd
828: FROM igi_iac_det_balances dd,
829: igi_iac_fa_deprn ifd,
830: fa_books fb
831: WHERE dd.book_type_code = fb.book_type_code
832: AND dd.asset_id = fb.asset_id
833: AND dd.distribution_id = ifd.distribution_id
834: AND dd.adjustment_id = ifd.adjustment_id

Line 847: CURSOR c_chk_fully_rsvd (n_asset_id fa_books.asset_id%TYPE,

843: AND ith.asset_id = n_Asset_id
844: AND ith.adjustment_status NOT IN( 'PREVIEW', 'OBSOLETE'));
845: */
846: -- check to see if the asset is fully reserved
847: CURSOR c_chk_fully_rsvd (n_asset_id fa_books.asset_id%TYPE,
848: n_book_code fa_books.book_type_code%TYPE)
849: IS
850: SELECT period_counter_fully_reserved
851: FROM fa_books where book_type_code = n_book_code

Line 848: n_book_code fa_books.book_type_code%TYPE)

844: AND ith.adjustment_status NOT IN( 'PREVIEW', 'OBSOLETE'));
845: */
846: -- check to see if the asset is fully reserved
847: CURSOR c_chk_fully_rsvd (n_asset_id fa_books.asset_id%TYPE,
848: n_book_code fa_books.book_type_code%TYPE)
849: IS
850: SELECT period_counter_fully_reserved
851: FROM fa_books where book_type_code = n_book_code
852: AND asset_id = n_asset_id;

Line 851: FROM fa_books where book_type_code = n_book_code

847: CURSOR c_chk_fully_rsvd (n_asset_id fa_books.asset_id%TYPE,
848: n_book_code fa_books.book_type_code%TYPE)
849: IS
850: SELECT period_counter_fully_reserved
851: FROM fa_books where book_type_code = n_book_code
852: AND asset_id = n_asset_id;
853:
854: -- cursor to retrieve the DPIS date for an asset
855: CURSOR c_get_asset_dpis(n_asset_id fa_books.asset_id%TYPE,

Line 855: CURSOR c_get_asset_dpis(n_asset_id fa_books.asset_id%TYPE,

851: FROM fa_books where book_type_code = n_book_code
852: AND asset_id = n_asset_id;
853:
854: -- cursor to retrieve the DPIS date for an asset
855: CURSOR c_get_asset_dpis(n_asset_id fa_books.asset_id%TYPE,
856: n_book_type_code fa_books.book_type_code%TYPE)
857: IS
858: SELECT date_placed_in_service
859: FROM fa_books

Line 856: n_book_type_code fa_books.book_type_code%TYPE)

852: AND asset_id = n_asset_id;
853:
854: -- cursor to retrieve the DPIS date for an asset
855: CURSOR c_get_asset_dpis(n_asset_id fa_books.asset_id%TYPE,
856: n_book_type_code fa_books.book_type_code%TYPE)
857: IS
858: SELECT date_placed_in_service
859: FROM fa_books
860: WHERE asset_id = n_asset_id

Line 859: FROM fa_books

855: CURSOR c_get_asset_dpis(n_asset_id fa_books.asset_id%TYPE,
856: n_book_type_code fa_books.book_type_code%TYPE)
857: IS
858: SELECT date_placed_in_service
859: FROM fa_books
860: WHERE asset_id = n_asset_id
861: AND book_type_code = n_book_type_code
862: AND date_ineffective IS NULL;
863:

Line 866: TYPE asset_id_type IS TABLE OF fa_books.asset_id%TYPE INDEX BY BINARY_INTEGER;

862: AND date_ineffective IS NULL;
863:
864: -- variables
865: -- variables for projection detail records
866: TYPE asset_id_type IS TABLE OF fa_books.asset_id%TYPE INDEX BY BINARY_INTEGER;
867:
868: TYPE asset_id_type1 IS TABLE OF igi_iac_proj_details.asset_id%TYPE INDEX BY BINARY_INTEGER;
869: TYPE proj_id_type IS TABLE OF igi_iac_proj_details.projection_id%TYPE INDEX BY BINARY_INTEGER;
870: TYPE period_counter_type IS TABLE OF igi_iac_proj_details.projection_id%TYPE INDEX BY BINARY_INTEGER;

Line 899: l_asset_id fa_books.asset_id%TYPE;

895:
896: l_proj_rec proj_details;
897: l_assets_list asset_id_type;
898: l_asset_count NUMBER;
899: l_asset_id fa_books.asset_id%TYPE;
900:
901: l_book_type_code igi_iac_projections.book_type_code%TYPE;
902: l_start_period_counter igi_iac_projections.start_period_counter%TYPE;
903: l_reval_period_ctr igi_iac_projections.start_period_counter%TYPE;

Line 912: l_asset_dpis_date fa_books.date_placed_in_service%TYPE;

908: l_status igi_iac_projections.status%TYPE;
909:
910: l_sob_id fa_book_controls.set_of_books_id%TYPE;
911: l_get_asset_bal_rec c_get_asset_all%ROWTYPE;
912: l_asset_dpis_date fa_books.date_placed_in_service%TYPE;
913:
914: l_next_period_ctr igi_iac_projections.start_period_counter%TYPE := 0;
915: l_period_info_rec igi_iac_types.prd_rec;
916: l_dpis_info_rec igi_iac_types.prd_rec;

Line 918: l_fully_rsvd fa_books.period_counter_fully_reserved%TYPE;

914: l_next_period_ctr igi_iac_projections.start_period_counter%TYPE := 0;
915: l_period_info_rec igi_iac_types.prd_rec;
916: l_dpis_info_rec igi_iac_types.prd_rec;
917: l_ret_flag BOOLEAN;
918: l_fully_rsvd fa_books.period_counter_fully_reserved%TYPE;
919: l_company_seg VARCHAR2(30);
920: l_cc_seg VARCHAR2(30);
921:
922: l_hist_cost fa_books.cost%TYPE;

Line 922: l_hist_cost fa_books.cost%TYPE;

918: l_fully_rsvd fa_books.period_counter_fully_reserved%TYPE;
919: l_company_seg VARCHAR2(30);
920: l_cc_seg VARCHAR2(30);
921:
922: l_hist_cost fa_books.cost%TYPE;
923: l_iac_cost igi_iac_asset_balances.adjusted_cost%TYPE;
924: l_hist_deprn_period igi_iac_proj_details.deprn_period%TYPE;
925: l_iac_deprn_period igi_iac_proj_details.deprn_period%TYPE;
926: l_hist_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;

Line 929: l_curr_cost fa_books.cost%TYPE;

925: l_iac_deprn_period igi_iac_proj_details.deprn_period%TYPE;
926: l_hist_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
927: l_iac_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
928:
929: l_curr_cost fa_books.cost%TYPE;
930: l_prev_cost fa_books.cost%TYPE;
931: l_curr_deprn_period igi_iac_proj_details.deprn_period%TYPE;
932: l_prev_deprn_period igi_iac_proj_details.deprn_period%TYPE;
933: l_curr_deprn_period_catchup igi_iac_proj_details.deprn_period%TYPE;

Line 930: l_prev_cost fa_books.cost%TYPE;

926: l_hist_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
927: l_iac_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
928:
929: l_curr_cost fa_books.cost%TYPE;
930: l_prev_cost fa_books.cost%TYPE;
931: l_curr_deprn_period igi_iac_proj_details.deprn_period%TYPE;
932: l_prev_deprn_period igi_iac_proj_details.deprn_period%TYPE;
933: l_curr_deprn_period_catchup igi_iac_proj_details.deprn_period%TYPE;
934: l_curr_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;