APPS.HZ_GEO_STRUCTURE_VALIDATE_PVT dependencies on HZ_RELATIONSHIP_TYPES

Line 500: FROM hz_relationship_types

496: l_count NUMBER;
497:
498: BEGIN
499: SELECT count(*) INTO l_count
500: FROM hz_relationship_types
501: WHERE SUBJECT_TYPE = p_parent_geography_type
502: AND OBJECT_TYPE = p_geography_type
503: AND FORWARD_REL_CODE = 'PARENT_OF'
504: AND BACKWARD_REL_CODE = 'CHILD_OF';

Line 533: FROM HZ_RELATIONSHIP_TYPES

529:
530: BEGIN
531: SELECT 1
532: INTO l_count
533: FROM HZ_RELATIONSHIP_TYPES
534: WHERE RELATIONSHIP_TYPE_ID = p_relationship_type_id;
535:
536: EXCEPTION
537: WHEN NO_DATA_FOUND THEN