APPS.AHL_UTIL_UC_PKG dependencies on CSI_IEA_VALUES

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))

Line 475: l_attribute_value csi_iea_values.attribute_value%TYPE;

471: AND trunc(sysdate) >= trunc(nvl(iea.active_start_date, sysdate))
472: AND trunc(sysdate) < trunc(nvl(iea.active_end_date, sysdate+1));
473:
474: l_return_val BOOLEAN DEFAULT TRUE;
475: l_attribute_value csi_iea_values.attribute_value%TYPE;
476: l_attribute_value_id NUMBER;
477: l_object_version_number NUMBER;
478:
479: BEGIN