APPS.OKL_TAL_PVT dependencies on GL_CURRENCIES

Line 1576: l_func_currency GL_CURRENCIES.CURRENCY_CODE%TYPE;

1572: p_talv_rec IN talv_rec_type,
1573: x_talv_rec OUT NOCOPY talv_rec_type
1574: ) IS
1575:
1576: l_func_currency GL_CURRENCIES.CURRENCY_CODE%TYPE;
1577: currency_validation_failed EXCEPTION;
1578: l_ok VARCHAR2(1);
1579:
1580: CURSOR conv_type_csr (p_conv_type gl_daily_conversion_types.conversion_type%TYPE) IS

Line 1585: CURSOR curr_csr (p_curr_code gl_currencies.currency_code%TYPE) IS

1581: SELECT 'Y'
1582: FROM gl_daily_conversion_types
1583: WHERE conversion_type = p_conv_type;
1584:
1585: CURSOR curr_csr (p_curr_code gl_currencies.currency_code%TYPE) IS
1586: SELECT 'Y'
1587: FROM gl_currencies
1588: WHERE currency_code = p_curr_code
1589: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date_active), TRUNC(SYSDATE)) AND

Line 1587: FROM gl_currencies

1583: WHERE conversion_type = p_conv_type;
1584:
1585: CURSOR curr_csr (p_curr_code gl_currencies.currency_code%TYPE) IS
1586: SELECT 'Y'
1587: FROM gl_currencies
1588: WHERE currency_code = p_curr_code
1589: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date_active), TRUNC(SYSDATE)) AND
1590: NVL(TRUNC(end_date_active), TRUNC(SYSDATE));
1591: