APPS.AMS_PARTY_MKT_SEG_LOADER_PVT dependencies on HZ_RELATIONSHIP_TYPES

Line 3299: FROM hz_relationship_types

3295: NULL, SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99);
3296:
3297: CURSOR c_get_relationship_type(p_relationship_code VARCHAR2) IS
3298: SELECT relationship_type, direction_code
3299: FROM hz_relationship_types
3300: WHERE (forward_rel_code = p_relationship_code
3301: OR backward_rel_code = p_relationship_code)
3302: AND subject_type = 'ORGANIZATION'
3303: AND object_type = 'ORGANIZATION'