DBA Data[Home] [Help]

APPS.ARP_PROCESS_CREDIT_UTIL dependencies on CE_BANK_BRANCHES_V

Line 764: ce_bank_branches_v bp /*Bug3348454*/

760: ar_receipt_method_accounts arma,
761: ce_bank_accounts cba,
762: ce_bank_acct_uses aba,
763: ar_receipt_classes arc,
764: ce_bank_branches_v bp /*Bug3348454*/
765: WHERE arm.receipt_method_id = rcrm.receipt_method_id
766: AND arm.receipt_method_id = arma.receipt_method_id
767: AND arm.receipt_class_id = arc.receipt_class_id
768: AND arma.remit_bank_acct_use_id = aba.bank_acct_use_id

Line 1196: l_bank_name ce_bank_branches_v.bank_name%type;

1192: l_payment_method_name ar_receipt_methods.name%type;
1193: l_creation_method_code ar_receipt_classes.creation_method_code%type;
1194: l_cust_bank_account_id ce_bank_accounts.bank_account_id%type;
1195: l_bank_account_num ce_bank_accounts.bank_account_num%type;
1196: l_bank_name ce_bank_branches_v.bank_name%type;
1197: l_bank_branch_name ce_bank_branches_v.bank_branch_name%type;
1198: l_bank_branch_id ce_bank_branches_v.branch_party_id%TYPE;
1199:
1200: -- 7/18/98: gjayanth: ar_receipt_methods.payment_type_code is an

Line 1197: l_bank_branch_name ce_bank_branches_v.bank_branch_name%type;

1193: l_creation_method_code ar_receipt_classes.creation_method_code%type;
1194: l_cust_bank_account_id ce_bank_accounts.bank_account_id%type;
1195: l_bank_account_num ce_bank_accounts.bank_account_num%type;
1196: l_bank_name ce_bank_branches_v.bank_name%type;
1197: l_bank_branch_name ce_bank_branches_v.bank_branch_name%type;
1198: l_bank_branch_id ce_bank_branches_v.branch_party_id%TYPE;
1199:
1200: -- 7/18/98: gjayanth: ar_receipt_methods.payment_type_code is an
1201: -- additional parameter to get_bank_defaults().

Line 1198: l_bank_branch_id ce_bank_branches_v.branch_party_id%TYPE;

1194: l_cust_bank_account_id ce_bank_accounts.bank_account_id%type;
1195: l_bank_account_num ce_bank_accounts.bank_account_num%type;
1196: l_bank_name ce_bank_branches_v.bank_name%type;
1197: l_bank_branch_name ce_bank_branches_v.bank_branch_name%type;
1198: l_bank_branch_id ce_bank_branches_v.branch_party_id%TYPE;
1199:
1200: -- 7/18/98: gjayanth: ar_receipt_methods.payment_type_code is an
1201: -- additional parameter to get_bank_defaults().
1202: --