DBA Data[Home] [Help]

APPS.PQH_BGT_BUS dependencies on FND_CURRENCIES

Line 1884: from fnd_currencies a

1880: l_dummy varchar2(1);
1881: --
1882: cursor c1 is
1883: select null
1884: from fnd_currencies a
1885: where a.currency_code = p_currency_code;
1886: --
1887: Begin
1888: --

Line 1901: -- check if currency_code value exists in fnd_currencies table

1897: <> nvl(pqh_bgt_shd.g_old_rec.currency_code,hr_api.g_varchar2)
1898: or not l_api_updating) and
1899: p_currency_code is not null then
1900: --
1901: -- check if currency_code value exists in fnd_currencies table
1902: --
1903: open c1;
1904: --
1905: fetch c1 into l_dummy;

Line 1910: -- raise error as FK does not relate to PK in fnd_currencies

1906: if c1%notfound then
1907: --
1908: close c1;
1909: --
1910: -- raise error as FK does not relate to PK in fnd_currencies
1911: -- table.
1912: --
1913: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK5');
1914: --