APPS.FUN_GLINT_WF dependencies on FUN_TRX_BATCHES

Line 92: -- from fun_trx_headers h, fun_trx_batches b

88: --select ltrim(to_char(decode(nvl(h.reci_amount_cr,0),
89: -- 0,h.reci_amount_dr,
90: -- h.reci_amount_cr),'999999999.99'))||' '||b.currency_code
91: -- into l_trx_amount
92: -- from fun_trx_headers h, fun_trx_batches b
93: -- where b.batch_id = l_batch_id
94: -- and h.trx_id = l_trx_id;
95:
96: select ltrim(to_char(decode(nvl(h.reci_amount_cr,0),

Line 100: from fun_trx_headers h, fun_trx_batches b

96: select ltrim(to_char(decode(nvl(h.reci_amount_cr,0),
97: 0,h.reci_amount_dr,
98: h.reci_amount_cr),'999999999D99'))||' '||b.currency_code
99: into l_trx_amount
100: from fun_trx_headers h, fun_trx_batches b
101: where b.batch_id = l_batch_id
102: and h.trx_id = l_trx_id;
103:
104: -- Bug: 7139371 END

Line 115: FROM fun_trx_batches

111: -- added by rani shergill for notifications - end
112:
113:
114: SELECT initiator_id INTO l_init_id
115: FROM fun_trx_batches
116: WHERE batch_id = l_batch_id;
117:
118: IF (l_init_id = l_party_id) THEN
119: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 201: FROM fun_trx_batches

197: SELECT currency_code, from_ledger_id, gl_date, batch_date,
198: exchange_rate_type
199: INTO l_trx_currency, l_ledger_id, l_gl_date, l_conv_date,
200: l_conv_type
201: FROM fun_trx_batches
202: WHERE batch_id = l_batch_id;
203:
204: IF (l_party_type = 'R') THEN
205: l_trx_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 308: FROM fun_trx_batches b

304: SELECT b.from_ledger_id, b.gl_date, b.currency_code,
305: b.exchange_rate_type, b.batch_date, b.description
306: INTO l_ledger_id, l_gl_date, l_trx_currency,
307: l_conv_type, l_conv_date, l_desc
308: FROM fun_trx_batches b
309: WHERE b.batch_id = l_batch_id;
310:
311: IF (l_party_type = 'R') THEN
312: SELECT to_ledger_id, description INTO l_ledger_id, l_desc