APPS.PER_ABB_BUS SQL Statements

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

Line: 28

    select pbg.legislation_code,abb.business_group_id
      from per_business_groups_perf pbg
         , per_absence_attendance_types abb
     where abb.absence_attendance_type_id = p_absence_attendance_type_id
       and pbg.business_group_id(+) = abb.business_group_id;

Line: 133

  select 1
  from per_absence_attendances
  where absence_attendance_type_id = p_absence_attendance_type_id
  and   date_start < p_date_effective;

Line: 245

  select 1
  from pay_input_values_f piv1, per_business_groups_perf pbg
  where piv1.input_value_id = p_input_value_id
  and   pbg.business_group_id = p_business_group_id
  and   nvl(piv1.business_group_id,p_business_group_id) = p_business_group_id
  and   nvl(piv1.legislation_code,pbg.legislation_code) = pbg.legislation_code;

Line: 253

  select max(effective_end_date)
  from   pay_input_values_f
  where  input_value_id = p_input_value_id;

Line: 258

  select 1
  from pay_input_values_f piv1, per_business_groups_perf pbg
  where piv1.input_value_id = p_input_value_id
  and   p_date_effective between piv1.effective_start_date and piv1.effective_end_date
  and   exists  (select 1
                 from   pay_input_values_f piv2
                 where  piv1.input_value_id = piv2.input_value_id
                 and    nvl(l_date_end,hr_api.g_eot) between
                        piv2.effective_start_date and piv2.effective_end_date);

Line: 269

  select 1
  from pay_input_values_f piv1, per_business_groups_perf pbg
  where piv1.input_value_id = p_input_value_id
  and   piv1.uom in ('ND','H_HH','H_DECIMAL1','H_DECIMAL2','H_DECIMAL3')
  and   p_date_effective between piv1.effective_start_date and piv1.effective_end_date;

Line: 276

  select 1
  from  pay_element_types_f pet, pay_input_values_f piv
  where p_input_value_id = piv.input_value_id
  and   p_date_effective between piv.effective_start_date and piv.effective_end_date
  and   piv.element_type_id = pet.element_type_id
  and   p_date_effective between pet.effective_start_date and pet.effective_end_date
  and   (    pet.processing_type = 'N'
         or (pet.processing_type= 'R' and pet.proration_group_id is not null));

Line: 459

    select 'X'
    from   hr_lookups
    where  lookup_type = 'YES_NO'
    and    lookup_code = p_absence_overlap_flag;

Line: 752

  select 1
  from   per_absence_attendances
  where  absence_attendance_type_id = p_absence_attendance_type_id;

Line: 871

  select legislation_code
  from   per_business_groups pbg
  where  business_group_id = p_business_group_id;

Line: 876

  select 1
  from fnd_descr_flex_contexts fdfc
  where fdfc.application_id = 800
  and fdfc.descriptive_flexfield_name = 'Absence Type Developer DF'
  and fdfc.enabled_flag = 'Y'
  and fdfc.descriptive_flex_context_code = p_legislation_code;

Line: 984

procedure chk_absence_type_delete
  (p_absence_attendance_type_id   in   per_absence_attendance_types.absence_attendance_type_id%type
  ) is
  --
  l_proc   varchar2(72) := g_package || 'chk_absence_type_delete';

Line: 992

  select 1
  from   per_absence_attendances
  where  absence_attendance_type_id = p_absence_attendance_type_id;

Line: 997

  select 1
  from  per_abs_attendance_reasons
  where absence_attendance_type_id = p_absence_attendance_type_id;

Line: 1029

end chk_absence_type_delete;

Line: 1332

Procedure chk_non_updateable_args
  (p_rec in per_abb_shd.g_rec_type
  ) IS
--
  l_proc     varchar2(72) := g_package || 'chk_non_updateable_args';

Line: 1391

End chk_non_updateable_args;

Line: 1396

Procedure insert_validate
  (p_rec                          in out nocopy per_abb_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 1475

End insert_validate;

Line: 1480

Procedure update_validate
  (p_rec                          in out nocopy per_abb_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 1505

  chk_non_updateable_args
    (p_rec              => p_rec
    );

Line: 1559

End update_validate;

Line: 1564

Procedure delete_validate
  (p_rec                          in per_abb_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 1575

  per_abb_bus.chk_absence_type_delete
     (p_absence_attendance_type_id =>  p_rec.absence_attendance_type_id
      );

Line: 1580

End delete_validate;