APPS.PA_MULTI_CURRENCY SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 16

  SELECT default_rate_date_code
  INTO   l_rate_date_code
  FROM   pa_implementations ;

Line: 34

  SELECT   default_rate_type
  INTO     l_rate_type
  FROM     pa_implementations ;

Line: 567

       SELECT 'X'
       FROM   dual
       WHERE EXISTS(
       SELECT 'X'
       FROM   pa_conversion_types_v
       WHERE  conversion_type = P_rate_type) ;

Line: 627

       SELECT 'X'
       FROM   dual
       WHERE EXISTS(
       SELECT 'X'
       FROM   FND_CURRENCIES
       WHERE  currency_code = P_Currency_code
       AND    enabled_flag = 'Y'
       AND    P_EI_date
       BETWEEN NVL(start_date_active, P_EI_date)
       AND     NVL(end_date_active , P_EI_date)) ;

Line: 709

       SELECT conversion_type
       FROM  pa_conversion_types_v
       WHERE user_conversion_type = P_user_rate_type;

Line: 798

    GL_DAILY_CONV_TYPES_PKG.select_columns(P_Conversion_Type, X_User_Conversion_Type);