APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on CSI_II_RELATIONSHIPS

Line 572: FROM csi_ii_relationships

568: WHERE collection_id = c_collection_id;
569:
570: CURSOR get_csi_ii_details (c_instance_id NUMBER) IS
571: SELECT relationship_id,object_version_number
572: FROM csi_ii_relationships
573: WHERE subject_id = c_instance_id
574: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
575: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);--Modified by Sunil
576: