DBA Data[Home] [Help]

APPS.FUN_INITIATOR_WF_PKG dependencies on FUN_TRX_LINES

Line 494: FROM FUN_TRX_LINES ftl

490: 0, ftl.init_amount_dr,
491: NULL, ftl.init_amount_dr,
492: ftl.init_amount_cr * (-1)),
493: ftl.line_id
494: FROM FUN_TRX_LINES ftl
495: WHERE p_trx_id = ftl.trx_id;
496:
497: -- cursor to retrieve the initiator and recipient party / LE ID
498: -- Bug 7271703. also fetching batch number in cursor c_info

Line 545: FUN_TRX_LINES ftl,

541: fth.batch_id,
542: fth.trx_id,
543: ftl.line_id
544: FROM FUN_TRX_HEADERS fth,
545: FUN_TRX_LINES ftl,
546: FUN_DIST_LINES fdl
547: WHERE fth.trx_id=p_trx_id
548: AND ftl.trx_id=fth.trx_id
549: AND ftl.line_id=fdl.line_id