DBA Data[Home] [Help]

APPS.FA_UTIL_PVT dependencies on FA_ADDITIONS_B

Line 1053: from fa_additions_b ad,

1049: px_asset_cat_rec.desc_flex.attribute29,
1050: px_asset_cat_rec.desc_flex.attribute30,
1051: px_asset_cat_rec.desc_flex.attribute_category_code,
1052: px_asset_cat_rec.desc_flex.context
1053: from fa_additions_b ad,
1054: fa_asset_history ah
1055: where ad.asset_id = p_asset_hdr_rec.asset_id
1056: and ad.asset_id = ah.asset_id
1057: and ((p_date_effective is null and

Line 1093: from fa_additions_b ad,

1089: BEGIN
1090:
1091: select ah.asset_type
1092: into px_asset_type_rec.asset_type
1093: from fa_additions_b ad,
1094: fa_asset_history ah
1095: where ad.asset_id = p_asset_hdr_rec.asset_id
1096: and ad.asset_id = ah.asset_id
1097: and (ah.date_effective = nvl(p_date_effective, to_date('01/01/0001', 'DD/MM/YYYY')) or

Line 2362: fa_additions_b ad

2358: into l_deprn_amt
2359: FROM fa_deprn_summary ds,
2360: fa_book_controls bc,
2361: fa_books bks,
2362: fa_additions_b ad
2363: WHERE bc.book_type_code = X_Book
2364: AND ds.book_type_code = bc.book_type_code
2365: AND ds.period_counter = bc.last_period_counter + 1
2366: AND ds.asset_id = bks.asset_id