APPS.AHL_PRD_SERN_CHANGE_PVT dependencies on CSI_I_EXTENDED_ATTRIBS

Line 57: FROM csi_i_extended_attribs

53:
54:
55: CURSOR csi_i_ext_attrib_csr(p_attribute_code IN VARCHAR2) IS
56: SELECT attribute_id
57: FROM csi_i_extended_attribs
58: WHERE attribute_level = 'GLOBAL'
59: AND attribute_code = p_attribute_code;
60:
61: l_return_val BOOLEAN DEFAULT TRUE;

Line 93: FROM csi_i_extended_attribs attb, csi_iea_values iea

89: CURSOR csi_i_iea_csr(p_attribute_code IN VARCHAR2,
90: p_csi_instance_id IN NUMBER) IS
91:
92: SELECT iea.attribute_value, iea.attribute_value_id, iea.object_version_number
93: FROM csi_i_extended_attribs attb, csi_iea_values iea
94: WHERE attb.attribute_id = iea.attribute_id
95: AND attb.attribute_code = p_attribute_code
96: AND iea.instance_id = p_csi_instance_id
97: AND trunc(sysdate) >= trunc(nvl(iea.active_start_date, sysdate))