DBA Data[Home] [Help]

APPS.FUN_INITIATOR_WF_PKG dependencies on HZ_PARTIES

Line 112: hz_parties hzp,

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
115: AND ftb.batch_id=fth.batch_id
116: AND fth.recipient_id=hzp.party_id

Line 113: hz_parties ini

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
115: AND ftb.batch_id=fth.batch_id
116: AND fth.recipient_id=hzp.party_id
117: AND fth.initiator_id=ini.party_id

Line 130: FROM hz_parties p,

126: -- Added by JMARY for bug 11880642
127: BEGIN
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