APPS.OKL_ASD_PVT dependencies on GL_CURRENCIES

Line 595: l_func_currency GL_CURRENCIES.CURRENCY_CODE%TYPE;

591: p_asdv_rec IN asdv_rec_type,
592: x_asdv_rec OUT NOCOPY asdv_rec_type
593: ) IS
594:
595: l_func_currency GL_CURRENCIES.CURRENCY_CODE%TYPE;
596: currency_validation_failed EXCEPTION;
597: l_ok VARCHAR2(1);
598:
599: CURSOR conv_type_csr (p_conv_type gl_daily_conversion_types.conversion_type%TYPE) IS

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

600: SELECT 'Y'
601: FROM gl_daily_conversion_types
602: WHERE conversion_type = p_conv_type;
603:
604: CURSOR curr_csr (p_curr_code gl_currencies.currency_code%TYPE) IS
605: SELECT 'Y'
606: FROM gl_currencies
607: WHERE currency_code = p_curr_code
608: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date_active), TRUNC(SYSDATE)) AND

Line 606: FROM gl_currencies

602: WHERE conversion_type = p_conv_type;
603:
604: CURSOR curr_csr (p_curr_code gl_currencies.currency_code%TYPE) IS
605: SELECT 'Y'
606: FROM gl_currencies
607: WHERE currency_code = p_curr_code
608: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date_active), TRUNC(SYSDATE)) AND
609: NVL(TRUNC(end_date_active), TRUNC(SYSDATE));
610: