APPS.ARI_UTILITIES dependencies on CE_BANK_BRANCHES_V

Line 1721: FROM ce_bank_branches_v

1717: | Cursor to fetch bank branch based on routing number |
1718: +-----------------------------------------------------*/
1719: CURSOR bank_branch_cur IS
1720: SELECT branch_party_id bank_branch_id
1721: FROM ce_bank_branches_v
1722: WHERE branch_number = p_routing_number
1723: and nvl(trunc(end_date), trunc(sysdate)) >= trunc(sysdate);
1724:
1725: CURSOR bank_directory_cur IS

Line 1772: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Found routing number in ce_bank_branches_v');

1768: OPEN bank_branch_cur;
1769: FETCH bank_branch_cur INTO bank_branch_rec;
1770: IF (bank_branch_cur%FOUND) then
1771: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1772: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Found routing number in ce_bank_branches_v');
1773: end if;
1774: CLOSE bank_branch_cur;
1775: RETURN 1;
1776: ELSE

Line 1809: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Routing Number not found in ce_bank_branches_v');

1805: END IF;
1806:
1807: ELSE
1808: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1809: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Routing Number not found in ce_bank_branches_v');
1810: end if;
1811: RETURN 0;
1812: END IF;
1813: