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_RXI_I_WRAP_ASSET_BAL dependencies on FA_CATEGORY_BOOKS

Line 105: ,p_deprn_res_acct IN OUT NOCOPY fa_category_books.deprn_reserve_acct%TYPE

101: RETURN BOOLEAN;
102:
103: FUNCTION get_acct_seg_values ( p_bookType IN VARCHAR2
104: ,p_categoryId IN NUMBER
105: ,p_deprn_res_acct IN OUT NOCOPY fa_category_books.deprn_reserve_acct%TYPE
106: ,p_deprn_exp_acct IN OUT NOCOPY fa_category_books.deprn_expense_acct%TYPE)
107: RETURN BOOLEAN;
108:
109: FUNCTION get_acct_seg_val_from_ccid ( p_bookType IN VARCHAR2

Line 106: ,p_deprn_exp_acct IN OUT NOCOPY fa_category_books.deprn_expense_acct%TYPE)

102:
103: FUNCTION get_acct_seg_values ( p_bookType IN VARCHAR2
104: ,p_categoryId IN NUMBER
105: ,p_deprn_res_acct IN OUT NOCOPY fa_category_books.deprn_reserve_acct%TYPE
106: ,p_deprn_exp_acct IN OUT NOCOPY fa_category_books.deprn_expense_acct%TYPE)
107: RETURN BOOLEAN;
108:
109: FUNCTION get_acct_seg_val_from_ccid ( p_bookType IN VARCHAR2
110: ,p_categoryId IN NUMBER

Line 638: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;

634: l_asset_tag fa_additions.tag_number%TYPE;
635: l_serial_number fa_additions.serial_number%TYPE;
636: l_life_in_months fa_Books.life_in_months%TYPE;
637: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
638: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
639: l_depreciation_method fa_Books.deprn_method_code%TYPE;
640: l_location_id fa_distribution_history.location_id%TYPE;
641: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
642: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;

Line 642: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;

638: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
639: l_depreciation_method fa_Books.deprn_method_code%TYPE;
640: l_location_id fa_distribution_history.location_id%TYPE;
641: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
642: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
643: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
644: l_dep_backlog NUMBER;
645: l_gen_fund_acct NUMBER;
646: l_oper_exp_acct NUMBER;

Line 643: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;

639: l_depreciation_method fa_Books.deprn_method_code%TYPE;
640: l_location_id fa_distribution_history.location_id%TYPE;
641: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
642: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
643: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
644: l_dep_backlog NUMBER;
645: l_gen_fund_acct NUMBER;
646: l_oper_exp_acct NUMBER;
647: l_reval_rsv_acct NUMBER;

Line 688: fa_category_books cb,

684: fa_deprn_Detail dd,
685: gl_code_combinations cc,
686: fa_categories cf,
687: fa_asset_history ah,
688: fa_category_books cb,
689: fa_book_controls fb,
690: fa_deprn_periods fdp
691: WHERE ad.asset_id = bk.asset_id
692: AND cf.category_id = ah.category_id

Line 768: fa_category_books cb,

764: igi_iac_fa_deprn ifd,
765: gl_code_combinations cc,
766: fa_categories cf,
767: fa_asset_history ah,
768: fa_category_books cb,
769: fa_book_controls fb,
770: fa_deprn_periods fd,
771: fa_deprn_periods fdp
772: WHERE ad.asset_id = bk.asset_id

Line 1031: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;

1027: l_parent_no VARCHAR2(15);
1028: l_serial_number fa_additions.serial_number%TYPE;
1029: l_life_in_months fa_Books.life_in_months%TYPE;
1030: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
1031: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
1032: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1033: l_location_id fa_distribution_history.location_id%TYPE;
1034: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
1035: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;

Line 1035: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;

1031: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
1032: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1033: l_location_id fa_distribution_history.location_id%TYPE;
1034: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
1035: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
1036: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
1037: l_dep_backlog NUMBER;
1038: l_gen_fund_acct NUMBER;
1039: l_oper_exp_acct NUMBER;

Line 1036: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;

1032: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1033: l_location_id fa_distribution_history.location_id%TYPE;
1034: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
1035: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
1036: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
1037: l_dep_backlog NUMBER;
1038: l_gen_fund_acct NUMBER;
1039: l_oper_exp_acct NUMBER;
1040: l_reval_rsv_acct NUMBER;

Line 1093: fa_category_books cb,

1089: fa_deprn_Detail dd,
1090: gl_code_combinations cc,
1091: fa_categories cf,
1092: fa_asset_history ah,
1093: fa_category_books cb,
1094: fa_book_controls fb,
1095: fa_deprn_periods fdp
1096: WHERE ad.asset_id = bk.asset_id
1097: AND cf.category_id = ah.category_id

Line 1192: fa_category_books cb,

1188: igi_iac_fa_deprn ifd,
1189: gl_code_combinations cc,
1190: fa_categories cf,
1191: fa_asset_history ah,
1192: fa_category_books cb,
1193: fa_book_controls fb,
1194: fa_deprn_periods fd,
1195: fa_deprn_periods fdp
1196: WHERE ad.asset_id = bk.asset_id

Line 1548: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;

1544: l_asset_tag fa_additions.tag_number%TYPE;
1545: l_serial_number fa_additions.serial_number%TYPE;
1546: l_life_in_months fa_Books.life_in_months%TYPE;
1547: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
1548: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
1549: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1550: l_location_id fa_distribution_history.location_id%TYPE;
1551: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
1552: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;

Line 1552: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;

1548: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
1549: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1550: l_location_id fa_distribution_history.location_id%TYPE;
1551: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
1552: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
1553: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
1554: l_dep_backlog NUMBER;
1555: l_gen_fund_acct NUMBER;
1556: l_oper_exp_acct NUMBER;

Line 1553: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;

1549: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1550: l_location_id fa_distribution_history.location_id%TYPE;
1551: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
1552: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
1553: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
1554: l_dep_backlog NUMBER;
1555: l_gen_fund_acct NUMBER;
1556: l_oper_exp_acct NUMBER;
1557: l_reval_rsv_acct NUMBER;

Line 1597: fa_category_books cb,

1593: fa_distribution_history dh,
1594: fa_deprn_Detail dd,
1595: gl_code_combinations cc,
1596: fa_categories cf,
1597: fa_category_books cb,
1598: fa_book_controls fb,
1599: fa_deprn_periods fdp,
1600: fa_asset_history ah
1601: WHERE ad.asset_id = bk.asset_id

Line 1674: fa_category_books cb,

1670: fa_deprn_Detail dd ,
1671: igi_iac_det_balances id ,
1672: gl_code_combinations cc,
1673: fa_categories cf,
1674: fa_category_books cb,
1675: fa_book_controls fb,
1676: fa_deprn_periods fdp,
1677: fa_asset_history ah
1678: WHERE ad.asset_id = bk.asset_id

Line 1924: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;

1920: l_parent_no VARCHAR2(15);
1921: l_serial_number fa_additions.serial_number%TYPE;
1922: l_life_in_months fa_Books.life_in_months%TYPE;
1923: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
1924: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
1925: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1926: l_location_id fa_distribution_history.location_id%TYPE;
1927: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
1928: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;

Line 1928: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;

1924: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
1925: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1926: l_location_id fa_distribution_history.location_id%TYPE;
1927: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
1928: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
1929: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
1930: l_dep_backlog NUMBER;
1931: l_gen_fund_acct NUMBER;
1932: l_oper_exp_acct NUMBER;

Line 1929: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;

1925: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1926: l_location_id fa_distribution_history.location_id%TYPE;
1927: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
1928: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
1929: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
1930: l_dep_backlog NUMBER;
1931: l_gen_fund_acct NUMBER;
1932: l_oper_exp_acct NUMBER;
1933: l_reval_rsv_acct NUMBER;

Line 1985: fa_category_books cb,

1981: fa_distribution_history dh,
1982: fa_deprn_Detail dd,
1983: gl_code_combinations cc,
1984: fa_categories cf,
1985: fa_category_books cb,
1986: fa_book_controls fb,
1987: fa_deprn_periods fdp,
1988: fa_asset_history ah
1989: WHERE ad.asset_id = bk.asset_id

Line 2081: fa_category_books cb,

2077: fa_deprn_Detail dd ,
2078: igi_iac_det_balances id ,
2079: gl_code_combinations cc,
2080: fa_categories cf,
2081: fa_category_books cb,
2082: fa_book_controls fb,
2083: fa_deprn_periods fdp,
2084: fa_asset_history ah
2085: WHERE ad.asset_id = bk.asset_id

Line 2432: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;

2428: l_asset_tag fa_additions.tag_number%TYPE;
2429: l_serial_number fa_additions.serial_number%TYPE;
2430: l_life_in_months fa_Books.life_in_months%TYPE;
2431: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
2432: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
2433: l_depreciation_method fa_Books.deprn_method_code%TYPE;
2434: l_location_id fa_distribution_history.location_id%TYPE;
2435: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
2436: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;

Line 2436: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;

2432: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
2433: l_depreciation_method fa_Books.deprn_method_code%TYPE;
2434: l_location_id fa_distribution_history.location_id%TYPE;
2435: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
2436: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
2437: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
2438: l_dep_backlog NUMBER;
2439: l_gen_fund_acct NUMBER;
2440: l_oper_exp_acct NUMBER;

Line 2437: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;

2433: l_depreciation_method fa_Books.deprn_method_code%TYPE;
2434: l_location_id fa_distribution_history.location_id%TYPE;
2435: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
2436: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
2437: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
2438: l_dep_backlog NUMBER;
2439: l_gen_fund_acct NUMBER;
2440: l_oper_exp_acct NUMBER;
2441: l_reval_rsv_acct NUMBER;

Line 2481: fa_category_books cb,

2477: fa_distribution_history dh,
2478: fa_deprn_Detail dd,
2479: gl_code_combinations cc,
2480: fa_categories cf,
2481: fa_category_books cb,
2482: fa_book_controls fb,
2483: fa_deprn_periods fdp,
2484: fa_asset_history ah
2485: WHERE ad.asset_id = bk.asset_id

Line 2560: fa_category_books cb,

2556: fa_deprn_Detail dd ,
2557: igi_iac_det_balances id ,
2558: gl_code_combinations cc,
2559: fa_categories cf,
2560: fa_category_books cb,
2561: fa_book_controls fb,
2562: fa_deprn_periods fdp,
2563: fa_asset_history ah
2564: WHERE ad.asset_id = dh.asset_id

Line 2823: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;

2819: l_parent_no VARCHAR2(15);
2820: l_serial_number fa_additions.serial_number%TYPE;
2821: l_life_in_months fa_Books.life_in_months%TYPE;
2822: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
2823: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
2824: l_depreciation_method fa_Books.deprn_method_code%TYPE;
2825: l_location_id fa_distribution_history.location_id%TYPE;
2826: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
2827: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;

Line 2827: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;

2823: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
2824: l_depreciation_method fa_Books.deprn_method_code%TYPE;
2825: l_location_id fa_distribution_history.location_id%TYPE;
2826: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
2827: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
2828: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
2829: l_dep_backlog NUMBER;
2830: l_gen_fund_acct NUMBER;
2831: l_oper_exp_acct NUMBER;

Line 2828: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;

2824: l_depreciation_method fa_Books.deprn_method_code%TYPE;
2825: l_location_id fa_distribution_history.location_id%TYPE;
2826: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
2827: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
2828: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
2829: l_dep_backlog NUMBER;
2830: l_gen_fund_acct NUMBER;
2831: l_oper_exp_acct NUMBER;
2832: l_reval_rsv_acct NUMBER;

Line 2884: fa_category_books cb,

2880: fa_distribution_history dh,
2881: fa_deprn_Detail dd,
2882: gl_code_combinations cc,
2883: fa_categories cf,
2884: fa_category_books cb,
2885: fa_book_controls fb,
2886: fa_deprn_periods fdp,
2887: fa_asset_history ah
2888: WHERE ad.asset_id = bk.asset_id

Line 2981: fa_category_books cb,

2977: fa_deprn_Detail dd ,
2978: igi_iac_det_balances id ,
2979: gl_code_combinations cc,
2980: fa_categories cf,
2981: fa_category_books cb,
2982: fa_book_controls fb,
2983: fa_deprn_periods fdp,
2984: fa_asset_history ah
2985: WHERE ad.asset_id = dh.asset_id

Line 3328: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;

3324: l_asset_tag fa_additions.tag_number%TYPE;
3325: l_serial_number fa_additions.serial_number%TYPE;
3326: l_life_in_months fa_Books.life_in_months%TYPE;
3327: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
3328: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
3329: l_depreciation_method fa_Books.deprn_method_code%TYPE;
3330: l_location_id fa_distribution_history.location_id%TYPE;
3331: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
3332: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;

Line 3332: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;

3328: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
3329: l_depreciation_method fa_Books.deprn_method_code%TYPE;
3330: l_location_id fa_distribution_history.location_id%TYPE;
3331: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
3332: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
3333: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
3334: l_dep_backlog NUMBER;
3335: l_gen_fund_acct NUMBER;
3336: l_oper_exp_acct NUMBER;

Line 3333: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;

3329: l_depreciation_method fa_Books.deprn_method_code%TYPE;
3330: l_location_id fa_distribution_history.location_id%TYPE;
3331: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
3332: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
3333: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
3334: l_dep_backlog NUMBER;
3335: l_gen_fund_acct NUMBER;
3336: l_oper_exp_acct NUMBER;
3337: l_reval_rsv_acct NUMBER;

Line 3378: fa_category_books cb,

3374: fa_distribution_history dh,
3375: fa_deprn_Detail dd,
3376: gl_code_combinations cc,
3377: fa_categories cf,
3378: fa_category_books cb,
3379: fa_book_controls fb,
3380: fa_deprn_periods fdp,
3381: fa_asset_history ah
3382: WHERE ad.asset_id = bk.asset_id

Line 3458: fa_category_books cb,

3454: fa_deprn_Detail dd ,
3455: igi_iac_det_balances id ,
3456: gl_code_combinations cc,
3457: fa_categories cf,
3458: fa_category_books cb,
3459: fa_book_controls fb,
3460: fa_deprn_periods fdp,
3461: fa_asset_history ah
3462: WHERE ad.asset_id = dh.asset_id

Line 3718: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;

3714: l_parent_no VARCHAR2(15);
3715: l_serial_number fa_additions.serial_number%TYPE;
3716: l_life_in_months fa_Books.life_in_months%TYPE;
3717: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
3718: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
3719: l_depreciation_method fa_Books.deprn_method_code%TYPE;
3720: l_location_id fa_distribution_history.location_id%TYPE;
3721: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
3722: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;

Line 3722: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;

3718: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
3719: l_depreciation_method fa_Books.deprn_method_code%TYPE;
3720: l_location_id fa_distribution_history.location_id%TYPE;
3721: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
3722: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
3723: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
3724: l_dep_backlog NUMBER;
3725: l_gen_fund_acct NUMBER;
3726: l_oper_exp_acct NUMBER;

Line 3723: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;

3719: l_depreciation_method fa_Books.deprn_method_code%TYPE;
3720: l_location_id fa_distribution_history.location_id%TYPE;
3721: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
3722: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
3723: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
3724: l_dep_backlog NUMBER;
3725: l_gen_fund_acct NUMBER;
3726: l_oper_exp_acct NUMBER;
3727: l_reval_rsv_acct NUMBER;

Line 3780: fa_category_books cb,

3776: fa_distribution_history dh,
3777: fa_deprn_Detail dd,
3778: gl_code_combinations cc,
3779: fa_categories cf,
3780: fa_category_books cb,
3781: fa_book_controls fb,
3782: fa_deprn_periods fdp,
3783: fa_asset_history ah
3784: WHERE ad.asset_id = bk.asset_id

Line 3877: fa_category_books cb,

3873: fa_deprn_Detail dd ,
3874: igi_iac_det_balances id ,
3875: gl_code_combinations cc,
3876: fa_categories cf,
3877: fa_category_books cb,
3878: fa_book_controls fb,
3879: fa_deprn_periods fdp,
3880: fa_asset_history ah
3881: WHERE ad.asset_id = dh.asset_id

Line 4249: fa_category_books.deprn_reserve_acct%TYPE

4245:
4246: FUNCTION get_acct_seg_values ( p_bookType IN VARCHAR2
4247: ,p_categoryId IN NUMBER
4248: ,p_deprn_res_acct IN OUT NOCOPY
4249: fa_category_books.deprn_reserve_acct%TYPE
4250: ,p_deprn_exp_acct IN OUT NOCOPY
4251: fa_category_books.deprn_expense_acct%TYPE)
4252: RETURN BOOLEAN IS
4253:

Line 4251: fa_category_books.deprn_expense_acct%TYPE)

4247: ,p_categoryId IN NUMBER
4248: ,p_deprn_res_acct IN OUT NOCOPY
4249: fa_category_books.deprn_reserve_acct%TYPE
4250: ,p_deprn_exp_acct IN OUT NOCOPY
4251: fa_category_books.deprn_expense_acct%TYPE)
4252: RETURN BOOLEAN IS
4253:
4254: CURSOR c_acct(cp_bookType VARCHAR2, cp_categoryId NUMBER) IS
4255: SELECT fc.deprn_reserve_acct,

Line 4257: FROM fa_category_books fc

4253:
4254: CURSOR c_acct(cp_bookType VARCHAR2, cp_categoryId NUMBER) IS
4255: SELECT fc.deprn_reserve_acct,
4256: fc.deprn_expense_acct
4257: FROM fa_category_books fc
4258: WHERE fc.Book_Type_Code = cp_bookType
4259: AND fc.Category_id = cp_categoryId;
4260:
4261: l_retVal BOOLEAN;