DBA Data[Home] [Help]

APPS.IBY_VALIDATIONSETS_PUB dependencies on CE_BANK_ACCOUNTS

Line 47: int_bank_acc_num CE_BANK_ACCOUNTS.bank_account_num%TYPE,

43: int_bank_branch_num CE_BANK_BRANCHES_V.branch_number%TYPE,
44: int_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
45: int_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
46:
47: int_bank_acc_num CE_BANK_ACCOUNTS.bank_account_num%TYPE,
48: int_bank_acc_name CE_BANK_ACCOUNTS.bank_account_name%TYPE,
49: int_bank_acc_name_alt CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,
50: int_bank_acc_type CE_BANK_ACCOUNTS.bank_account_type%TYPE,
51: int_bank_acc_iban CE_BANK_ACCOUNTS.iban_number%TYPE,

Line 48: int_bank_acc_name CE_BANK_ACCOUNTS.bank_account_name%TYPE,

44: int_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
45: int_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
46:
47: int_bank_acc_num CE_BANK_ACCOUNTS.bank_account_num%TYPE,
48: int_bank_acc_name CE_BANK_ACCOUNTS.bank_account_name%TYPE,
49: int_bank_acc_name_alt CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,
50: int_bank_acc_type CE_BANK_ACCOUNTS.bank_account_type%TYPE,
51: int_bank_acc_iban CE_BANK_ACCOUNTS.iban_number%TYPE,
52: int_bank_assigned_id1 VARCHAR2(240),

Line 49: int_bank_acc_name_alt CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,

45: int_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
46:
47: int_bank_acc_num CE_BANK_ACCOUNTS.bank_account_num%TYPE,
48: int_bank_acc_name CE_BANK_ACCOUNTS.bank_account_name%TYPE,
49: int_bank_acc_name_alt CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,
50: int_bank_acc_type CE_BANK_ACCOUNTS.bank_account_type%TYPE,
51: int_bank_acc_iban CE_BANK_ACCOUNTS.iban_number%TYPE,
52: int_bank_assigned_id1 VARCHAR2(240),
53: int_bank_assigned_id2 VARCHAR2(240),

Line 50: int_bank_acc_type CE_BANK_ACCOUNTS.bank_account_type%TYPE,

46:
47: int_bank_acc_num CE_BANK_ACCOUNTS.bank_account_num%TYPE,
48: int_bank_acc_name CE_BANK_ACCOUNTS.bank_account_name%TYPE,
49: int_bank_acc_name_alt CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,
50: int_bank_acc_type CE_BANK_ACCOUNTS.bank_account_type%TYPE,
51: int_bank_acc_iban CE_BANK_ACCOUNTS.iban_number%TYPE,
52: int_bank_assigned_id1 VARCHAR2(240),
53: int_bank_assigned_id2 VARCHAR2(240),
54: int_eft_user_number CE_BANK_ACCOUNTS.eft_user_num%TYPE,

Line 51: int_bank_acc_iban CE_BANK_ACCOUNTS.iban_number%TYPE,

47: int_bank_acc_num CE_BANK_ACCOUNTS.bank_account_num%TYPE,
48: int_bank_acc_name CE_BANK_ACCOUNTS.bank_account_name%TYPE,
49: int_bank_acc_name_alt CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,
50: int_bank_acc_type CE_BANK_ACCOUNTS.bank_account_type%TYPE,
51: int_bank_acc_iban CE_BANK_ACCOUNTS.iban_number%TYPE,
52: int_bank_assigned_id1 VARCHAR2(240),
53: int_bank_assigned_id2 VARCHAR2(240),
54: int_eft_user_number CE_BANK_ACCOUNTS.eft_user_num%TYPE,
55: int_bank_acc_chk_dgts CE_BANK_ACCOUNTS.check_digits%TYPE,

Line 54: int_eft_user_number CE_BANK_ACCOUNTS.eft_user_num%TYPE,

50: int_bank_acc_type CE_BANK_ACCOUNTS.bank_account_type%TYPE,
51: int_bank_acc_iban CE_BANK_ACCOUNTS.iban_number%TYPE,
52: int_bank_assigned_id1 VARCHAR2(240),
53: int_bank_assigned_id2 VARCHAR2(240),
54: int_eft_user_number CE_BANK_ACCOUNTS.eft_user_num%TYPE,
55: int_bank_acc_chk_dgts CE_BANK_ACCOUNTS.check_digits%TYPE,
56: int_eft_req_identifier CE_BANK_ACCOUNTS.
57: eft_requester_identifier%TYPE,
58: int_bank_acc_short_name CE_BANK_ACCOUNTS.short_account_name%TYPE,

Line 55: int_bank_acc_chk_dgts CE_BANK_ACCOUNTS.check_digits%TYPE,

51: int_bank_acc_iban CE_BANK_ACCOUNTS.iban_number%TYPE,
52: int_bank_assigned_id1 VARCHAR2(240),
53: int_bank_assigned_id2 VARCHAR2(240),
54: int_eft_user_number CE_BANK_ACCOUNTS.eft_user_num%TYPE,
55: int_bank_acc_chk_dgts CE_BANK_ACCOUNTS.check_digits%TYPE,
56: int_eft_req_identifier CE_BANK_ACCOUNTS.
57: eft_requester_identifier%TYPE,
58: int_bank_acc_short_name CE_BANK_ACCOUNTS.short_account_name%TYPE,
59: int_bank_acc_holder_name CE_BANK_ACCOUNTS.account_holder_name%TYPE,

Line 56: int_eft_req_identifier CE_BANK_ACCOUNTS.

52: int_bank_assigned_id1 VARCHAR2(240),
53: int_bank_assigned_id2 VARCHAR2(240),
54: int_eft_user_number CE_BANK_ACCOUNTS.eft_user_num%TYPE,
55: int_bank_acc_chk_dgts CE_BANK_ACCOUNTS.check_digits%TYPE,
56: int_eft_req_identifier CE_BANK_ACCOUNTS.
57: eft_requester_identifier%TYPE,
58: int_bank_acc_short_name CE_BANK_ACCOUNTS.short_account_name%TYPE,
59: int_bank_acc_holder_name CE_BANK_ACCOUNTS.account_holder_name%TYPE,
60: int_bank_acc_holder_name_alt

Line 58: int_bank_acc_short_name CE_BANK_ACCOUNTS.short_account_name%TYPE,

54: int_eft_user_number CE_BANK_ACCOUNTS.eft_user_num%TYPE,
55: int_bank_acc_chk_dgts CE_BANK_ACCOUNTS.check_digits%TYPE,
56: int_eft_req_identifier CE_BANK_ACCOUNTS.
57: eft_requester_identifier%TYPE,
58: int_bank_acc_short_name CE_BANK_ACCOUNTS.short_account_name%TYPE,
59: int_bank_acc_holder_name CE_BANK_ACCOUNTS.account_holder_name%TYPE,
60: int_bank_acc_holder_name_alt
61: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,
62:

Line 59: int_bank_acc_holder_name CE_BANK_ACCOUNTS.account_holder_name%TYPE,

55: int_bank_acc_chk_dgts CE_BANK_ACCOUNTS.check_digits%TYPE,
56: int_eft_req_identifier CE_BANK_ACCOUNTS.
57: eft_requester_identifier%TYPE,
58: int_bank_acc_short_name CE_BANK_ACCOUNTS.short_account_name%TYPE,
59: int_bank_acc_holder_name CE_BANK_ACCOUNTS.account_holder_name%TYPE,
60: int_bank_acc_holder_name_alt
61: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,
62:
63: payer_le_name IBY_PP_FIRST_PARTY_V.party_legal_name%TYPE,

Line 61: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,

57: eft_requester_identifier%TYPE,
58: int_bank_acc_short_name CE_BANK_ACCOUNTS.short_account_name%TYPE,
59: int_bank_acc_holder_name CE_BANK_ACCOUNTS.account_holder_name%TYPE,
60: int_bank_acc_holder_name_alt
61: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,
62:
63: payer_le_name IBY_PP_FIRST_PARTY_V.party_legal_name%TYPE,
64: payer_le_country IBY_PP_FIRST_PARTY_V.party_address_country%TYPE,
65: payer_phone IBY_PP_FIRST_PARTY_V.party_phone%TYPE,

Line 96: CE_BANK_ACCOUNTS_V.bank_account_name_alt%TYPE,

92: ext_bank_acc_holder_name IBY_EXT_BANK_ACCOUNTS_V.
93: primary_acct_owner_name%TYPE,
94:
95: ext_bank_acc_holder_name_alt
96: CE_BANK_ACCOUNTS_V.bank_account_name_alt%TYPE,
97: ext_eft_swift_code IBY_EXT_BANK_ACCOUNTS_INT_V.eft_swift_code%TYPE, -- Payee BIC (added by sodash)
98:
99: payee_party_name HZ_PARTIES.party_name%TYPE,
100: payee_party_addr1 HZ_LOCATIONS.address1%TYPE,

Line 480: CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,

476: payer_bank_branch_name_alt
477: CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
478:
479: payer_bank_acct_name_alt
480: CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,
481: payer_bank_acct_type
482: CE_BANK_ACCOUNTS.bank_account_type%TYPE,
483: payer_bank_assigned_id1
484: VARCHAR2(240),

Line 482: CE_BANK_ACCOUNTS.bank_account_type%TYPE,

478:
479: payer_bank_acct_name_alt
480: CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,
481: payer_bank_acct_type
482: CE_BANK_ACCOUNTS.bank_account_type%TYPE,
483: payer_bank_assigned_id1
484: VARCHAR2(240),
485: payer_bank_assigned_id2
486: VARCHAR2(240),

Line 488: CE_BANK_ACCOUNTS.eft_user_num%TYPE,

484: VARCHAR2(240),
485: payer_bank_assigned_id2
486: VARCHAR2(240),
487: payer_eft_user_number
488: CE_BANK_ACCOUNTS.eft_user_num%TYPE,
489: payer_eft_req_identifier
490: CE_BANK_ACCOUNTS.eft_requester_identifier%TYPE,
491: payer_bank_acct_short_name
492: CE_BANK_ACCOUNTS.short_account_name%TYPE,

Line 490: CE_BANK_ACCOUNTS.eft_requester_identifier%TYPE,

486: VARCHAR2(240),
487: payer_eft_user_number
488: CE_BANK_ACCOUNTS.eft_user_num%TYPE,
489: payer_eft_req_identifier
490: CE_BANK_ACCOUNTS.eft_requester_identifier%TYPE,
491: payer_bank_acct_short_name
492: CE_BANK_ACCOUNTS.short_account_name%TYPE,
493: payer_bank_acct_hold_name_alt
494: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,

Line 492: CE_BANK_ACCOUNTS.short_account_name%TYPE,

488: CE_BANK_ACCOUNTS.eft_user_num%TYPE,
489: payer_eft_req_identifier
490: CE_BANK_ACCOUNTS.eft_requester_identifier%TYPE,
491: payer_bank_acct_short_name
492: CE_BANK_ACCOUNTS.short_account_name%TYPE,
493: payer_bank_acct_hold_name_alt
494: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,
495: payer_bank_acct_holder_name
496: CE_BANK_ACCOUNTS.account_holder_name%TYPE,

Line 494: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,

490: CE_BANK_ACCOUNTS.eft_requester_identifier%TYPE,
491: payer_bank_acct_short_name
492: CE_BANK_ACCOUNTS.short_account_name%TYPE,
493: payer_bank_acct_hold_name_alt
494: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,
495: payer_bank_acct_holder_name
496: CE_BANK_ACCOUNTS.account_holder_name%TYPE,
497: payer_bank_acct_num
498: CE_BANK_ACCOUNTS.bank_account_num%TYPE,

Line 496: CE_BANK_ACCOUNTS.account_holder_name%TYPE,

492: CE_BANK_ACCOUNTS.short_account_name%TYPE,
493: payer_bank_acct_hold_name_alt
494: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,
495: payer_bank_acct_holder_name
496: CE_BANK_ACCOUNTS.account_holder_name%TYPE,
497: payer_bank_acct_num
498: CE_BANK_ACCOUNTS.bank_account_num%TYPE,
499: payer_bank_acct_name
500: CE_BANK_ACCOUNTS.bank_account_name%TYPE,

Line 498: CE_BANK_ACCOUNTS.bank_account_num%TYPE,

494: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,
495: payer_bank_acct_holder_name
496: CE_BANK_ACCOUNTS.account_holder_name%TYPE,
497: payer_bank_acct_num
498: CE_BANK_ACCOUNTS.bank_account_num%TYPE,
499: payer_bank_acct_name
500: CE_BANK_ACCOUNTS.bank_account_name%TYPE,
501: payer_bank_acct_iban_num
502: CE_BANK_ACCOUNTS.iban_number%TYPE,

Line 500: CE_BANK_ACCOUNTS.bank_account_name%TYPE,

496: CE_BANK_ACCOUNTS.account_holder_name%TYPE,
497: payer_bank_acct_num
498: CE_BANK_ACCOUNTS.bank_account_num%TYPE,
499: payer_bank_acct_name
500: CE_BANK_ACCOUNTS.bank_account_name%TYPE,
501: payer_bank_acct_iban_num
502: CE_BANK_ACCOUNTS.iban_number%TYPE,
503: payer_bank_acct_checkdigits
504: CE_BANK_ACCOUNTS.check_digits%TYPE,

Line 502: CE_BANK_ACCOUNTS.iban_number%TYPE,

498: CE_BANK_ACCOUNTS.bank_account_num%TYPE,
499: payer_bank_acct_name
500: CE_BANK_ACCOUNTS.bank_account_name%TYPE,
501: payer_bank_acct_iban_num
502: CE_BANK_ACCOUNTS.iban_number%TYPE,
503: payer_bank_acct_checkdigits
504: CE_BANK_ACCOUNTS.check_digits%TYPE,
505:
506: /* PAYEE */

Line 504: CE_BANK_ACCOUNTS.check_digits%TYPE,

500: CE_BANK_ACCOUNTS.bank_account_name%TYPE,
501: payer_bank_acct_iban_num
502: CE_BANK_ACCOUNTS.iban_number%TYPE,
503: payer_bank_acct_checkdigits
504: CE_BANK_ACCOUNTS.check_digits%TYPE,
505:
506: /* PAYEE */
507: payee_number
508: HZ_PARTIES.party_number%TYPE,