APPS.XTR_EXP_TRANSFERS_PKG dependencies on XTR_DEALER_CODES_V

Line 585: from xtr_dealer_codes_v

581: function VALID_DEALER_CODE(p_dealer_code IN VARCHAR2) return BOOLEAN is
582:
583: CURSOR dealer_code IS
584: select COUNT(*)
585: from xtr_dealer_codes_v
586: where dealer_code = p_dealer_code;
587:
588: v_count NUMBER;
589: BEGIN

Line 1334: from xtr_dealer_codes_v

1330: procedure CREATE_EXP_DEAL(ARec_Exp IN XTR_EXPOSURE_TRANSACTIONS%rowtype) IS
1331:
1332: cursor FIND_USER (p_fnd_user in number) is
1333: select dealer_code
1334: from xtr_dealer_codes_v
1335: where user_id = p_fnd_user;
1336:
1337: l_user xtr_dealer_codes.dealer_code%TYPE;
1338: l_dual_user xtr_dealer_codes.dealer_code%TYPE;

Line 1550: from XTR_DEALER_CODES_V

1546:
1547: -- bug 1849281 proper dealer id should be inserted into dda
1548: cursor DEALER is
1549: select DEALER_CODE
1550: from XTR_DEALER_CODES_V
1551: where user_id = g_user_id;
1552: --
1553: v_dealer xtr_dealer_codes.dealer_code%TYPE;
1554: -- end bug 1849281

Line 1713: from xtr_dealer_codes_v

1709: deal_num OUT NOCOPY NUMBER) IS
1710:
1711: CURSOR FIND_USER (p_fnd_user in number) is
1712: select dealer_code
1713: from xtr_dealer_codes_v
1714: where user_id = p_fnd_user;
1715:
1716: BEGIN
1717: IF xtr_risk_debug_pkg.g_Debug THEN

Line 1865: from xtr_dealer_codes_v

1861: limit_error OUT NOCOPY BOOLEAN) IS
1862:
1863: CURSOR FIND_USER (p_fnd_user in number) is
1864: select dealer_code
1865: from xtr_dealer_codes_v
1866: where user_id = p_fnd_user;
1867:
1868: BEGIN
1869: IF xtr_risk_debug_pkg.g_Debug THEN