[Home] [Help]
106: l_currency,
107: l_recipient_name,
108: l_trx_number,
109: l_initiator_name
110: FROM fun_trx_batches ftb,
111: fun_trx_headers fth,
112: hz_parties hzp,
113: hz_parties ini
114: WHERE ftb.batch_id = l_batch_id
128: SELECT p.PARTY_NAME PERSON_NAME
129: INTO l_initiator_person
130: FROM hz_parties p,
131: fnd_user fu,
132: fun_trx_batches b
133: WHERE fu.person_party_id = p.party_id
134: AND fu.user_id = b.created_by
135: AND b.batch_id = l_batch_id;
136: EXCEPTION
513: ftb.batch_id,
514: fth.trx_id,
515: ftb.from_ledger_id,
516: ftb.batch_date
517: FROM FUN_TRX_BATCHES ftb,
518: FUN_TRX_HEADERS fth
519: WHERE fth.trx_id=p_trx_id
520: AND fth.batch_id=ftb.batch_id
521: AND fth.status='APPROVED';
1065: p_batch_id => l_batch_id,
1066: p_trx_id => l_trx_id);
1067:
1068: -- Bug: 7319371 Changing the query to make the l_trx_amt number reginal independent
1069: -- Also since the fun_trx_batches table is not used in the query removing a reference to the same
1070:
1071: --select ltrim(to_char(decode(nvl(h.reci_amount_cr,0),0,h.reci_amount_dr,h.reci_amount_cr),'999999999.99'))
1072: --into l_trx_amt
1073: --from fun_trx_headers h, fun_trx_batches b
1069: -- Also since the fun_trx_batches table is not used in the query removing a reference to the same
1070:
1071: --select ltrim(to_char(decode(nvl(h.reci_amount_cr,0),0,h.reci_amount_dr,h.reci_amount_cr),'999999999.99'))
1072: --into l_trx_amt
1073: --from fun_trx_headers h, fun_trx_batches b
1074: --where h.trx_id = l_trx_id
1075: --and b.batch_id = l_batch_id;
1076:
1077: SELECT LTRIM(TO_CHAR(DECODE(NVL(H.RECI_AMOUNT_CR,0),0,H.RECI_AMOUNT_DR,