DBA Data[Home] [Help]

APPS.AHL_UMP_SR_PVT dependencies on CSI_II_RELATIONSHIPS

Line 1122: from csi_ii_relationships

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)