DBA Data[Home] [Help]

APPS.BEN_PDW_COPY_BEN_TO_STG dependencies on FND_CURRENCIES_VL

Line 3868: from fnd_currencies_vl

3864: FUNCTION GET_CURRENCY(p_currency_code IN VARCHAR2,p_effective_date IN DATE)
3865: RETURN VARCHAR2 IS
3866: CURSOR csr_currency (c_currency_code VARCHAR2, c_effective_date DATE) IS
3867: select name
3868: from fnd_currencies_vl
3869: where (start_date_active is null or start_date_active <=c_effective_date)
3870: and (end_date_active is null or end_date_active >= c_effective_date)
3871: and enabled_flag = 'Y' and currency_code=c_currency_code;
3872:

Line 3873: l_name fnd_currencies_vl.NAME%TYPE;

3869: where (start_date_active is null or start_date_active <=c_effective_date)
3870: and (end_date_active is null or end_date_active >= c_effective_date)
3871: and enabled_flag = 'Y' and currency_code=c_currency_code;
3872:
3873: l_name fnd_currencies_vl.NAME%TYPE;
3874: BEGIN
3875: OPEN csr_currency (p_currency_code ,p_effective_date );
3876: FETCH csr_currency into l_name;
3877: CLOSE csr_currency;