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.FA_RETIREMENT_PVT dependencies on FA_UTIL_PVT

Line 164: if not FA_UTIL_PVT.get_asset_desc_rec (

160: g_current_units := nvl(p_asset_desc_rec.current_units,0);
161:
162: -- Get asset description for member asset
163: -- p_asset_desc may be null
164: if not FA_UTIL_PVT.get_asset_desc_rec (
165: p_asset_hdr_rec => p_asset_hdr_rec,
166: px_asset_desc_rec => l_asset_desc_rec_m, p_log_level_rec => p_log_level_rec) then
167: raise ret_err;
168: end if;

Line 206: if not FA_UTIL_PVT.get_asset_type_rec (

202: l_asset_hdr_rec.book_type_code := p_asset_hdr_rec.book_type_code;
203: l_asset_hdr_rec.set_of_books_id := p_asset_hdr_rec.set_of_books_id;
204: --l_asset_hdr_rec.period_of_addition := 'N'; -- Guess not necessary
205:
206: if not FA_UTIL_PVT.get_asset_type_rec (
207: p_asset_hdr_rec => l_asset_hdr_rec,
208: px_asset_type_rec => l_asset_type_rec, p_log_level_rec => p_log_level_rec) then
209: raise ret_err;
210: end if;

Line 212: if not FA_UTIL_PVT.get_asset_desc_rec (

208: px_asset_type_rec => l_asset_type_rec, p_log_level_rec => p_log_level_rec) then
209: raise ret_err;
210: end if;
211:
212: if not FA_UTIL_PVT.get_asset_desc_rec (
213: p_asset_hdr_rec => l_asset_hdr_rec,
214: px_asset_desc_rec => l_asset_desc_rec, p_log_level_rec => p_log_level_rec) then
215: raise ret_err;
216: end if;

Line 218: if not FA_UTIL_PVT.get_asset_cat_rec (

214: px_asset_desc_rec => l_asset_desc_rec, p_log_level_rec => p_log_level_rec) then
215: raise ret_err;
216: end if;
217:
218: if not FA_UTIL_PVT.get_asset_cat_rec (
219: p_asset_hdr_rec => l_asset_hdr_rec,
220: px_asset_cat_rec => l_asset_cat_rec,
221: p_date_effective => null, p_log_level_rec => p_log_level_rec) then
222: raise ret_err;

Line 225: if not fa_util_pvt.get_asset_fin_rec (

221: p_date_effective => null, p_log_level_rec => p_log_level_rec) then
222: raise ret_err;
223: end if;
224:
225: if not fa_util_pvt.get_asset_fin_rec (
226: p_asset_hdr_rec => l_asset_hdr_rec,
227: px_asset_fin_rec => l_asset_fin_rec_old,
228: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
229: raise ret_err;

Line 242: if not fa_util_pvt.get_asset_deprn_rec (

238: /* End of bug 8535921 */
239:
240: --tk_util.DumpFinRec(l_asset_fin_rec_old, 'OLD');
241:
242: if not fa_util_pvt.get_asset_deprn_rec (
243: p_asset_hdr_rec => l_asset_hdr_rec,
244: px_asset_deprn_rec => l_asset_deprn_rec_old,
245: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
246: raise ret_err;

Line 263: if not fa_util_pvt.get_asset_fin_rec (

259:
260: l_asset_deprn_rec_adj.deprn_reserve := -1 * p_asset_retire_rec.reserve_retired;
261:
262: -- Get new member's fin_rec
263: if not fa_util_pvt.get_asset_fin_rec (
264: p_asset_hdr_rec => p_asset_hdr_rec,
265: px_asset_fin_rec => l_asset_fin_rec_new_m,
266: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
267: raise ret_err;

Line 288: if not fa_util_pvt.get_asset_deprn_rec (

284: -- into FA_ADJUSTMENTS.
285: --
286:
287: /* Added for bug 7537762 */
288: if not fa_util_pvt.get_asset_deprn_rec (
289: p_asset_hdr_rec => l_asset_hdr_rec,
290: px_asset_deprn_rec => l_asset_deprn_rec_old,
291: p_mrc_sob_type_code => p_mrc_sob_type_code,
292: p_log_level_rec => p_log_level_rec) then

Line 304: if not fa_util_pvt.get_asset_deprn_rec (

300: l_asset_fin_rec_old_g := l_asset_fin_rec_old;
301: l_asset_deprn_rec_old_g := l_asset_deprn_rec_old;
302: l_trans_rec_g := l_trans_rec;
303: l_asset_hdr_rec.asset_id := p_asset_hdr_rec.asset_id;
304: if not fa_util_pvt.get_asset_deprn_rec (
305: p_asset_hdr_rec => p_asset_hdr_rec,
306: px_asset_deprn_rec => l_asset_deprn_rec_old,
307: p_mrc_sob_type_code => p_mrc_sob_type_code,
308: p_log_level_rec => p_log_level_rec) then

Line 932: if not FA_UTIL_PVT.get_period_rec

928:
929: G_PART_RET_FLAG := FALSE;
930:
931: -- +++++ populate current period_rec info +++++
932: if not FA_UTIL_PVT.get_period_rec
933: (p_book => p_asset_hdr_rec.book_type_code,
934: x_period_rec => l_period_rec, p_log_level_rec => p_log_level_rec) then
935:
936: if (p_log_level_rec.statement_level) then

Line 937: fa_debug_pkg.add(l_calling_fn, 'Calling FA_UTIL_PVT.get_period_rec', 'Failed', p_log_level_rec => p_log_level_rec);

933: (p_book => p_asset_hdr_rec.book_type_code,
934: x_period_rec => l_period_rec, p_log_level_rec => p_log_level_rec) then
935:
936: if (p_log_level_rec.statement_level) then
937: fa_debug_pkg.add(l_calling_fn, 'Calling FA_UTIL_PVT.get_period_rec', 'Failed', p_log_level_rec => p_log_level_rec);
938: end if;
939:
940: raise rein_err;
941: end if;

Line 945: if not FA_UTIL_PVT.get_asset_desc_rec (

941: end if;
942:
943: -- Get asset description for member asset
944: -- p_asset_desc may be null
945: if not FA_UTIL_PVT.get_asset_desc_rec (
946: p_asset_hdr_rec => p_asset_hdr_rec,
947: px_asset_desc_rec => l_asset_desc_rec_m, p_log_level_rec => p_log_level_rec) then
948:
949: if (p_log_level_rec.statement_level) then

Line 950: fa_debug_pkg.add(l_calling_fn, 'Calling FA_UTIL_PVT.get_asset_desc_rec', 'Failed', p_log_level_rec => p_log_level_rec);

946: p_asset_hdr_rec => p_asset_hdr_rec,
947: px_asset_desc_rec => l_asset_desc_rec_m, p_log_level_rec => p_log_level_rec) then
948:
949: if (p_log_level_rec.statement_level) then
950: fa_debug_pkg.add(l_calling_fn, 'Calling FA_UTIL_PVT.get_asset_desc_rec', 'Failed', p_log_level_rec => p_log_level_rec);
951: end if;
952:
953: raise rein_err;
954: end if;

Line 1148: if not fa_util_pvt.get_asset_deprn_rec (

1144: p_log_level_rec => p_log_level_rec) then
1145: raise rein_err;
1146: end if;
1147:
1148: if not fa_util_pvt.get_asset_deprn_rec (
1149: p_asset_hdr_rec => l_asset_hdr_rec,
1150: px_asset_deprn_rec => l_asset_deprn_rec_old,
1151: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
1152: raise rein_err;

Line 1155: if not FA_UTIL_PVT.get_asset_type_rec

1151: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
1152: raise rein_err;
1153: end if;
1154:
1155: if not FA_UTIL_PVT.get_asset_type_rec
1156: (p_asset_hdr_rec => l_asset_hdr_rec,
1157: px_asset_type_rec => l_asset_type_rec, p_log_level_rec => p_log_level_rec) then
1158: raise rein_err;
1159: end if;

Line 1161: if not FA_UTIL_PVT.get_asset_desc_rec

1157: px_asset_type_rec => l_asset_type_rec, p_log_level_rec => p_log_level_rec) then
1158: raise rein_err;
1159: end if;
1160:
1161: if not FA_UTIL_PVT.get_asset_desc_rec
1162: (p_asset_hdr_rec => l_asset_hdr_rec,
1163: px_asset_desc_rec => l_asset_desc_rec, p_log_level_rec => p_log_level_rec) then
1164: raise rein_err;
1165: end if;

Line 1167: if not FA_UTIL_PVT.get_asset_cat_rec

1163: px_asset_desc_rec => l_asset_desc_rec, p_log_level_rec => p_log_level_rec) then
1164: raise rein_err;
1165: end if;
1166:
1167: if not FA_UTIL_PVT.get_asset_cat_rec
1168: (p_asset_hdr_rec => l_asset_hdr_rec,
1169: px_asset_cat_rec => l_asset_cat_rec,
1170: p_date_effective => null, p_log_level_rec => p_log_level_rec) then
1171: raise rein_err;

Line 1174: if not fa_util_pvt.get_asset_fin_rec (

1170: p_date_effective => null, p_log_level_rec => p_log_level_rec) then
1171: raise rein_err;
1172: end if;
1173:
1174: if not fa_util_pvt.get_asset_fin_rec (
1175: p_asset_hdr_rec => l_asset_hdr_rec,
1176: px_asset_fin_rec => l_asset_fin_rec_old,
1177: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
1178: raise rein_err;

Line 1193: if not fa_util_pvt.get_asset_deprn_rec (

1189: raise rein_err;
1190: end if; --End HH
1191:
1192: /*
1193: if not fa_util_pvt.get_asset_deprn_rec (
1194: p_asset_hdr_rec => l_asset_hdr_rec,
1195: px_asset_deprn_rec => l_asset_deprn_rec_old,
1196: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
1197: raise rein_err;

Line 1205: if not fa_util_pvt.get_asset_fin_rec (

1201: l_asset_fin_rec_adj.cost := p_asset_retire_rec.cost_retired;
1202: l_asset_fin_rec_adj.unrevalued_cost := p_asset_retire_rec.cost_retired;
1203:
1204: -- Get new member's fin_rec
1205: if not fa_util_pvt.get_asset_fin_rec (
1206: p_asset_hdr_rec => p_asset_hdr_rec,
1207: px_asset_fin_rec => l_asset_fin_rec_new_m,
1208: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
1209: raise rein_err;

Line 1748: if not fa_util_pvt.get_asset_deprn_rec ( -- ENERGY

1744: -- ENERGY
1745:
1746: if (nvl(p_asset_fin_rec.tracking_method, 'NON TRACK') = 'ALLOCATE') then
1747: -- ENERGY
1748: if not fa_util_pvt.get_asset_deprn_rec ( -- ENERGY
1749: p_asset_hdr_rec => p_asset_hdr_rec, -- ENERGY
1750: px_asset_deprn_rec => l_asset_deprn_rec, -- ENERGY
1751: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then -- ENERGY
1752: raise calc_err; -- ENERGY

Line 1900: if not FA_UTIL_PVT.get_asset_cat_rec (

1896: l_asset_hdr_rec.book_type_code := p_asset_hdr_rec.book_type_code;
1897: l_asset_hdr_rec.set_of_books_id := p_asset_hdr_rec.set_of_books_id;
1898: -- l_asset_hdr_rec.period_of_addition := 'N'; -- Set this if necessary
1899:
1900: if not FA_UTIL_PVT.get_asset_cat_rec (
1901: p_asset_hdr_rec => l_asset_hdr_rec,
1902: px_asset_cat_rec => l_asset_cat_rec,
1903: p_date_effective => NULL, p_log_level_rec => p_log_level_rec) then
1904: raise calc_err;

Line 2100: if not fa_util_pvt.get_asset_deprn_rec (

2096: p_trans_rec.transaction_date_entered) then
2097:
2098: l_trans_rec := p_trans_rec;
2099:
2100: if not fa_util_pvt.get_asset_deprn_rec (
2101: p_asset_hdr_rec => p_asset_hdr_rec,
2102: px_asset_deprn_rec => l_asset_deprn_rec,
2103: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
2104: raise calc_err;

Line 2642: if not FA_UTIL_PVT.get_asset_cat_rec (

2638: l_asset_hdr_rec.book_type_code := p_asset_hdr_rec.book_type_code;
2639: l_asset_hdr_rec.set_of_books_id := p_asset_hdr_rec.set_of_books_id;
2640: -- l_asset_hdr_rec.period_of_addition := 'N'; -- Set this if necessary
2641:
2642: if not FA_UTIL_PVT.get_asset_cat_rec (
2643: p_asset_hdr_rec => l_asset_hdr_rec,
2644: px_asset_cat_rec => l_asset_cat_rec,
2645: p_date_effective => NULL, p_log_level_rec => p_log_level_rec) then
2646: raise calc_err;

Line 2696: if not FA_UTIL_PVT.get_period_rec(

2692: OPEN c_get_group_thid;
2693: FETCH c_get_group_thid INTO l_group_thid, l_group_asset_id, l_date_effective;
2694: CLOSE c_get_group_thid;
2695:
2696: if not FA_UTIL_PVT.get_period_rec(
2697: p_book => l_asset_hdr_rec.book_type_code,
2698: p_effective_date => l_date_effective,
2699: x_period_rec => l_period_rec, p_log_level_rec => p_log_level_rec) then
2700: raise calc_err;

Line 2882: if not fa_util_pvt.get_asset_deprn_rec (

2878: end if;
2879:
2880: l_trans_rec := p_trans_rec;
2881:
2882: if not fa_util_pvt.get_asset_deprn_rec (
2883: p_asset_hdr_rec => p_asset_hdr_rec,
2884: px_asset_deprn_rec => l_asset_deprn_rec,
2885: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
2886: raise calc_err;

Line 3278: if not FA_UTIL_PVT.get_asset_type_rec (

3274:
3275: -- Bug 8674833 : Populate sob_id from p_ret populated in Do_Calc_GainLoss_Asset
3276: l_asset_hdr_rec.set_of_books_id := p_ret.set_of_books_id;
3277:
3278: if not FA_UTIL_PVT.get_asset_type_rec (
3279: p_asset_hdr_rec => l_asset_hdr_rec,
3280: px_asset_type_rec => l_asset_type_rec, p_log_level_rec => p_log_level_rec) then
3281: raise calc_err;
3282: end if;

Line 3284: if not FA_UTIL_PVT.get_asset_desc_rec (

3280: px_asset_type_rec => l_asset_type_rec, p_log_level_rec => p_log_level_rec) then
3281: raise calc_err;
3282: end if;
3283:
3284: if not FA_UTIL_PVT.get_asset_desc_rec (
3285: p_asset_hdr_rec => l_asset_hdr_rec,
3286: px_asset_desc_rec => l_asset_desc_rec, p_log_level_rec => p_log_level_rec) then
3287: raise calc_err;
3288: end if;

Line 3290: if not FA_UTIL_PVT.get_asset_cat_rec (

3286: px_asset_desc_rec => l_asset_desc_rec, p_log_level_rec => p_log_level_rec) then
3287: raise calc_err;
3288: end if;
3289:
3290: if not FA_UTIL_PVT.get_asset_cat_rec (
3291: p_asset_hdr_rec => l_asset_hdr_rec,
3292: px_asset_cat_rec => l_asset_cat_rec,
3293: p_date_effective => null, p_log_level_rec => p_log_level_rec) then
3294: raise calc_err;

Line 3297: if not fa_util_pvt.get_asset_fin_rec (

3293: p_date_effective => null, p_log_level_rec => p_log_level_rec) then
3294: raise calc_err;
3295: end if;
3296:
3297: if not fa_util_pvt.get_asset_fin_rec (
3298: p_asset_hdr_rec => l_asset_hdr_rec,
3299: px_asset_fin_rec => l_asset_fin_rec_old,
3300: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
3301: raise calc_err;

Line 3304: if not FA_UTIL_PVT.get_period_rec(

3300: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
3301: raise calc_err;
3302: end if;
3303:
3304: if not FA_UTIL_PVT.get_period_rec(
3305: p_book => l_asset_hdr_rec.book_type_code,
3306: x_period_rec => l_period_rec, p_log_level_rec => p_log_level_rec) then
3307: raise calc_err;
3308: end if;

Line 3355: if not fa_util_pvt.get_asset_fin_rec (

3351: -- Bug 8674833 : Populate sob_id from p_ret populated in Do_Calc_GainLoss_Asset
3352: l_asset_hdr_rec_m.set_of_books_id := p_ret.set_of_books_id;
3353:
3354: -- Get new member's fin_rec
3355: if not fa_util_pvt.get_asset_fin_rec (
3356: p_asset_hdr_rec => l_asset_hdr_rec_m,
3357: px_asset_fin_rec => l_asset_fin_rec_new_m,
3358: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
3359: raise calc_err;

Line 3766: if not FA_UTIL_PVT.get_asset_type_rec (

3762: l_asset_hdr_rec.asset_id := p_bk.group_asset_id;
3763: l_asset_hdr_rec.book_type_code := p_ret.book;
3764: l_asset_hdr_rec.set_of_books_id := p_ret.set_of_books_id;
3765:
3766: if not FA_UTIL_PVT.get_asset_type_rec (
3767: p_asset_hdr_rec => l_asset_hdr_rec,
3768: px_asset_type_rec => l_asset_type_rec, p_log_level_rec => p_log_level_rec) then
3769: raise calc_err;
3770: end if;

Line 3772: if not FA_UTIL_PVT.get_asset_desc_rec (

3768: px_asset_type_rec => l_asset_type_rec, p_log_level_rec => p_log_level_rec) then
3769: raise calc_err;
3770: end if;
3771:
3772: if not FA_UTIL_PVT.get_asset_desc_rec (
3773: p_asset_hdr_rec => l_asset_hdr_rec,
3774: px_asset_desc_rec => l_asset_desc_rec, p_log_level_rec => p_log_level_rec) then
3775: raise calc_err;
3776: end if;

Line 3778: if not FA_UTIL_PVT.get_asset_cat_rec (

3774: px_asset_desc_rec => l_asset_desc_rec, p_log_level_rec => p_log_level_rec) then
3775: raise calc_err;
3776: end if;
3777:
3778: if not FA_UTIL_PVT.get_asset_cat_rec (
3779: p_asset_hdr_rec => l_asset_hdr_rec,
3780: px_asset_cat_rec => l_asset_cat_rec,
3781: p_date_effective => null, p_log_level_rec => p_log_level_rec) then
3782: raise calc_err;

Line 3785: if not fa_util_pvt.get_asset_fin_rec (

3781: p_date_effective => null, p_log_level_rec => p_log_level_rec) then
3782: raise calc_err;
3783: end if;
3784:
3785: if not fa_util_pvt.get_asset_fin_rec (
3786: p_asset_hdr_rec => l_asset_hdr_rec,
3787: px_asset_fin_rec => l_asset_fin_rec_old,
3788: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
3789: raise calc_err;

Line 3792: if not FA_UTIL_PVT.get_period_rec(

3788: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
3789: raise calc_err;
3790: end if;
3791:
3792: if not FA_UTIL_PVT.get_period_rec(
3793: p_book => l_asset_hdr_rec.book_type_code,
3794: x_period_rec => l_period_rec, p_log_level_rec => p_log_level_rec) then
3795: raise calc_err;
3796: end if;

Line 3800: if not fa_util_pvt.get_asset_deprn_rec (

3796: end if;
3797:
3798: --tk_util.DumpFinRec(l_asset_fin_rec_old, 'OLD');
3799:
3800: if not fa_util_pvt.get_asset_deprn_rec (
3801: p_asset_hdr_rec => l_asset_hdr_rec,
3802: px_asset_deprn_rec => l_asset_deprn_rec_old,
3803: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
3804: raise calc_err;

Line 3896: if not fa_util_pvt.get_asset_fin_rec (

3892: l_asset_hdr_rec_m.book_type_code := p_ret.book;
3893: l_asset_hdr_rec_m.set_of_books_id := p_ret.set_of_books_id;
3894:
3895: -- Get new member's fin_rec
3896: if not fa_util_pvt.get_asset_fin_rec (
3897: p_asset_hdr_rec => l_asset_hdr_rec_m,
3898: px_asset_fin_rec => l_asset_fin_rec_new_m,
3899: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
3900: raise calc_err;

Line 4333: if not FA_UTIL_PVT.get_period_rec(

4329: fa_debug_pkg.add(l_calling_fn, 'Begin', p_book_type_code, p_log_level_rec => p_log_level_rec);
4330: end if;
4331:
4332: --+++++ Get Current Period Info +++++
4333: if not FA_UTIL_PVT.get_period_rec(
4334: p_book => p_book_type_code,
4335: x_period_rec => l_period_rec, p_log_level_rec => p_log_level_rec) then
4336: raise gl_err;
4337: end if;

Line 4914: (FA_UTIL_PVT.get_asset_deprn_resv(p_asset_hdr_rec.book_type_code,BK.ASSET_ID, p_asset_hdr_rec.set_of_books_id

4910: CURSOR C_DIST_EXCESS IS
4911: SELECT ASSET_ID
4912: , TRANSACTION_HEADER_ID_IN
4913: , BK.RECOVERABLE_COST -
4914: (FA_UTIL_PVT.get_asset_deprn_resv(p_asset_hdr_rec.book_type_code,BK.ASSET_ID, p_asset_hdr_rec.set_of_books_id
4915: , null, 'P' ) )
4916: ADJUSTED_COST
4917: FROM FA_BOOKS BK
4918: WHERE BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code

Line 4925: (FA_UTIL_PVT.get_asset_deprn_resv(p_asset_hdr_rec.book_type_code,BK.ASSET_ID, p_asset_hdr_rec.set_of_books_id

4921: AND PERIOD_COUNTER_FULLY_RESERVED is null
4922: AND PERIOD_COUNTER_FULLY_RETIRED is null
4923: AND nvl(CIP_COST, 0) = 0
4924: AND (BK.RECOVERABLE_COST -
4925: (FA_UTIL_PVT.get_asset_deprn_resv(p_asset_hdr_rec.book_type_code,BK.ASSET_ID, p_asset_hdr_rec.set_of_books_id
4926: , null, 'P' ) )
4927: ) <> 0;
4928:
4929: CURSOR C_MC_DIST_EXCESS IS

Line 4933: (FA_UTIL_PVT.get_asset_deprn_resv(p_asset_hdr_rec.book_type_code,BK.ASSET_ID, p_asset_hdr_rec.set_of_books_id

4929: CURSOR C_MC_DIST_EXCESS IS
4930: SELECT ASSET_ID
4931: , TRANSACTION_HEADER_ID_IN
4932: , BK.RECOVERABLE_COST -
4933: (FA_UTIL_PVT.get_asset_deprn_resv(p_asset_hdr_rec.book_type_code,BK.ASSET_ID, p_asset_hdr_rec.set_of_books_id
4934: , null, 'R' ) )
4935: ADJUSTED_COST
4936: FROM FA_MC_BOOKS BK
4937: WHERE BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code

Line 4944: (FA_UTIL_PVT.get_asset_deprn_resv(p_asset_hdr_rec.book_type_code,BK.ASSET_ID, p_asset_hdr_rec.set_of_books_id

4940: AND PERIOD_COUNTER_FULLY_RESERVED is null
4941: AND PERIOD_COUNTER_FULLY_RETIRED is null
4942: AND nvl(CIP_COST, 0) = 0
4943: AND (BK.RECOVERABLE_COST -
4944: (FA_UTIL_PVT.get_asset_deprn_resv(p_asset_hdr_rec.book_type_code,BK.ASSET_ID, p_asset_hdr_rec.set_of_books_id
4945: , null, 'R' ) )
4946: ) <> 0
4947: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id;
4948: