APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on HZ_RELATIONSHIP_TYPES

Line 1952: FROM hz_relationship_types

1948: _INFO'),1,10))),-99);
1949: */
1950: CURSOR c_get_relationship_type(p_relationship_code VARCHAR2) IS
1951: SELECT relationship_type, direction_code
1952: FROM hz_relationship_types
1953: WHERE (forward_rel_code = p_relationship_code
1954: OR backward_rel_code = p_relationship_code)
1955: AND subject_type = 'ORGANIZATION'
1956: AND object_type = 'ORGANIZATION'