DBA Data[Home] [Help]

APPS.PQH_VLE_SHD SQL Statements

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

Line: 53

    select
       validation_event_id
      ,validation_id
      ,event_type
      ,event_code
      ,start_date
      ,end_date
      ,comments
      ,object_version_number
    from        pqh_fr_validation_events
    where       validation_event_id = p_validation_event_id;
Line: 126

    select
       validation_event_id
      ,validation_id
      ,event_type
      ,event_code
      ,start_date
      ,end_date
      ,comments
      ,object_version_number
    from        pqh_fr_validation_events
    where       validation_event_id = p_validation_event_id
    for update nowait;