APPS.CSE_IPV_FA_PKG dependencies on FA_MASS_ADDITIONS

Line 196: l_mass_add_rec fa_mass_additions%rowtype;

192: l_link_found boolean := FALSE;
193:
194: l_ind binary_integer := 0;
195: l_ma_proc_tbl ma_process_tbl;
196: l_mass_add_rec fa_mass_additions%rowtype;
197: l_asset_attrib_rec cse_datastructures_pub.asset_attrib_rec;
198: l_dflt_book_type_code varchar2(30);
199:
200: l_error_message varchar2(2000);

Line 248: SELECT 1 FROM fa_mass_additions fma

244: WHERE ciih.transaction_id = p_csi_txn_id
245: AND cia.instance_id = ciih.instance_id
246: AND cia.fa_asset_id is null
247: AND EXISTS (
248: SELECT 1 FROM fa_mass_additions fma
249: WHERE fma.mass_addition_id = cia.fa_mass_addition_id
250: AND fma.feeder_system_name = cse_asset_util_pkg.g_fa_feeder_name
251: AND fma.po_distribution_id = p_po_dist_id);
252:

Line 261: fa_mass_additions fma,

257: fma.book_type_code,
258: fma.date_placed_in_service,
259: fmd.units
260: FROM csi_item_instances_h ciih,
261: fa_mass_additions fma,
262: fa_massadd_distributions fmd
263: WHERE ciih.transaction_id = p_csi_txn_id
264: AND fma.reviewer_comments = to_char(ciih.instance_id)
265: AND fma.feeder_system_name = cse_asset_util_pkg.g_fa_feeder_name

Line 359: FROM fa_mass_additions

355: INTO l_asset_description,
356: l_asset_category_id,
357: l_book_type_code,
358: l_date_placed_in_service
359: FROM fa_mass_additions
360: WHERE mass_addition_id = asset_rec.fa_id;
361:
362: SELECT units
363: INTO l_units