DBA Data[Home] [Help]

APPS.AHL_UMP_SR_PVT dependencies on CSI_II_RELATIONSHIPS

Line 1088: from csi_ii_relationships

1084:
1085: --amsriniv. adding cursor to check if the instances on which the MRs are applicable are part of the SR Instance tree. ER 5883257
1086: CURSOR validate_sr_mr_intance_rel(c_mr_instance_id IN NUMBER,c_sr_instance_id IN NUMBER) IS
1087: select 'X'
1088: from csi_ii_relationships
1089: where subject_id = c_mr_instance_id
1090: start with object_id = c_sr_instance_id
1091: and RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
1092: and trunc(nvl(ACTIVE_START_DATE, sysdate)) <= trunc(sysdate)