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: var_curr_code VARCHAR2(15);
1580: var_CONVERSION_TYPE VARCHAR2(30);

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

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

Line 1591: FROM gl_currencies

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