APPS.PQP_ERS_SHD SQL Statements

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

Line: 49

    select
       database_item_suffix
      ,legislation_code
      ,exception_report_period
      ,object_version_number
    from        pqp_exception_report_suffix
    where       database_item_suffix = p_database_item_suffix
    and   legislation_code = p_legislation_code;

Line: 123

    select
       database_item_suffix
      ,legislation_code
      ,exception_report_period
      ,object_version_number
    from        pqp_exception_report_suffix
    where       database_item_suffix = p_database_item_suffix
    and   legislation_code = p_legislation_code
    for update nowait;