APPS.PA_CURRENCY SQL Statements

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

Line: 17

    SELECT FC.Currency_Code,
           FC.Minimum_Accountable_Unit,
           FC.Precision,
           FC.Extended_Precision
      INTO l_curr_code,
           l_mau,
           l_sp,
           l_ep
      FROM FND_CURRENCIES FC,
           GL_SETS_OF_BOOKS GB,
           PA_IMPLEMENTATIONS IMP
     WHERE FC.Currency_Code =
               DECODE(IMP.Set_Of_Books_ID, Null, Null,GB.CURRENCY_CODE)
       AND GB.Set_Of_Books_ID = IMP.Set_Of_Books_ID;

Line: 32

     SELECT FC.Currency_Code,
           FC.Minimum_Accountable_Unit,
           FC.Precision,
           FC.Extended_Precision
      INTO l_curr_code,
           l_mau,
           l_sp,
           l_ep
      FROM FND_CURRENCIES FC,
           GL_SETS_OF_BOOKS GB,
           PA_IMPLEMENTATIONS_ALL IMP
     WHERE FC.Currency_Code =
               DECODE(IMP.Set_Of_Books_ID, Null, Null,GB.CURRENCY_CODE)
       AND GB.Set_Of_Books_ID = IMP.Set_Of_Books_ID
       AND IMP.org_id = G_org_id;

Line: 76

    SELECT FC.Currency_Code,
           FC.Minimum_Accountable_Unit,
           FC.Precision,
           FC.Extended_Precision
      INTO G_curr_code,
           G_mau,
           G_sp,
           G_ep
      FROM FND_CURRENCIES FC,
           GL_SETS_OF_BOOKS GB,
           PA_IMPLEMENTATIONS IMP
     WHERE FC.Currency_Code =
               DECODE(IMP.Set_Of_Books_ID, Null, Null,GB.CURRENCY_CODE)
       AND GB.Set_Of_Books_ID = IMP.Set_Of_Books_ID;

Line: 108

      SELECT FC.Minimum_Accountable_Unit,
             FC.Precision,
             FC.Extended_Precision
        INTO l_mau,
             l_sp,
             l_ep
        FROM FND_CURRENCIES FC
       WHERE FC.Currency_Code = l_curr_code;

Line: 296

    SELECT FC.Currency_Code,
           FC.Minimum_Accountable_Unit,
           FC.Precision,
           FC.Extended_Precision
      INTO l_curr_code,
           l_mau,
           l_sp,
           l_ep
      FROM FND_CURRENCIES FC,
           GL_SETS_OF_BOOKS GB,
           PA_IMPLEMENTATIONS_ALL IMP
     WHERE FC.Currency_Code =
               DECODE(IMP.Set_Of_Books_ID, Null, Null,GB.CURRENCY_CODE)
       AND GB.Set_Of_Books_ID = IMP.Set_Of_Books_ID
       --AND nvl(IMP.Org_ID,-99) = nvl(X_Org_ID, -99);

Line: 447

    SELECT FC.Currency_Code,
           FC.Minimum_Accountable_Unit,
           FC.Precision,
           FC.Extended_Precision
      INTO l_curr_code,
           l_mau,
           l_sp,
           l_ep
      FROM FND_CURRENCIES FC,
           GL_SETS_OF_BOOKS GB,
           PA_IMPLEMENTATIONS IMP
     WHERE FC.Currency_Code =
               DECODE(IMP.Set_Of_Books_ID, Null, Null,GB.CURRENCY_CODE)
       AND GB.Set_Of_Books_ID = IMP.Set_Of_Books_ID;

Line: 535

       SELECT FC.Minimum_Accountable_Unit,
              FC.Precision,
              FC.Extended_Precision
         INTO l_mau,
              l_sp,
              l_ep
         FROM FND_CURRENCIES FC
        WHERE FC.Currency_Code = l_curr_code;