APPS.PAY_PATCH_STATUS_PKG SQL Statements

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

Line: 26

     select id
       into l_patch_id
       from pay_patch_status
      where patch_number = p_patch_number;

Line: 34

    select pay_patch_status_s.nextval
      into l_patch_id
      from dual;

Line: 38

    insert into pay_patch_status
               (ID,
                PATCH_NUMBER,
                PATCH_NAME,
                PHASE,
                PROCESS_TYPE,
                APPLIED_DATE,
                STATUS,
                DESCRIPTION,
                UPDATE_DATE,
                LEGISLATION_CODE,
                APPLICATION_RELEASE,
                PREREQ_PATCH_NAME
               )
    values
         (l_patch_id,
          p_patch_number,
          p_patch_name,
          p_phase,
          p_patch_type,
          sysdate,
          p_status,
          p_description,
          sysdate,
          p_legislation_code,
          p_application_release,
          p_prereq_patch_name
    );