DBA Data[Home] [Help]

APPS.PQP_GDS_SHD SQL Statements

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

Line: 59

    select
       gap_duration_summary_id
      ,assignment_id
      ,gap_absence_plan_id
      ,summary_type
      ,gap_level
      ,duration_in_days
      ,duration_in_hours
      ,date_start
      ,date_end
      ,object_version_number
    from        pqp_gap_duration_summary
    where       gap_duration_summary_id = p_gap_duration_summary_id;
Line: 134

    select
       gap_duration_summary_id
      ,assignment_id
      ,gap_absence_plan_id
      ,summary_type
      ,gap_level
      ,duration_in_days
      ,duration_in_hours
      ,date_start
      ,date_end
      ,object_version_number
    from        pqp_gap_duration_summary
    where       gap_duration_summary_id = p_gap_duration_summary_id
    for update nowait;