APPS.AMS_REGISTRANTS_PUB dependencies on HZ_PARTIES

Line 178: FROM hz_parties

174:
175: -- dbiswas added the following cursor for bug 2839226
176: Cursor c_contact_id_exists(p_reg_contact_id NUMBER ) IS
177: SELECT 1
178: FROM hz_parties
179: WHERE party_id = p_reg_contact_id;
180:
181: -- soagrawa added the following 24-apr-2003 cursor for bug 2863012
182: Cursor c_get_reg_status(p_reg_id NUMBER ) IS

Line 190: from hz_parties

186:
187: -- soagrawa 09-jun-2003 added to fix bug# 2997372
188: CURSOR c_party_Type (p_party_id NUMBER) IS
189: select party_type
190: from hz_parties
191: where party_id = p_party_id;
192:
193: CURSOR c_rel_det (p_party_id NUMBER) IS
194: select object_id