DBA Data[Home] [Help]

APPS.BEN_PBM_BUS dependencies on FND_CURRENCIES_TL

Line 183: select null from fnd_currencies_tl

179: l_proc varchar2(72) := g_package||'chk_uom';
180: l_api_updating boolean;
181: l_dummy varchar2(1);
182: cursor c1 is
183: select null from fnd_currencies_tl
184: where currency_code = p_uom;
185: --
186: Begin
187: --

Line 200: -- check if uom value exists in fnd_currencies_tl table.

196: and nvl(p_uom,hr_api.g_varchar2)
197: <> nvl(ben_pbm_shd.g_old_rec.uom,hr_api.g_varchar2)
198: or not l_api_updating) then
199: --
200: -- check if uom value exists in fnd_currencies_tl table.
201: --
202: if p_uom is not null then
203: open c1;
204: fetch c1 into l_dummy;