DBA Data[Home] [Help]

APPS.FA_UTIL_PVT dependencies on FA_ADDITIONS_B

Line 1108: from fa_additions_b ad,

1104: px_asset_cat_rec.desc_flex.attribute29,
1105: px_asset_cat_rec.desc_flex.attribute30,
1106: px_asset_cat_rec.desc_flex.attribute_category_code,
1107: px_asset_cat_rec.desc_flex.context
1108: from fa_additions_b ad,
1109: fa_asset_history ah
1110: where ad.asset_id = p_asset_hdr_rec.asset_id
1111: and ad.asset_id = ah.asset_id
1112: and ((p_date_effective is null and

Line 1148: from fa_additions_b ad,

1144: BEGIN
1145:
1146: select ah.asset_type
1147: into px_asset_type_rec.asset_type
1148: from fa_additions_b ad,
1149: fa_asset_history ah
1150: where ad.asset_id = p_asset_hdr_rec.asset_id
1151: and ad.asset_id = ah.asset_id
1152: and (ah.date_effective = nvl(p_date_effective, to_date('01/01/0001', 'DD/MM/YYYY')) or

Line 2412: fa_additions_b ad

2408: into l_deprn_amt
2409: FROM fa_deprn_summary ds,
2410: fa_book_controls bc,
2411: fa_books bks,
2412: fa_additions_b ad
2413: WHERE bc.book_type_code = X_Book
2414: AND ds.book_type_code = bc.book_type_code
2415: AND ds.period_counter = bc.last_period_counter + 1
2416: AND ds.asset_id = bks.asset_id