APPS.ARP_RW_BATCHES_PKG dependencies on AR_RECEIPT_METHOD_ACCOUNTS

Line 448: FROM ar_receipt_method_accounts rma,

444: WHERE rm.receipt_method_id = l_batch_rec.receipt_method_id
445: AND rm.receipt_class_id = l_batch_rec.receipt_class_id
446: AND l_batch_rec.batch_date between rm.start_date and nvl(rm.end_date, l_batch_rec.batch_date)
447: AND EXISTS (SELECT 1
448: FROM ar_receipt_method_accounts rma,
449: ce_bank_accounts cba,
450: ce_bank_acct_uses ba
451: WHERE rma.receipt_method_id = l_batch_rec.receipt_method_id
452: AND rma.remit_bank_acct_use_id = ba.bank_acct_use_id

Line 895: FROM ar_receipt_method_accounts rma2,

891: AND l_batch_rec.remit_bank_acct_use_id is not null)
892: OR (bb.bank_institution_type = 'CLEARING HOUSE'
893: AND l_batch_rec.remit_bank_acct_use_id is null
894: AND EXISTS (SELECT 1
895: FROM ar_receipt_method_accounts rma2,
896: ce_bank_accounts cba2,
897: ce_bank_acct_uses ba2,
898: ce_bank_branches_v bb2,
899: hz_parties CHParty,

Line 929: ar_receipt_method_accounts rma

925: SELECT ba.bank_acct_use_id
926: FROM ce_bank_accounts cba,
927: ce_bank_acct_uses ba,
928: ce_bank_branches_v br,
929: ar_receipt_method_accounts rma
930: WHERE ba.bank_acct_use_id = l_batch_rec.remit_bank_acct_use_id
931: AND rma.receipt_method_id = nvl(l_batch_rec.receipt_method_id, rma.receipt_method_id)
932: AND rma.remit_bank_acct_use_id = ba.bank_acct_use_id
933: AND cba.bank_account_id = ba.bank_account_id

Line 1288: p_override_remit_flag OUT NOCOPY ar_receipt_method_accounts.override_remit_account_flag%TYPE,

1284: p_bank_account_id OUT NOCOPY ce_bank_accounts.bank_account_id%TYPE,
1285: p_currency_code IN OUT NOCOPY ce_bank_accounts.currency_code%TYPE,
1286: p_bank_branch_name OUT NOCOPY ce_bank_branches_v.bank_branch_name%TYPE,
1287: p_bank_branch_id OUT NOCOPY ce_bank_accounts.bank_branch_id%TYPE,
1288: p_override_remit_flag OUT NOCOPY ar_receipt_method_accounts.override_remit_account_flag%TYPE,
1289: p_remit_flag OUT NOCOPY ar_receipt_classes.remit_flag%TYPE,
1290: p_creation_status OUT NOCOPY ar_receipt_classes.creation_status%TYPE,
1291: p_meaning OUT NOCOPY ar_lookups.meaning%TYPE) IS
1292:

Line 1305: l_override_remit_flag ar_receipt_method_accounts.override_remit_account_flag%TYPE;

1301: l_bank_account_id ce_bank_accounts.bank_account_id%TYPE;
1302: l_currency_code ce_bank_accounts.currency_code%TYPE;
1303: l_bank_branch_name ce_bank_branches_v.bank_branch_name%TYPE;
1304: l_bank_branch_id ce_bank_accounts.bank_branch_id%TYPE;
1305: l_override_remit_flag ar_receipt_method_accounts.override_remit_account_flag%TYPE;
1306: l_remit_flag ar_receipt_classes.remit_flag%TYPE;
1307: l_creation_status ar_receipt_classes.creation_status%TYPE;
1308: l_meaning ar_lookups.meaning%TYPE;
1309: l_num NUMBER;

Line 1436: ar_receipt_method_accounts rma,

1432: l_bank_branch_id,
1433: l_override_remit_flag
1434: FROM ce_bank_accounts cba,
1435: ce_bank_branches_v bb,
1436: ar_receipt_method_accounts rma,
1437: ce_bank_acct_uses_ou_v ba
1438: WHERE cba.bank_account_id = l_bank_account_id
1439: AND rma.receipt_method_id = l_pay_method_id
1440: AND rma.remit_bank_acct_use_id = ba.bank_acct_use_id

Line 1488: ar_receipt_method_accounts rma,

1484: (SELECT
1485: rma.receipt_method_id
1486: FROM ce_bank_accounts cba,
1487: ce_bank_branches_v bb,
1488: ar_receipt_method_accounts rma,
1489: ce_bank_acct_uses_ou_v ba
1490: WHERE rma.receipt_method_id = l_pay_method_id
1491: AND rma.remit_bank_acct_use_id = ba.bank_acct_use_id
1492: AND cba.bank_account_id = ba.bank_account_id

Line 1542: ar_receipt_method_accounts rma,

1538: rm.receipt_class_id
1539: FROM ar_receipt_methods rm,
1540: ce_bank_accounts cba,
1541: ce_bank_branches_v bb,
1542: ar_receipt_method_accounts rma,
1543: ce_bank_acct_uses ba
1544: WHERE rm.receipt_class_id = l_rec_class_id
1545: AND rm.receipt_method_id = rma.receipt_method_id
1546: AND rma.remit_bank_acct_use_id = ba.bank_acct_use_id