771: fnd_user NUMBER;
772: --
773: cursor USER (fnd_user in number) is
774: select dealer_code 775: from xtr_dealer_codes_v 776: where user_id = fnd_user;
777:
778: cursor COMP_NAME(l_user VARCHAR2) is
779: select p.SHORT_NAME
Line 914: from XTR_DEALER_CODES
910: l_level OUT NOCOPY VARCHAR2) is
911: --
912: cursor CHK_CODE is
913: select 1 914: from XTR_DEALER_CODES 915: where DEALER_CODE = l_dealer_code;
916: --
917: v_dummy number(1);
918: begin