APPS.XTR_NOTIONAL_BANK_ACCOUNTS dependencies on XTR_DEALER_CODES

Line 126: FROM xtr_dealer_codes

122: WHERE cashpool_id = p_cashpool_id;
123:
124: cursor dealer_details IS
125: SELECT dealer_code
126: FROM xtr_dealer_codes
127: WHERE user_id = FND_GLOBAL.USER_ID;
128:
129: l_bank_code XTR_BANK_ACCOUNTS.BANK_CODE%TYPE;
130: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;

Line 144: l_created_by XTR_DEALER_CODES.DEALER_CODE%TYPE;

140:
141: l_bank_short_code XTR_BANK_ACCOUNTS.BANK_SHORT_CODE%TYPE;
142: l_new_acct_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
143:
144: l_created_by XTR_DEALER_CODES.DEALER_CODE%TYPE;
145: l_updated_by XTR_DEALER_CODES.DEALER_CODE%TYPE;
146:
147: l_counter NUMBER;
148: l_dummy_char VARCHAR2(1);

Line 145: l_updated_by XTR_DEALER_CODES.DEALER_CODE%TYPE;

141: l_bank_short_code XTR_BANK_ACCOUNTS.BANK_SHORT_CODE%TYPE;
142: l_new_acct_number XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
143:
144: l_created_by XTR_DEALER_CODES.DEALER_CODE%TYPE;
145: l_updated_by XTR_DEALER_CODES.DEALER_CODE%TYPE;
146:
147: l_counter NUMBER;
148: l_dummy_char VARCHAR2(1);
149:

Line 342: FROM xtr_dealer_codes

338: AND xpin.party_type = 'C';
339:
340: cursor dealer_details IS
341: SELECT dealer_code
342: FROM xtr_dealer_codes
343: WHERE user_id = FND_GLOBAL.USER_ID;
344:
345: l_conc_account_id CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE;
346:

Line 358: l_updated_by XTR_DEALER_CODES.DEALER_CODE%TYPE;

354:
355: l_orig_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
356: l_new_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
357:
358: l_updated_by XTR_DEALER_CODES.DEALER_CODE%TYPE;
359:
360: BEGIN
361: OPEN account_changed;
362: FETCH account_changed