inconsistent result after upgrade to 11g
Database was upgraded from 10.2.0.4 t0 11.2.0.4
The below function returns opposite results in 10g (N - No currency indicator) and 11g (Y = no currency indicator).
DECLARE
L_brand division.division%TYPE;
L_po_type_string csi_uda_ff.uda_txt_des%TYPE;
L_ord_type_des ord_ext.ord_type_des%TYPE;
L_no_currency_ind csi_uda_val.uda_val_des%TYPE;
CURSOR c_get_no_currency_ind(P_brand division.division%TYPE,
P_po_type csi_uda_ff.uda_txt_des%TYPE,
P_ord_type_des ord_ext.ord_type_des%TYPE --<ANF 4.04>
)
IS
select distinct csi_uda_val