APPS.IRC_ISC_BUS dependencies on FND_CURRENCIES

Line 2064: -- fnd_currencies

2060: -- {Start Of Comments}
2061: --
2062: -- Description:
2063: -- This procedure is used to ensure that salary_currency exists in
2064: -- fnd_currencies
2065: --
2066: -- Pre Conditions:
2067: -- g_old_rec has been populated with details of the values currently in
2068: -- the database.

Line 2100: select null from fnd_currencies fc

2096: l_salary_currency varchar2(1);
2097: l_api_updating boolean;
2098: --
2099: cursor csr_salary_currency is
2100: select null from fnd_currencies fc
2101: where p_salary_currency = fc.currency_code
2102: and p_effective_date between
2103: nvl(fc.start_date_active, p_effective_date)
2104: and nvl(fc.end_date_active, p_effective_date);

Line 2145: -- Check that salary_currency exists in fnd_currencies.

2141: fnd_message.set_name('PER','IRC_412018_CURRENCY_NOT_FOUND');
2142: fnd_message.raise_error;
2143: end if;
2144: --
2145: -- Check that salary_currency exists in fnd_currencies.
2146: --
2147: if p_salary_currency is not null then
2148: hr_utility.set_location(l_proc,40);
2149: open csr_salary_currency;