DBA Data[Home] [Help]

APPS.IGIDOSL dependencies on IGI_DOS_TRX_SOURCES

Line 240: FROM igi_dos_trx_sources s

236:
237: CURSOR c_source_total
238: IS
239: SELECT SUM(NVL(s.funds_available,0) - NVL(s.new_balance,0))
240: FROM igi_dos_trx_sources s
241: WHERE trx_id IN (
242: SELECT trx_id FROM igi_dos_trx_headers
243: WHERE trx_number = Dossier_num
244: AND dossier_id = Dossier_id);

Line 2452: FROM igi_dos_trx_sources s

2448: s.visible_segments,
2449: s.period_name,
2450: s.source_id,
2451: s.source_trx_id
2452: FROM igi_dos_trx_sources s
2453: WHERE trx_id = l_dossier_trx_id
2454: AND EXISTS (SELECT budget_name
2455: FROM igi_dos_trx_dest d
2456: WHERE d.trx_id = l_dossier_trx_id