APPS.GMF_AP_GET_VENDOR_CONTACTS SQL Statements

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

Line: 6

       select VENDOR_CONTACT_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
            VENDOR_SITE_ID,
            LAST_UPDATE_LOGIN,
            CREATION_DATE, CREATED_BY, INACTIVE_DATE,
            FIRST_NAME, MIDDLE_NAME, LAST_NAME, PREFIX, TITLE, MAIL_STOP,
            AREA_CODE, PHONE

            from PO_VENDOR_CONTACTS

        where VENDOR_CONTACT_ID = nvl(vndor_contact_id, VENDOR_CONTACT_ID)
          and VENDOR_SITE_ID = nvl(vndr_sit_id, VENDOR_SITE_ID)
          and  last_update_date between
               nvl(st_date, last_update_date)
          and  nvl(en_date, last_update_date);