APPS.HZ_CUST_ACCT_CONTACT_BO_PUB dependencies on HZ_RELATIONSHIPS

Line 185: FROM HZ_RELATIONSHIPS r

181: AND rownum = 1;
182:
183: CURSOR get_contact_rel_noid(l_per_id NUMBER, l_obj_id NUMBER, l_rel_code VARCHAR2, l_rel_type VARCHAR2) IS
184: SELECT r.party_id
185: FROM HZ_RELATIONSHIPS r
186: WHERE r.subject_id = l_per_id
187: AND r.subject_type = 'PERSON'
188: AND r.object_id = l_obj_id
189: AND r.relationship_type = l_rel_type

Line 195: FROM HZ_RELATIONSHIPS r

191: AND sysdate between r.start_date and nvl(r.end_date, sysdate);
192:
193: CURSOR get_contact_rel(l_per_id NUMBER, l_obj_id NUMBER, l_rel_id NUMBER) IS
194: SELECT r.party_id
195: FROM HZ_RELATIONSHIPS r
196: WHERE r.relationship_id = l_rel_id
197: AND r.subject_id = l_per_id
198: AND r.subject_type = 'PERSON'
199: AND r.object_id = l_obj_id

Line 311: FND_MESSAGE.SET_TOKEN('TABLE','HZ_RELATIONSHIPS');

307: IF(l_rel_party_id IS NULL) THEN
308: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_FK');
309: FND_MESSAGE.SET_TOKEN('FK','RELATIONSHIP');
310: FND_MESSAGE.SET_TOKEN('COLUMN','RELATIONSHIIP_ID, RELATIONSHIP_CODE, RELATIONSHIP_TYPE');
311: FND_MESSAGE.SET_TOKEN('TABLE','HZ_RELATIONSHIPS');
312: FND_MSG_PUB.ADD();
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;
315: