APPS.AHL_UTIL_UC_PKG dependencies on CSI_I_EXTENDED_ATTRIBS

Line 426: FROM csi_i_extended_attribs

422:
423:
424: CURSOR csi_i_ext_attrib_csr(p_attribute_code IN VARCHAR2) IS
425: SELECT attribute_id
426: FROM csi_i_extended_attribs
427: WHERE attribute_level = 'GLOBAL'
428: AND attribute_code = p_attribute_code;
429:
430: l_return_val BOOLEAN DEFAULT TRUE;

Line 462: FROM csi_i_extended_attribs attb, csi_iea_values iea

458: CURSOR csi_i_iea_csr(p_attribute_code IN VARCHAR2,
459: p_csi_instance_id IN NUMBER) IS
460:
461: SELECT iea.attribute_value, iea.attribute_value_id, iea.object_version_number
462: FROM csi_i_extended_attribs attb, csi_iea_values iea
463: WHERE attb.attribute_id = iea.attribute_id
464: AND attb.attribute_code = p_attribute_code
465: AND iea.instance_id = p_csi_instance_id
466: AND trunc(sysdate) >= trunc(nvl(iea.active_start_date, sysdate))