APPS.AHL_UTIL_UC_PKG dependencies on CSI_I_EXTENDED_ATTRIBS

Line 431: FROM csi_i_extended_attribs

427:
428:
429: CURSOR csi_i_ext_attrib_csr(p_attribute_code IN VARCHAR2) IS
430: SELECT attribute_id
431: FROM csi_i_extended_attribs
432: WHERE attribute_level = 'GLOBAL'
433: AND attribute_code = p_attribute_code;
434:
435: l_return_val BOOLEAN DEFAULT TRUE;

Line 467: FROM csi_i_extended_attribs attb, csi_iea_values iea

463: CURSOR csi_i_iea_csr(p_attribute_code IN VARCHAR2,
464: p_csi_instance_id IN NUMBER) IS
465:
466: SELECT iea.attribute_value, iea.attribute_value_id, iea.object_version_number
467: FROM csi_i_extended_attribs attb, csi_iea_values iea
468: WHERE attb.attribute_id = iea.attribute_id
469: AND attb.attribute_code = p_attribute_code
470: AND iea.instance_id = p_csi_instance_id
471: AND trunc(sysdate) >= trunc(nvl(iea.active_start_date, sysdate))