APPS.AP_APXVDLBL_XMLP_PKG SQL Statements

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

Line: 6

               SELECT sort_by_alternate_field
     INTO SORT_BY_ALTERNATE
     FROM AP_SYSTEM_PARAMETERS;

Line: 26

    select territory_short_name into DEFAULT_COUNTRY_NAME
    from fnd_territories_vl
    where territory_code = DEFAULT_COUNTRY_CODE_1;

Line: 31

      select territory_short_name into DEFAULT_COUNTRY_NAME
      from fnd_territories_vl
      where territory_code = 'US';

Line: 36

    select displayed_field into ATTN_MESSAGE
    from ap_lookup_codes
    where lookup_type = 'MAIL_LABEL_ATTN_MESSAGE' and
          lookup_code = 'ATTN_MESSAGE';