APPS.PER_NL_ABSENCE_TRACK_PKG SQL Statements

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

Line: 32

  SELECT  pur.row_low_range_or_name
  FROM pay_user_rows_f pur,
  pay_user_tables put
  WHERE put.user_table_id=pur.user_table_id
  and put.business_group_id = vp_business_group_id
  and put.user_table_name =vp_user_table_name
  and vp_effective_date between
           pur.effective_start_date
      and  pur.effective_end_date;

Line: 44

  SELECT '1' from PER_NL_ABSENCE_ACTIONS
  where absence_attendance_id = p_absence_attendance_id;

Line: 195

     select abs.absence_attendance_id,abs.business_group_id,
            abs.absence_attendance_type_id,atyp.absence_category,
            nvl(abs.date_start,abs.date_projected_start) start_date
       from per_absence_attendances abs,
            per_absence_attendance_types atyp
      where absence_attendance_id =p_absence_attendance_id
        and abs.absence_attendance_type_id= atyp.absence_attendance_type_id;

Line: 207

    select user_table_id,user_table_name
      from pay_user_tables utab
     where business_group_id =vp_business_group_id
       and user_table_name =vp_user_table_name;