DBA Data[Home] [Help]

APPS.FUN_AR_BATCH_TRANSFER dependencies on FUN_TRX_LINES

Line 95: FROM FUN_TRX_LINES ftl

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:

Line 157: FUN_TRX_LINES ftl,

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