APPS.JTF_IH_PARTY_MERGE_PKG dependencies on HZ_PARTIES

Line 95: select party_type into s_Party_Type from hz_parties where party_id = p_to_fk_id;

91: arp_message.set_token('TABLE_NAME', 'JTF_IH_INTERACTIONS', FALSE);
92:
93: open c1;
94: close c1;
95: select party_type into s_Party_Type from hz_parties where party_id = p_to_fk_id;
96: update jtf_ih_interactions
97: -- set party_id = decode(party_id, p_to_fk_id, p_to_fk_id, party_id),
98: set party_id = p_to_fk_id,
99: last_update_date = hz_utility_pub.last_update_date,

Line 148: where from_table = 'HZ_PARTIES'

144: where doc_id = p_from_fk_id
145: and doc_ref IN (
146: select object_code
147: from jtf_objects_b
148: where from_table = 'HZ_PARTIES'
149: );
150: end if;
151: END JTF_IH_MERGE_PARTY;
152: END JTF_IH_PARTY_MERGE_PKG;