DBA Data[Home] [Help]

APPS.IGIDOSL dependencies on IGI_DOS_TRX_SOURCES

Line 224: FROM igi_dos_trx_sources s

220:
221: CURSOR c_source_total
222: IS
223: SELECT SUM(NVL(s.funds_available,0) - NVL(s.new_balance,0))
224: FROM igi_dos_trx_sources s
225: WHERE trx_id IN (
226: SELECT trx_id FROM igi_dos_trx_headers
227: WHERE trx_number = Dossier_num
228: AND dossier_id = Dossier_id);

Line 2327: FROM igi_dos_trx_sources s

2323: s.visible_segments,
2324: s.period_name,
2325: s.source_id,
2326: s.source_trx_id
2327: FROM igi_dos_trx_sources s
2328: WHERE trx_id = l_dossier_trx_id
2329: AND EXISTS (SELECT budget_name
2330: FROM igi_dos_trx_dest d
2331: WHERE d.trx_id = l_dossier_trx_id