APPS.XTR_NI_TRANSFERS_PKG dependencies on XTR_DEALER_CODES

Line 998: from xtr_dealer_codes_v

994: l_count NUMBER;
995: BEGIN
996: select count(*)
997: into l_count
998: from xtr_dealer_codes_v
999: where dealer_code = p_dealer_code;
1000:
1001: return (l_count>0);
1002: END val_dealer_code;

Line 1347: From Xtr_Dealer_Codes

1343:
1344: l_allow_override VARCHAR2(1);
1345: cursor get_allow_override is
1346: Select allow_override
1347: From Xtr_Dealer_Codes
1348: Where user_id = fnd_global.user_id;
1349:
1350: cursor chk_int_tol is
1351: select to_number(

Line 2634: from xtr_dealer_codes_v

2630: /*------------------------------------------------------------*/
2631:
2632: cursor FIND_USER (p_fnd_user in number) is
2633: select dealer_code
2634: from xtr_dealer_codes_v
2635: where user_id = p_fnd_user;
2636:
2637: l_user xtr_dealer_codes.dealer_code%TYPE;
2638: l_dual_user xtr_dealer_codes.dealer_code%TYPE;

Line 2637: l_user xtr_dealer_codes.dealer_code%TYPE;

2633: select dealer_code
2634: from xtr_dealer_codes_v
2635: where user_id = p_fnd_user;
2636:
2637: l_user xtr_dealer_codes.dealer_code%TYPE;
2638: l_dual_user xtr_dealer_codes.dealer_code%TYPE;
2639: l_dual_date DATE;
2640:
2641: l_bank_code XTR_BANK_ACCOUNTS_V.BANK_CODE%TYPE;

Line 2638: l_dual_user xtr_dealer_codes.dealer_code%TYPE;

2634: from xtr_dealer_codes_v
2635: where user_id = p_fnd_user;
2636:
2637: l_user xtr_dealer_codes.dealer_code%TYPE;
2638: l_dual_user xtr_dealer_codes.dealer_code%TYPE;
2639: l_dual_date DATE;
2640:
2641: l_bank_code XTR_BANK_ACCOUNTS_V.BANK_CODE%TYPE;
2642: