5: FUNCTION get_dealer_code RETURN xtr_dealer_codes.dealer_code%TYPE IS
6: CURSOR c_get_dealer_code IS
7: SELECT dealer_code
8: FROM xtr_dealer_codes 9: WHERE user_id = fnd_global.user_id; 10: BEGIN
11: if g_dealer_code is null then --4491268
12:
13: OPEN c_get_dealer_code;