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

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

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

Line 609: FROM gl_currencies

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