APPS.ARP_RW_BATCHES_PKG dependencies on AR_RECEIPT_METHOD_ACCOUNTS

Line 449: FROM ar_receipt_method_accounts rma,

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

Line 896: FROM ar_receipt_method_accounts rma2,

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

Line 930: ar_receipt_method_accounts rma

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

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

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

Line 1306: l_override_remit_flag ar_receipt_method_accounts.override_remit_account_flag%TYPE;

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

Line 1437: ar_receipt_method_accounts rma,

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

Line 1489: ar_receipt_method_accounts rma,

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

Line 1543: ar_receipt_method_accounts rma,

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