APPS.FUN_RECIPIENT_WF dependencies on HZ_PARTIES

Line 252: FROM fun_trx_batches b, hz_parties h

248: 0, b.running_total_dr,
249: b.running_total_cr),'99999999999999999999999999999999999999999999999.99'))||' '||b.currency_code,
250: h.party_name
251: INTO l_batch_num, l_trx_amt, l_initiator_name
252: FROM fun_trx_batches b, hz_parties h
253: WHERE batch_id = l_batch_id
254: AND b.initiator_id = h.party_id;
255: */
256: -- added to get transaction amount not batch amount

Line 271: hz_parties init

267:
268: SELECT init.party_name
269: INTO l_initiator_name
270: FROM fun_trx_headers,
271: hz_parties init
272: WHERE trx_id = l_trx_id
273: AND initiator_id = init.party_id;
274:
275: -- to get initiator person name

Line 279: FROM hz_parties p,

275: -- to get initiator person name
276: -- Bug: 14622502 - Removed created_by, added last_updated_by
277: SELECT p.PARTY_NAME PERSON_NAME
278: INTO l_initiator_person
279: FROM hz_parties p,
280: fnd_user fu,
281: fun_trx_batches b
282: WHERE fu.person_party_id = p.party_id
283: AND fu.user_id = b.last_updated_by

Line 292: hz_parties rec

288: rec.party_name
289:
290: INTO l_trx_num, l_recipient_name
291: FROM fun_trx_headers,
292: hz_parties rec
293: WHERE trx_id = l_trx_id
294: AND recipient_id = rec.party_id;
295:
296: UPDATE fun_trx_headers

Line 1190: hz_parties init

1186:
1187: SELECT init.party_name
1188: INTO l_initiator_name
1189: FROM fun_trx_headers,
1190: hz_parties init
1191: WHERE trx_id = l_trx_id
1192: AND initiator_id = init.party_id;
1193:
1194: wf_engine.SetItemAttrText(itemtype => itemtype,