DBA Data[Home] [Help]

APPS.AR_AUTOREM_API dependencies on AP_BANK_ACCOUNTS

Line 104: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;

100: l_currency_code ar_cash_receipts.currency_code%TYPE;
101: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;
102: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
103: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
104: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;
105: l_remittance_bank_account_id ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL;
106: o_batch_id NUMBER;
107:
108: p_create_only VARCHAR2(1);

Line 993: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;

989: l_currency_code ar_cash_receipts.currency_code%TYPE;
990: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;
991: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
992: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
993: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;
994: l_remittance_bank_account_id ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL;
995: l_batch_applied_status ar_batches.batch_applied_status%TYPE;
996: l_return_status VARCHAR2(1);
997: o_batch_id NUMBER;

Line 1510: p_remmitance_bank_branch_id IN ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL,

1506: p_currency_code IN ar_batches.currency_code%TYPE,
1507: p_remmitance_method IN ar_batches.remit_method_code%TYPE,
1508: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE,
1509: p_payment_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
1510: p_remmitance_bank_branch_id IN ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL,
1511: p_remmitance_bank_account_id IN ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL,
1512: p_remit_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE DEFAULT NULL, --bug12924584
1513: p_batch_id OUT NOCOPY NUMBER
1514: ) IS

Line 1592: from ap_bank_accounts ba, ap_bank_branches bb, ar_receipt_method_accounts rma, ar_system_parameters asp

1588: select bbt.bank_branch_id ,bbt.remit_account_id
1589: from ap_bank_branches bbt
1590: where bbt.bank_branch_id in
1591: (select distinct bb.bank_branch_id
1592: from ap_bank_accounts ba, ap_bank_branches bb, ar_receipt_method_accounts rma, ar_system_parameters asp
1593: where rma.receipt_method_id = nvl(p_receipt_method_id, rma.receipt_method_id )
1594: and rma.bank_account_id = ba.bank_account_id
1595: and ( ba.currency_code = p_currency_code
1596: or ba.receipt_multi_currency_flag = 'Y' )

Line 1606: from ar_receipt_method_accounts rma2, ap_bank_accounts ba2, ap_bank_branches bb2

1602: and ( bb.bank_branch_id = ba.bank_branch_id
1603: or ( bb.institution_type = 'CLEARING HOUSE'
1604: and exists
1605: ( select 1
1606: from ar_receipt_method_accounts rma2, ap_bank_accounts ba2, ap_bank_branches bb2
1607: where rma2.receipt_method_id = nvl(p_receipt_method_id, rma2.receipt_method_id)
1608: and rma2.bank_account_id = ba2.bank_account_id
1609: and ba2.set_of_books_id = asp.set_of_books_id
1610: and ba2.currency_code = p_currency_code