APPS.OKC_REP_SIGN_WF_PVT dependencies on HZ_PARTIES

Line 358: hz_parties hz,

354:
355: CURSOR cur_cust_user(p_contact_id IN NUMBER,p_object_id IN number) IS
356: SELECT f.user_name ,( hz.person_first_name||' '||hz.person_last_name ) contact_name FROM
357: hz_relationships hr,
358: hz_parties hz,
359: FND_USER f
360: WHERE
361: hr.party_id = p_contact_id
362: AND hr.subject_id = hz.party_id

Line 365: AND hr.object_table_name = 'HZ_PARTIES'

361: hr.party_id = p_contact_id
362: AND hr.subject_id = hz.party_id
363: AND hr.object_id = p_object_id
364: AND hr.object_type = 'ORGANIZATION'
365: AND hr.object_table_name = 'HZ_PARTIES'
366: AND hr.subject_type = 'PERSON'
367: AND hz.party_id = hr.subject_id
368: AND hr.relationship_code = 'CONTACT_OF'
369: AND hr.status = 'A'