DBA Data[Home] [Help]

APPS.PAY_OPM_BUS dependencies on FND_CURRENCIES_VL

Line 911: -- row on the FND_CURRENCIES_VL table.

907: -- ----------------------------------------------------------------------------
908: --
909: -- Description:
910: -- Check that the currency_code is not null and that it refers to a
911: -- row on the FND_CURRENCIES_VL table.
912: -- Check whether it is same as of Payment type's (only if it is not null).
913: --
914: -- Pre-Requisites:
915: -- None

Line 948: from fnd_currencies_vl cur

944: l_dummy number;
945: --
946: cursor csr_currency_code_exists is
947: select null
948: from fnd_currencies_vl cur
949: where cur.enabled_flag = 'Y'
950: and cur.currency_flag = 'Y'
951: and p_effective_date between nvl(start_date_active,p_effective_date)
952: and nvl(end_date_active,p_effective_date)

Line 1002: -- Check currency_code exists within FND_CURRENCIES_VL.

998: or (NOT l_api_updating)) then
999: --
1000: hr_utility.set_location(l_proc,20);
1001: --
1002: -- Check currency_code exists within FND_CURRENCIES_VL.
1003: -- Also checks whether Paymen Type's
1004: --
1005: open csr_currency_code_exists;
1006: fetch csr_currency_code_exists into l_dummy;