DBA Data[Home] [Help]

APPS.BEN_PRM_BUS dependencies on FND_CURRENCIES_TL

Line 255: select null from fnd_currencies_tl

251: l_proc varchar2(72) := g_package||'chk_antcpd_prtt_cntr_uom';
252: l_api_updating boolean;
253: l_dummy varchar2(1);
254: cursor c1 is
255: select null from fnd_currencies_tl
256: where currency_code = p_antcpd_prtt_cntr_uom;
257: --
258: Begin
259: --

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

268: and nvl(p_antcpd_prtt_cntr_uom,hr_api.g_varchar2)
269: <> nvl(ben_prm_shd.g_old_rec.uom,hr_api.g_varchar2)
270: or not l_api_updating) then
271: --
272: -- check if uom value exists in fnd_currencies_tl table.
273: --
274: if p_antcpd_prtt_cntr_uom is not null then
275: open c1;
276: fetch c1 into l_dummy;

Line 329: select null from fnd_currencies_tl

325: l_proc varchar2(72) := g_package||'chk_uom';
326: l_api_updating boolean;
327: l_dummy varchar2(1);
328: cursor c1 is
329: select null from fnd_currencies_tl
330: where currency_code = p_uom;
331: --
332: Begin
333: --

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

342: and nvl(p_uom,hr_api.g_varchar2)
343: <> nvl(ben_prm_shd.g_old_rec.uom,hr_api.g_varchar2)
344: or not l_api_updating) then
345: --
346: -- check if uom value exists in fnd_currencies_tl table.
347: --
348: if p_uom is not null then
349: open c1;
350: fetch c1 into l_dummy;