DBA Data[Home] [Help]

APPS.AMS_REGISTRANTS_PUB dependencies on HZ_RELATIONSHIPS

Line 195: from hz_relationships

191: where party_id = p_party_id;
192:
193: CURSOR c_rel_det (p_party_id NUMBER) IS
194: select object_id
195: from hz_relationships
196: where party_id = p_party_id
197: and object_type = 'ORGANIZATION';
198:
199: l_party_type VARCHAR2(30);

Line 205: From hz_relationships

201:
202: -- soagrawa 09-jun-2003 added to fix bug# 2997411
203: CURSOR c_rel_validate (p_party_id NUMBER, p_org_id NUMBER) IS
204: SELECT 1
205: From hz_relationships
206: where party_id = p_party_id
207: and object_type = 'ORGANIZATION'
208: and object_id = p_org_id;
209: