DBA Data[Home] [Help]

APPS.HZ_MERGE_PKG dependencies on HZ_RELATIONSHIP_TYPES

Line 5312: FROM HZ_RELATIONSHIP_TYPES

5308: AND directional_flag = 'F';
5309:
5310: SELECT allow_relate_to_self_flag
5311: INTO l_self_rel_flag
5312: FROM HZ_RELATIONSHIP_TYPES
5313: WHERE RELATIONSHIP_TYPE = l_rel_type
5314: AND FORWARD_REL_CODE = l_rel_code
5315: AND SUBJECT_TYPE = l_subject_type
5316: AND OBJECT_TYPE = l_object_type;

Line 5787: FROM HZ_RELATIONSHIP_TYPES

5783: END;
5784:
5785: SELECT allow_relate_to_self_flag
5786: INTO l_self_rel_flag
5787: FROM HZ_RELATIONSHIP_TYPES
5788: WHERE RELATIONSHIP_TYPE = l_rel_type
5789: AND FORWARD_REL_CODE = l_rel_code
5790: AND SUBJECT_TYPE = l_subject_type
5791: AND OBJECT_TYPE = l_object_type;

Line 7031: FROM HZ_RELATIONSHIP_TYPES

7027: )
7028: IS
7029: CURSOR c_hier_flag(cp_rel_type VARCHAR2) IS
7030: SELECT HIERARCHICAL_FLAG, MULTIPLE_PARENT_ALLOWED --5547536
7031: FROM HZ_RELATIONSHIP_TYPES
7032: WHERE RELATIONSHIP_TYPE = cp_rel_type
7033: AND ROWNUM = 1;
7034:
7035: CURSOR c_relship_det(cp_relship_id NUMBER) IS