APPS.FUN_IC_AME_WF_PKG dependencies on HZ_PARTIES

Line 35: FROM hz_parties hz,

31: IF p_attribute_name = 'BATCH_INITIATOR_NAME'
32: THEN
33: SELECT DISTINCT hz.party_name
34: INTO l_return_value
35: FROM hz_parties hz,
36: fun_trx_batches btch,
37: fun_trx_headers head
38: WHERE hz.party_id = btch.initiator_id
39: AND btch.batch_id = head.batch_id

Line 79: FROM hz_parties hz,

75: ELSIF p_attribute_name = 'HEADER_INITIATOR_NAME'
76: THEN
77: SELECT DISTINCT hz.party_name
78: INTO l_return_value
79: FROM hz_parties hz,
80: fun_trx_headers head
81: WHERE hz.party_id = head.initiator_id
82: AND head.trx_id = p_transaction_id;
83:

Line 88: FROM hz_parties hz,

84: ELSIF p_attribute_name = 'HEADER_RECIPIENT_NAME'
85: THEN
86: SELECT DISTINCT hz.party_name
87: INTO l_return_value
88: FROM hz_parties hz,
89: fun_trx_headers head
90: WHERE hz.party_id = head.recipient_id
91: AND head.trx_id = p_transaction_id;
92:

Line 115: FROM hz_parties hz,

111: ELSIF p_attribute_name = 'DIST_PARTY_NAME'
112: THEN
113: SELECT DISTINCT hz.party_name
114: INTO l_return_value
115: FROM hz_parties hz,
116: fun_dist_lines dist
117: WHERE hz.party_id = dist.party_id
118: AND dist.dist_id = p_dist_id;
119: