DBA Data[Home] [Help]

APPS.FUN_INITIATOR_WF_PKG dependencies on FUN_TRX_LINES

Line 460: FROM FUN_TRX_LINES ftl

456: 0, ftl.init_amount_dr,
457: NULL, ftl.init_amount_dr,
458: ftl.init_amount_cr * (-1)),
459: ftl.line_id
460: FROM FUN_TRX_LINES ftl
461: WHERE p_trx_id = ftl.trx_id;
462:
463: -- cursor to retrieve the initiator and recipient party / LE ID
464: -- Bug 7271703. also fetching batch number in cursor c_info

Line 511: FUN_TRX_LINES ftl,

507: fth.batch_id,
508: fth.trx_id,
509: ftl.line_id
510: FROM FUN_TRX_HEADERS fth,
511: FUN_TRX_LINES ftl,
512: FUN_DIST_LINES fdl
513: WHERE fth.trx_id=p_trx_id
514: AND ftl.trx_id=fth.trx_id
515: AND ftl.line_id=fdl.line_id