APPS.AHL_UMP_SMRINSTANCE_PVT dependencies on CSI_II_RELATIONSHIPS

Line 1333: SELECT subject_id from csi_ii_relationships csii WHERE

1329: p_module_type IN VARCHAR2,
1330: p_search_mr_instance_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_MRInstance_Rec_Type)IS
1331:
1332: CURSOR dependent_components_csr IS
1333: SELECT subject_id from csi_ii_relationships csii WHERE
1334: EXISTS (select 'x' from ahl_unit_effectivities_b UE where UE.csi_item_instance_id = csii.subject_id)
1335: AND NOT EXISTS (select 'x' from AHL_APPLICABLE_INSTANCES where csi_item_instance_id = csii.subject_id)
1336: START WITH object_id IN (SELECT csi_item_instance_id FROM AHL_APPLICABLE_INSTANCES WHERE POSITION_ID = 0)
1337: AND trunc(nvl(csii.active_start_date, sysdate)) <= Trunc(sysdate)