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 244: SELECT 1 FROM fa_mass_additions fma

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

Line 257: fa_mass_additions fma,

253: fma.book_type_code,
254: fma.date_placed_in_service,
255: fmd.units
256: FROM csi_item_instances_h ciih,
257: fa_mass_additions fma,
258: fa_massadd_distributions fmd
259: WHERE ciih.transaction_id = p_csi_txn_id
260: AND fma.reviewer_comments = to_char(ciih.instance_id)
261: AND fma.feeder_system_name = cse_asset_util_pkg.g_fa_feeder_name

Line 355: FROM fa_mass_additions

351: INTO l_asset_description,
352: l_asset_category_id,
353: l_book_type_code,
354: l_date_placed_in_service
355: FROM fa_mass_additions
356: WHERE mass_addition_id = asset_rec.fa_id;
357:
358: SELECT units
359: INTO l_units