DBA Data[Home] [Help]

APPS.XTR_IMPORT_DEAL_DATA dependencies on XTR_BANK_ACCOUNTS_V

Line 402: FROM xtr_bank_accounts_v

398: p_new_number XTR_DEALS_INTERFACE.CPARTY_ACCOUNT_NO%TYPE;
399: b_local_updated BOOLEAN := FALSE;
400: CURSOR translate_by_number(p_number VARCHAR2) is
401: SELECT bank_short_code
402: FROM xtr_bank_accounts_v
403: WHERE account_number = p_number;
404:
405: CURSOR translate_by_name(p_name VARCHAR2) IS
406: SELECT account_number

Line 407: FROM xtr_bank_accounts_v

403: WHERE account_number = p_number;
404:
405: CURSOR translate_by_name(p_name VARCHAR2) IS
406: SELECT account_number
407: FROM xtr_bank_accounts_v
408: WHERE bank_short_code=p_name;
409:
410: BEGIN
411: IF p_account_number IS NOT NULL THEN