APPS.FA_UTIL_PVT dependencies on FA_ADDITIONS

Line 981: l_asset_category_id FA_ADDITIONS.asset_category_id%TYPE;

977: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
978: p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL,
979: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
980:
981: l_asset_category_id FA_ADDITIONS.asset_category_id%TYPE;
982:
983: BEGIN
984:
985: select ah.category_id,

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 1237: from fa_additions_vl

1233: px_asset_desc_rec.global_desc_flex.attribute20,
1234: px_asset_desc_rec.global_desc_flex.attribute_category_code,
1235: px_asset_desc_rec.commitment, -- Bug:5372429
1236: px_asset_desc_rec.investment_law -- Bug:5372429
1237: from fa_additions_vl
1238: where asset_id = p_asset_hdr_rec.asset_id;
1239:
1240: -- Get lease since its not in the view
1241: begin

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