APPS.AHL_UTIL_UC_PKG dependencies on CSI_IEA_VALUES

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

Line 470: l_attribute_value csi_iea_values.attribute_value%TYPE;

466: AND trunc(sysdate) >= trunc(nvl(iea.active_start_date, sysdate))
467: AND trunc(sysdate) < trunc(nvl(iea.active_end_date, sysdate+1));
468:
469: l_return_val BOOLEAN DEFAULT TRUE;
470: l_attribute_value csi_iea_values.attribute_value%TYPE;
471: l_attribute_value_id NUMBER;
472: l_object_version_number NUMBER;
473:
474: BEGIN