APPS.PQP_GDA_SHD SQL Statements

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

Line: 48

    select
       gap_daily_absence_id
      ,gap_absence_plan_id
      ,absence_date
      ,work_pattern_day_type
      ,level_of_entitlement
      ,level_of_pay
      ,duration
      ,duration_in_hours
      ,working_days_per_week
      ,fte -- LG
      ,object_version_number
    from        pqp_gap_daily_absences
    where       gap_daily_absence_id = p_gap_daily_absence_id;

Line: 124

    select
       gap_daily_absence_id
      ,gap_absence_plan_id
      ,absence_date
      ,work_pattern_day_type
      ,level_of_entitlement
      ,level_of_pay
      ,duration
      ,duration_in_hours
      ,working_days_per_week
      ,fte -- LG
      ,object_version_number
    from        pqp_gap_daily_absences
    where       gap_daily_absence_id = p_gap_daily_absence_id
    for update nowait;