680: BEGIN
681: BEGIN
682: select 'Y'
683: into l_temp
684: from xtr_dealer_codes_v
685: where dealer_code = p_dealer_code
686: and rownum = 1;
687: EXCEPTION
688: WHEN NO_DATA_FOUND THEN
2766: duplicate_error BOOLEAN := FALSE;
2767:
2768: cursor FIND_USER (p_fnd_user in number) is
2769: select dealer_code
2770: from xtr_dealer_codes_v
2771: where user_id = p_fnd_user;
2772:
2773: --*****************************************************************************************************************
2774: -- 3800146 ******************************************************************************************************