DBA Data[Home] [Help]

APPS.ARP_TRX_DEFAULTS_3 dependencies on CE_BANK_ACCOUNTS

Line 495: ce_bank_accounts cba,

491: FROM ar_receipt_methods arm,
492: ra_cust_receipt_methods rcrm,
493: ar_receipt_method_accounts arma,
494: ce_bank_acct_uses_all aba,
495: ce_bank_accounts cba,
496: ar_receipt_classes arc,
497: ce_bank_branches_v bp /*Bug3348454*/
498: WHERE arm.receipt_method_id = rcrm.receipt_method_id
499: AND arm.receipt_method_id = arma.receipt_method_id

Line 715: ce_bank_accounts.bank_account_id%type,

711: hz_cust_site_uses.site_use_id%type,
712: p_currency_code IN
713: fnd_currencies.currency_code%type,
714: p_customer_bank_account_id OUT NOCOPY
715: ce_bank_accounts.bank_account_id%type,
716: p_bank_account_num OUT NOCOPY
717: ce_bank_accounts.bank_account_num%type,
718: p_bank_name OUT NOCOPY
719: ce_bank_branches_v.bank_name%type,

Line 717: ce_bank_accounts.bank_account_num%type,

713: fnd_currencies.currency_code%type,
714: p_customer_bank_account_id OUT NOCOPY
715: ce_bank_accounts.bank_account_id%type,
716: p_bank_account_num OUT NOCOPY
717: ce_bank_accounts.bank_account_num%type,
718: p_bank_name OUT NOCOPY
719: ce_bank_branches_v.bank_name%type,
720: p_bank_branch_name OUT NOCOPY
721: ce_bank_branches_v.bank_branch_name%type,

Line 728: ce_bank_accounts.bank_account_id%type;

724: ) RETURN BOOLEAN IS
725:
726:
727: l_customer_bank_account_id
728: ce_bank_accounts.bank_account_id%type;
729: l_bank_account_num ce_bank_accounts.bank_account_num%type;
730: l_bank_name ce_bank_branches_v.bank_name%type;
731: l_bank_branch_name ce_bank_branches_v.bank_branch_name%type;
732: l_bank_branch_id ce_bank_branches_v.branch_party_id%TYPE;

Line 729: l_bank_account_num ce_bank_accounts.bank_account_num%type;

725:
726:
727: l_customer_bank_account_id
728: ce_bank_accounts.bank_account_id%type;
729: l_bank_account_num ce_bank_accounts.bank_account_num%type;
730: l_bank_name ce_bank_branches_v.bank_name%type;
731: l_bank_branch_name ce_bank_branches_v.bank_branch_name%type;
732: l_bank_branch_id ce_bank_branches_v.branch_party_id%TYPE;
733:

Line 1006: ce_bank_accounts.bank_account_id%type,

1002: hz_cust_site_uses.site_use_id%type,
1003: p_payment_type_code IN
1004: ar_receipt_methods.payment_type_code%type,
1005: p_customer_bank_account_id OUT NOCOPY
1006: ce_bank_accounts.bank_account_id%type,
1007: p_bank_account_num OUT NOCOPY
1008: ce_bank_accounts.bank_account_num%type,
1009: p_bank_name OUT NOCOPY
1010: ce_bank_branches_v.bank_name%type,

Line 1008: ce_bank_accounts.bank_account_num%type,

1004: ar_receipt_methods.payment_type_code%type,
1005: p_customer_bank_account_id OUT NOCOPY
1006: ce_bank_accounts.bank_account_id%type,
1007: p_bank_account_num OUT NOCOPY
1008: ce_bank_accounts.bank_account_num%type,
1009: p_bank_name OUT NOCOPY
1010: ce_bank_branches_v.bank_name%type,
1011: p_bank_branch_name OUT NOCOPY
1012: ce_bank_branches_v.bank_branch_name%type,

Line 1259: ce_bank_accounts.bank_account_id%type,

1255: ar_receipt_methods.receipt_method_id%type,
1256: p_creation_method_code OUT NOCOPY
1257: ar_receipt_classes.creation_method_code%type,
1258: p_customer_bank_account_id OUT NOCOPY
1259: ce_bank_accounts.bank_account_id%type,
1260: p_bank_account_num OUT NOCOPY
1261: ce_bank_accounts.bank_account_num%type,
1262: p_bank_name OUT NOCOPY
1263: ce_bank_branches_v.bank_name%type,

Line 1261: ce_bank_accounts.bank_account_num%type,

1257: ar_receipt_classes.creation_method_code%type,
1258: p_customer_bank_account_id OUT NOCOPY
1259: ce_bank_accounts.bank_account_id%type,
1260: p_bank_account_num OUT NOCOPY
1261: ce_bank_accounts.bank_account_num%type,
1262: p_bank_name OUT NOCOPY
1263: ce_bank_branches_v.bank_name%type,
1264: p_bank_branch_name OUT NOCOPY
1265: ce_bank_branches_v.bank_branch_name%type,