DBA Data[Home] [Help]

APPS.AR_AUTOREM_API dependencies on AR_RECEIPT_METHOD_ACCOUNTS

Line 101: l_remittance_bank_account_id ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL;

97: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;
98: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
99: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
100: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;
101: l_remittance_bank_account_id ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL;
102: o_batch_id NUMBER;
103:
104: p_create_only VARCHAR2(1);
105: l_flow1 VARCHAR2(1);

Line 945: l_remittance_bank_account_id ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL;

941: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;
942: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
943: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
944: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;
945: l_remittance_bank_account_id ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL;
946: l_batch_applied_status ar_batches.batch_applied_status%TYPE;
947: l_return_status VARCHAR2(1);
948: o_batch_id NUMBER;
949: l_ins_stmt VARCHAR2(5000);

Line 1275: ar_receipt_method_accounts rma,

1271: hz_parties party,
1272: /*ar_remit_gt g,*/
1273: ar_cash_receipt_history crh,
1274: ar_batches bat,
1275: ar_receipt_method_accounts rma,
1276: ar_payment_schedules ps,
1277: ar_distributions d
1278: WHERE cr.selected_remittance_batch_id = :b_batch_id
1279: AND cr.REMIT_BANK_ACCT_USE_ID = rma.REMIT_BANK_ACCT_USE_ID

Line 1448: p_remmitance_bank_account_id IN ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL,

1444: p_remmitance_method IN ar_batches.remit_method_code%TYPE,
1445: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE,
1446: p_payment_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
1447: p_remmitance_bank_branch_id IN ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL,
1448: p_remmitance_bank_account_id IN ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL,
1449: p_batch_id OUT NOCOPY NUMBER
1450: ) IS
1451: l_batch_rec ar_batches%ROWTYPE;
1452: l_row_id VARCHAR2(50);

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

1524: select bbt.bank_branch_id ,bbt.remit_account_id
1525: from ap_bank_branches bbt
1526: where bbt.bank_branch_id in
1527: (select distinct bb.bank_branch_id
1528: from ap_bank_accounts ba, ap_bank_branches bb, ar_receipt_method_accounts rma, ar_system_parameters asp
1529: where rma.receipt_method_id = nvl(p_receipt_method_id, rma.receipt_method_id )
1530: and rma.bank_account_id = ba.bank_account_id
1531: and ( ba.currency_code = p_currency_code
1532: or ba.receipt_multi_currency_flag = 'Y' )

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

1538: and ( bb.bank_branch_id = ba.bank_branch_id
1539: or ( bb.institution_type = 'CLEARING HOUSE'
1540: and exists
1541: ( select 1
1542: from ar_receipt_method_accounts rma2, ap_bank_accounts ba2, ap_bank_branches bb2
1543: where rma2.receipt_method_id = nvl(p_receipt_method_id, rma2.receipt_method_id)
1544: and rma2.bank_account_id = ba2.bank_account_id
1545: and ba2.set_of_books_id = asp.set_of_books_id
1546: and ba2.currency_code = p_currency_code

Line 1762: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;

1758: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
1759: p_cr_amount ar_cash_receipts.amount%TYPE;
1760: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
1761: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1762: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
1763: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
1764: p_code_combination_id ar_distributions.code_combination_id%TYPE;
1765: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1766: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;

Line 1763: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;

1759: p_cr_amount ar_cash_receipts.amount%TYPE;
1760: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
1761: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1762: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
1763: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
1764: p_code_combination_id ar_distributions.code_combination_id%TYPE;
1765: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1766: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
1767: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;

Line 1901: ar_receipt_method_accounts rma,

1897: cr.payment_trxn_extension_id
1898: FROM ar_cash_receipts cr, ar_cash_receipt_history crh,
1899: ar_receipt_methods rm,
1900: ar_batches bat,
1901: ar_receipt_method_accounts rma,
1902: ar_payment_schedules ps,
1903: ar_distributions d
1904: WHERE cr.selected_remittance_batch_id = :ab_batch_id
1905: AND cr.REMIT_BANK_ACCT_USE_ID = rma.REMIT_BANK_ACCT_USE_ID

Line 2543: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;

2539: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
2540: p_cr_amount ar_cash_receipts.amount%TYPE;
2541: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
2542: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
2543: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
2544: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
2545: p_code_combination_id ar_distributions.code_combination_id%TYPE;
2546: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2547: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;

Line 2544: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;

2540: p_cr_amount ar_cash_receipts.amount%TYPE;
2541: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
2542: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
2543: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
2544: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
2545: p_code_combination_id ar_distributions.code_combination_id%TYPE;
2546: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2547: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
2548: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;

Line 3388: ar_receipt_method_accounts rma1,

3384: ar_cash_receipts cr,
3385: ar_payment_schedules ps,
3386: ar_receipt_classes rclass,
3387: ar_receipt_methods rm,
3388: ar_receipt_method_accounts rma1,
3389: ar_receipt_method_accounts rma2
3390: WHERE crh1.status = ''CONFIRMED''
3391: AND crh1.current_record_flag = ''Y''
3392: AND crh1.cash_receipt_history_id = crh.cash_receipt_history_id

Line 3389: ar_receipt_method_accounts rma2

3385: ar_payment_schedules ps,
3386: ar_receipt_classes rclass,
3387: ar_receipt_methods rm,
3388: ar_receipt_method_accounts rma1,
3389: ar_receipt_method_accounts rma2
3390: WHERE crh1.status = ''CONFIRMED''
3391: AND crh1.current_record_flag = ''Y''
3392: AND crh1.cash_receipt_history_id = crh.cash_receipt_history_id
3393: AND crh.cash_receipt_id = cr.cash_receipt_id