[Home] [Help]
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
2332: AND source_id = s.source_id
2333: AND source_trx_id = s.source_trx_id);
2334:
2341: source_id,
2342: source_trx_id,
2343: destination_id,
2344: dest_trx_id
2345: FROM igi_dos_trx_dest
2346: WHERE trx_id = l_dossier_trx_id
2347: AND source_id = p_source_id
2348: AND source_trx_id = p_source_trx_id
2349: ORDER BY destination_id,