APPS.XTR_FX_TRANSFERS_PKG dependencies on XTR_DEALER_CODES

Line 873: from xtr_dealer_codes_v

869: BEGIN
870: BEGIN
871: select 'Y'
872: into l_temp
873: from xtr_dealer_codes_v
874: where dealer_code = p_dealer_code
875: and rownum = 1;
876: EXCEPTION
877: WHEN NO_DATA_FOUND THEN

Line 1667: from xtr_dealer_codes_v

1663: /*------------------------------------------------------------*/
1664:
1665: cursor FIND_USER (p_fnd_user in number) is
1666: select dealer_code
1667: from xtr_dealer_codes_v
1668: where user_id = p_fnd_user;
1669:
1670: l_user xtr_dealer_codes.dealer_code%TYPE;
1671: l_dual_user xtr_dealer_codes.dealer_code%TYPE;

Line 1670: l_user xtr_dealer_codes.dealer_code%TYPE;

1666: select dealer_code
1667: from xtr_dealer_codes_v
1668: where user_id = p_fnd_user;
1669:
1670: l_user xtr_dealer_codes.dealer_code%TYPE;
1671: l_dual_user xtr_dealer_codes.dealer_code%TYPE;
1672: l_dual_date DATE;
1673:
1674: Begin

Line 1671: l_dual_user xtr_dealer_codes.dealer_code%TYPE;

1667: from xtr_dealer_codes_v
1668: where user_id = p_fnd_user;
1669:
1670: l_user xtr_dealer_codes.dealer_code%TYPE;
1671: l_dual_user xtr_dealer_codes.dealer_code%TYPE;
1672: l_dual_date DATE;
1673:
1674: Begin
1675: