APPS.FUN_RECIPIENT_WF dependencies on HZ_PARTIES

Line 225: FROM fun_trx_batches b, hz_parties h

221: 0, b.running_total_dr,
222: b.running_total_cr),'999999999.99'))||' '||b.currency_code,
223: h.party_name
224: INTO l_batch_num, l_trx_amt, l_initiator_name
225: FROM fun_trx_batches b, hz_parties h
226: WHERE batch_id = l_batch_id
227: AND b.initiator_id = h.party_id;
228: */
229: -- added to get transaction amount not batch amount

Line 244: hz_parties init

240:
241: SELECT init.party_name
242: INTO l_initiator_name
243: FROM fun_trx_headers,
244: hz_parties init
245: WHERE trx_id = l_trx_id
246: AND initiator_id = init.party_id;
247:
248:

Line 255: hz_parties rec

251: rec.party_name
252:
253: INTO l_trx_num, l_recipient_name
254: FROM fun_trx_headers,
255: hz_parties rec
256: WHERE trx_id = l_trx_id
257: AND recipient_id = rec.party_id;
258:
259: UPDATE fun_trx_headers

Line 1100: hz_parties init

1096:
1097: SELECT init.party_name
1098: INTO l_initiator_name
1099: FROM fun_trx_headers,
1100: hz_parties init
1101: WHERE trx_id = l_trx_id
1102: AND initiator_id = init.party_id;
1103:
1104: wf_engine.SetItemAttrText(itemtype => itemtype,