DBA Data[Home] [Help]

APPS.PER_RAA_BUS dependencies on FND_CURRENCIES

Line 890: -- Checks that currency_code exists in FND_CURRENCIES

886: -- |--------------------------< chk_currency_code >----------------------------|
887: -- -----------------------------------------------------------------------------
888: --
889: -- Description:
890: -- Checks that currency_code exists in FND_CURRENCIES
891: --
892: -- Prerequisites:
893: -- g_old_rec has been populated with details of the values currently in
894: -- the database.

Line 930: select null from FND_CURRENCIES fc

926: l_currency_code varchar2(1);
927: l_api_updating boolean;
928:
929: cursor csr_currency_code is
930: select null from FND_CURRENCIES fc
931: where fc.currency_code = p_currency_code
932: and
933: (p_date_start between fc.start_date_active and fc.end_date_active);
934: --

Line 947: -- check that currency_code exists in FND_CURRENCIES.

943: p_currency_code <>
944: NVL(per_raa_shd.g_old_rec.currency_code,hr_api.g_number))
945: or (NOT l_api_updating) then
946:
947: -- check that currency_code exists in FND_CURRENCIES.
948: hr_utility.set_location(l_proc,30);
949: open csr_currency_code;
950: fetch csr_currency_code into l_currency_code;
951: if csr_currency_code%NOTFOUND then