APPS.JL_JLARPCWT_XMLP_PKG SQL Statements

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

Line: 13

    SELECT
      P.BASE_CURRENCY_CODE,
      C.PRECISION,
      C.MINIMUM_ACCOUNTABLE_UNIT,
      C.DESCRIPTION
    INTO BASE_CURR,PREC,MIN_AU,DESCR
    FROM
      AP_SYSTEM_PARAMETERS P,
      FND_CURRENCIES_VL C
    WHERE P.BASE_CURRENCY_CODE = C.CURRENCY_CODE;

Line: 51

    SELECT
      LY.MEANING,
      LN.MEANING,
      LA.DISPLAYED_FIELD
    INTO NLS_YES,NLS_NO,NLS_ALL
    FROM
      FND_LOOKUPS LY,
      FND_LOOKUPS LN,
      AP_LOOKUP_CODES LA
    WHERE LY.LOOKUP_TYPE = 'YES_NO'
      AND LY.LOOKUP_CODE = 'Y'
      AND LN.LOOKUP_TYPE = 'YES_NO'
      AND LN.LOOKUP_CODE = 'N'
      AND LA.LOOKUP_TYPE = 'NLS REPORT PARAMETER'
      AND LA.LOOKUP_CODE = 'ALL';

Line: 143

    SELECT
      NAME,
      CHART_OF_ACCOUNTS_ID
    INTO L_NAME,L_CHART_OF_ACCOUNTS_ID
    FROM
      GL_SETS_OF_BOOKS G,
      AP_SYSTEM_PARAMETERS A
    WHERE G.SET_OF_BOOKS_ID = A.SET_OF_BOOKS_ID;

Line: 224

      SELECT
        PMT.PAYMENT_AMOUNT
      FROM
        IBY_FD_PAYMENTS_V PMT
      WHERE PMT.PAPER_DOCUMENT_NUMBER = CF_PAYMENT_AMOUNTFORMULA.CHECK_NUMBER;

Line: 259

  FUNCTION UPDATE_CERTIFICATE_STATUS(V_AWT_TYPE_CODE IN VARCHAR2
                                    ,V_CERTIFICATE_NUMBER IN NUMBER) RETURN BOOLEAN IS
  PRAGMA AUTONOMOUS_TRANSACTION;

Line: 263

    UPDATE
      JL_AR_AP_AWT_CERTIF jaac
    SET
      STATUS = DECODE(STATUS
            ,'NOT PRINTED'
            ,'PRINTED'
            ,DECODE(STATUS
                  ,'PRINTED '
                  ,'REPRINTED '
                  ,'REPRINTED'))
    WHERE AWT_TYPE_CODE = NVL(V_AWT_TYPE_CODE
       ,AWT_TYPE_CODE)
      AND CERTIFICATE_NUMBER = NVL(V_CERTIFICATE_NUMBER
       ,CERTIFICATE_NUMBER);

Line: 283

                 ,'ERROR in function UPDATE_CERTIFICATE_STATUS')*/NULL;

Line: 286

  END UPDATE_CERTIFICATE_STATUS;

Line: 297

      SELECT
        JGEA_C.ID_NUMBER
      INTO L_COMPANY_NUM_AGENT_RET
      FROM
        JG_ZZ_ENTITY_ASSOC JGEA_C
      WHERE JGEA_C.PRIMARY_ID_NUMBER = COMP_PRIMARY_ID_NUMBER
        AND JGEA_C.ASSOCIATED_ENTITY_ID = COMP_TAX_AUTHORITY_ID
        AND JGEA_C.ID_TYPE = COMP_TAX_AUTHORITY_TYPE;

Line: 331

      SELECT
        JGEA_S.ID_NUMBER SUPPLIER_PROVINCE_NUMBER
      INTO L_SUPPLIER_PROVINCE_NUMBER
      FROM
        JG_ZZ_ENTITY_ASSOC JGEA_S
      WHERE JGEA_S.PRIMARY_ID_NUMBER = SUPP_PRIMARY_ID_NUMBER
        AND JGEA_S.ASSOCIATED_ENTITY_ID = SUPP_TAX_AUTHORITY_ID
        AND JGEA_S.ID_TYPE = SUPP_TAX_AUTHORITY_TYPE
        AND WITHHOLDING_DATE between JGEA_S.EFFECTIVE_DATE
        AND NVL(JGEA_S.INEFFECTIVE_DATE
         ,SYSDATE);

Line: 365

      SELECT
        JAAP.PROVINCE_NAME || ' Turnover Withholding' PROVINCE_NAME1
      INTO L_PROVINCE_NAME
      FROM
        JL_AR_AP_PROVINCES JAAP
      WHERE JAAP.PROVINCE_CODE = PROVINCE_NAMEFORMULA.PROVINCE_CODE;

Line: 404

  FUNCTION FSELECTEDSUPPLIERS RETURN VARCHAR2 IS
    NL CONSTANT VARCHAR2(1) DEFAULT ' ';

Line: 437

  END FSELECTEDSUPPLIERS;

Line: 441

    P_SELECTED_SUPPLIERS := FSELECTEDSUPPLIERS;

Line: 444

                 ,'Making Condition Where in After Form Trigger:' || P_SELECTED_SUPPLIERS)*/NULL;

Line: 466

                 ,'Before UPDATE_CERTIFICATE_STATUS')*/NULL;

Line: 468

    IF (UPDATE_CERTIFICATE_STATUS(AWT_TYPE_CODE
                             ,CERTIFICATE_NUMBER_NUM) <> TRUE) THEN
      /*SRW.MESSAGE('1'
                 ,'Error Updating Certificate Status')*/NULL;

Line: 476

                 ,'After UPDATE_CERTIFICATE_STATUS')*/NULL;

Line: 483

                 ,'Error in CF_UPDATE_CERTIFICATES')*/NULL;