DBA Data[Home] [Help]

APPS.CSE_IPV_FA_PKG dependencies on FA_MASSADD_DISTRIBUTIONS

Line 258: fa_massadd_distributions fmd

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

Line 360: FROM fa_massadd_distributions

356: WHERE mass_addition_id = asset_rec.fa_id;
357:
358: SELECT units
359: INTO l_units
360: FROM fa_massadd_distributions
361: WHERE mass_addition_id = asset_rec.fa_id;
362:
363: l_total_pending_units := l_total_pending_units + l_units;
364: