APPS.JL_JLCOFAAR_XMLP_PKG SQL Statements

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

Line: 15

      SELECT
        FS.COMPANY_NAME
      INTO COMPANY_NAME
      FROM
        FA_SYSTEM_CONTROLS FS;

Line: 75

      SELECT
        DISTINCT
        CURRENCY_CODE
      FROM
        JL_CO_FA_APPRAISALS
      WHERE APPRAISAL_ID = P_APPRAISAL_ID;

Line: 92

        SELECT
          1
        INTO DUMMY
        FROM
          FND_CURRENCIES
        WHERE CURRENCY_CODE = CURRVAR;

Line: 119

    SELECT
      COUNT(*)
    INTO X
    FROM
      JL_CO_FA_APPRAISALS AP,
      JL_CO_FA_ASSET_APPRS ASP,
      FND_LOOKUPS FLH,
      FND_LOOKUPS FLD
    WHERE AP.APPRAISAL_ID = P_APPRAISAL_ID
      AND ASP.APPRAISAL_ID = AP.APPRAISAL_ID
      AND DECODE(P_ALL_ROWS
          ,NULL
          ,'1'
          ,'Y'
          ,'1'
          ,ASP.STATUS) NOT IN ( DECODE(P_ALL_ROWS
          ,NULL
          ,'2'
          ,'Y'
          ,'2'
          ,'P') )
      AND FLH.LOOKUP_TYPE = 'JLCO_FA_ASSET_APPRAISAL_STATUS'
      AND FLH.LOOKUP_CODE = AP.APPRAISAL_STATUS
      AND FLD.LOOKUP_TYPE = FLH.LOOKUP_TYPE
      AND FLD.LOOKUP_CODE = ASP.STATUS
      AND UPPER(FLD.ENABLED_FLAG) = 'Y'
      AND SYSDATE BETWEEN NVL(FLD.START_DATE_ACTIVE
       ,SYSDATE - 1)
      AND NVL(FLD.END_DATE_ACTIVE
       ,SYSDATE + 1);

Line: 155

    SELECT
      COUNT(*)
    INTO X
    FROM
      JL_CO_FA_APPRAISALS AP,
      JL_CO_FA_ASSET_APPRS ASP,
      FND_LOOKUPS FLH,
      FND_LOOKUPS FLD
    WHERE AP.APPRAISAL_ID = P_APPRAISAL_ID
      AND ASP.APPRAISAL_ID = AP.APPRAISAL_ID
      AND DECODE(P_ALL_ROWS
          ,NULL
          ,'1'
          ,'Y'
          ,'1'
          ,ASP.STATUS) NOT IN ( DECODE(P_ALL_ROWS
          ,NULL
          ,'2'
          ,'Y'
          ,'2'
          ,'P') )
      AND ASP.STATUS = STATUS_CODE
      AND FLH.LOOKUP_TYPE = 'JLCO_FA_ASSET_APPRAISAL_STATUS'
      AND FLH.LOOKUP_CODE = AP.APPRAISAL_STATUS
      AND FLD.LOOKUP_TYPE = FLH.LOOKUP_TYPE
      AND FLD.LOOKUP_CODE = ASP.STATUS
      AND UPPER(FLD.ENABLED_FLAG) = 'Y'
      AND SYSDATE BETWEEN NVL(FLD.START_DATE_ACTIVE
       ,SYSDATE - 1)
      AND NVL(FLD.END_DATE_ACTIVE
       ,SYSDATE + 1);