1118:
1119: --amsriniv. adding cursor to check if the instances on which the MRs are applicable are part of the SR Instance tree. ER 5883257
1120: CURSOR validate_sr_mr_intance_rel(c_mr_instance_id IN NUMBER,c_sr_instance_id IN NUMBER) IS
1121: select 'X'
1122: from csi_ii_relationships
1123: where subject_id = c_mr_instance_id
1124: start with object_id = c_sr_instance_id
1125: and RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
1126: and trunc(nvl(ACTIVE_START_DATE, sysdate)) <= trunc(sysdate)