APPS.AR_ARYVTSLD_XMLP_PKG SQL Statements

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

Line: 27

      SELECT
        GSB.NAME,
        ASP.TAX_REGISTRATION_NUMBER,
        GSB.CURRENCY_CODE
      INTO C_SOBNAME,C_TDR_VAT_NO,C_SOBCURR
      FROM
        AR_SYSTEM_PARAMETERS ASP,
        GL_SETS_OF_BOOKS GSB
      WHERE ASP.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID
        AND GSB.CHART_OF_ACCOUNTS_ID = P_CHART_OF_ACCOUNTS_ID
        AND GSB.SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID;

Line: 38

      SELECT
        LOC.ADDRESS1,
        LOC.ADDRESS2,
        LOC.CITY,
        LOC.POSTAL_CODE,
        LOC.COUNTRY
      INTO C_BRANCH,C_STREET,C_CITY,C_POSTAL_CODE,C_COUNTRY
      FROM
        HZ_CUST_ACCT_SITES ACCT_SITE,
        HZ_PARTY_SITES PARTY_SITE,
        HZ_LOCATIONS LOC
      WHERE ACCT_SITE.CUST_ACCOUNT_ID = - 1
        AND ACCT_SITE.CUST_ACCT_SITE_ID = P_REMIT_TO_ADDRESS
        AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
        AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID;

Line: 79

    SELECT
      MEANING
    INTO W_MEANING
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
      AND LOOKUP_CODE = P_LOOKUP_CODE;