APPS.FA_UTIL_PVT dependencies on FA_ADDITIONS

Line 1036: l_asset_category_id FA_ADDITIONS.asset_category_id%TYPE;

1032: p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL
1033: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type
1034: ) RETURN BOOLEAN IS
1035:
1036: l_asset_category_id FA_ADDITIONS.asset_category_id%TYPE;
1037:
1038: BEGIN
1039:
1040: select ah.category_id,

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

1287: px_asset_desc_rec.global_desc_flex.attribute20,
1288: px_asset_desc_rec.global_desc_flex.attribute_category_code,
1289: px_asset_desc_rec.commitment, -- Bug:14770709
1290: px_asset_desc_rec.investment_law -- Bug:14770709
1291: from fa_additions_vl
1292: where asset_id = p_asset_hdr_rec.asset_id;
1293:
1294: -- Get lease since its not in the view
1295: begin

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