91: decode(ftl.init_amount_cr,0, ftl.init_amount_dr,
92: NULL, ftl.init_amount_dr,
93: (ftl.init_amount_cr * (-1))),
94: ftl.line_id
95: FROM FUN_TRX_LINES ftl
96: WHERE p_trx_id = ftl.trx_id;
97:
98: -- cursor to retrieve the initiator and recipient party / LE ID
99:
153: fth.batch_id,
154: fth.trx_id,
155: ftl.line_id
156: FROM FUN_TRX_HEADERS fth,
157: FUN_TRX_LINES ftl,
158: FUN_DIST_LINES fdl
159: WHERE ftl.trx_id=fth.trx_id
160: AND fth.trx_id = p_trx_id
161: AND ftl.line_id=fdl.line_id