APPS.AHL_PRD_DISP_UTIL_PVT dependencies on CSI_II_RELATIONSHIPS
Line 798: FROM csi_item_instances csi, csi_ii_relationships rel
794: --Check if position is empty or filled
795: CURSOR check_installed_csr (p_parent_id IN NUMBER,
796: p_relationship_id IN NUMBER) IS
797: SELECT csi.instance_id 798: FROM csi_item_instances csi, csi_ii_relationships rel 799: WHERE csi.instance_id = rel.subject_id
800: AND REL.object_id = p_parent_id
801: AND REL.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
802: AND TRUNC(nvl(REL.ACTIVE_START_DATE, sysdate-1)) <= TRUNC(sysdate)