APPS.OKC_REP_QA_CHECK_PVT dependencies on HZ_RELATIONSHIPS

Line 593: hz_relationships hr,

589: AND pvc.vendor_contact_id=p_contact_id;
590:
591: CURSOR cur_cust_user(p_contact_id IN NUMBER,p_object_id IN number) IS
592: SELECT f.user_name ,( hz.person_first_name||' '||hz.person_last_name ) contact_name FROM
593: hz_relationships hr,
594: hz_parties hz,
595: FND_USER f
596: WHERE
597: hr.party_id = p_contact_id

Line 1241: hz_relationships hr

1237: hr.status relationship_status,
1238: hr.start_date start_date,
1239: hr.end_date end_date
1240: FROM hz_parties hz,
1241: hz_relationships hr
1242: WHERE hr.object_id = p_party_id -- The party being passsed
1243: AND hz.party_id = p_contact_id -- The contact id
1244: AND hr.object_type = 'ORGANIZATION'
1245: AND hr.object_table_name = 'HZ_PARTIES'