APPS.ARH_DQM_TREE_HELPER dependencies on HZ_RELATIONSHIPS

Line 67: FROM hz_relationships

63: RETURN VARCHAR2
64: IS
65: CURSOR c1 IS
66: SELECT 'Y'
67: FROM hz_relationships
68: WHERE relationship_id = p_rel_id
69: AND object_table_name = 'HZ_PARTIES'
70: AND object_id = p_party_id
71: AND directional_flag = 'F';

Line 256: FROM hz_relationships

252: IS
253: CURSOR c_exist IS
254: SELECT relationship_id,
255: relationship_code
256: FROM hz_relationships
257: WHERE subject_type = 'PERSON'
258: AND subject_table_name= 'HZ_PARTIES'
259: AND subject_id = p_pers_id
260: AND object_type = 'ORGANIZATION'