APPS.AP_APXVDRAL_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: 60

    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: 102

      SELECT
        SUBSTR(L.ADDRESS_LINE_1
              ,1
              ,35),
        SUBSTR(L.ADDRESS_LINE_2
              ,1
              ,35),
        SUBSTR(L.ADDRESS_LINE_3
              ,1
              ,35),
        SUBSTR(L.TOWN_OR_CITY
              ,1
              ,30),
        SUBSTR(NVL(L.REGION_3
                  ,L.REGION_2)
              ,1
              ,30),
        SUBSTR(L.POSTAL_CODE
              ,1
              ,20)
      INTO FROM_ADDRESS_LINE1,FROM_ADDRESS_LINE2,FROM_ADDRESS_LINE3,FROM_CITY,FROM_STATE,FROM_ZIP
      FROM
        HR_LOCATIONS L
      WHERE L.LOCATION_CODE = P_LOCATION_CODE;

Line: 194

    SELECT
      NAME,
      CHART_OF_ACCOUNTS_ID
    INTO L_NAME,L_CHART_OF_ACCOUNTS_ID
    FROM
      GL_SETS_OF_BOOKS
    WHERE SET_OF_BOOKS_ID = L_SOB_ID;

Line: 204

    SELECT
      TO_CHAR(SYSDATE
             ,'fmMonth DD, YYYY')
    INTO L_CURDATE
    FROM
      DUAL;