APPS.CSE_IPV_FA_PKG dependencies on FA_MASSADD_DISTRIBUTIONS

Line 262: fa_massadd_distributions fmd

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
266: AND fma.posting_status <> 'POSTED'

Line 364: FROM fa_massadd_distributions

360: WHERE mass_addition_id = asset_rec.fa_id;
361:
362: SELECT units
363: INTO l_units
364: FROM fa_massadd_distributions
365: WHERE mass_addition_id = asset_rec.fa_id;
366:
367: l_total_pending_units := l_total_pending_units + l_units;
368: