APPS.HZ_MERGE_PKG dependencies on HZ_RELATIONSHIP_TYPES

Line 5222: FROM HZ_RELATIONSHIP_TYPES

5218: AND directional_flag = 'F';
5219:
5220: SELECT allow_relate_to_self_flag
5221: INTO l_self_rel_flag
5222: FROM HZ_RELATIONSHIP_TYPES
5223: WHERE RELATIONSHIP_TYPE = l_rel_type
5224: AND FORWARD_REL_CODE = l_rel_code
5225: AND SUBJECT_TYPE = l_subject_type
5226: AND OBJECT_TYPE = l_object_type;

Line 5314: FROM HZ_RELATIONSHIP_TYPES

5310: BEGIN
5311: --self relationship is not allowed then, Inactivate it
5312: SELECT allow_relate_to_self_flag
5313: INTO l_self_rel_flag
5314: FROM HZ_RELATIONSHIP_TYPES
5315: WHERE RELATIONSHIP_TYPE = l_rel_type
5316: AND FORWARD_REL_CODE = l_rel_code
5317: AND SUBJECT_TYPE = l_subject_type
5318: AND OBJECT_TYPE = l_object_type;

Line 5635: FROM HZ_RELATIONSHIP_TYPES

5631: END;
5632:
5633: SELECT allow_relate_to_self_flag
5634: INTO l_self_rel_flag
5635: FROM HZ_RELATIONSHIP_TYPES
5636: WHERE RELATIONSHIP_TYPE = l_rel_type
5637: AND FORWARD_REL_CODE = l_rel_code
5638: AND SUBJECT_TYPE = l_subject_type
5639: AND OBJECT_TYPE = l_object_type;

Line 5713: FROM HZ_RELATIONSHIP_TYPES

5709:
5710: --check self relationship flag
5711: SELECT allow_relate_to_self_flag
5712: INTO l_self_rel_flag
5713: FROM HZ_RELATIONSHIP_TYPES
5714: WHERE RELATIONSHIP_TYPE = l_rel_type
5715: AND FORWARD_REL_CODE = l_rel_code
5716: AND SUBJECT_TYPE = l_subject_type
5717: AND OBJECT_TYPE = l_object_type;

Line 6903: FROM HZ_RELATIONSHIP_TYPES

6899: )
6900: IS
6901: CURSOR c_hier_flag(cp_rel_type VARCHAR2) IS
6902: SELECT HIERARCHICAL_FLAG, MULTIPLE_PARENT_ALLOWED --5547536
6903: FROM HZ_RELATIONSHIP_TYPES
6904: WHERE RELATIONSHIP_TYPE = cp_rel_type
6905: AND ROWNUM = 1;
6906:
6907: CURSOR c_relship_det(cp_relship_id NUMBER) IS