APPS.CSE_IPV_FA_PKG dependencies on FA_ASSET_INVOICES

Line 230: SELECT 1 FROM fa_asset_invoices fai

226: WHERE ciih.transaction_id = p_csi_txn_id
227: AND cia.instance_id = ciih.instance_id
228: AND cia.fa_asset_id is not null
229: AND EXISTS (
230: SELECT 1 FROM fa_asset_invoices fai
231: WHERE fai.asset_id = cia.fa_asset_id
232: AND fai.feeder_system_name = cse_asset_util_pkg.g_fa_feeder_name
233: AND fai.po_distribution_id = p_po_dist_id)
234: UNION