APPS.HR_AHC_BUS SQL Statements

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

Line: 15

Procedure chk_non_updateable_args
  (p_rec            in hr_ahc_shd.g_rec_type
  ,p_effective_date in date
  ) is
--
  l_proc     varchar2(72) := g_package||'chk_non_updateable_args';

Line: 82

end chk_non_updateable_args;

Line: 119

    select api_hook_id
    from hr_api_hooks
    where api_hook_id = p_api_hook_id;

Line: 247

    select territory_code
    from fnd_territories ft
    where ft.territory_code = p_legislation_code;

Line: 605

   select api_hook_call_id from hr_api_hook_calls
   where api_hook_id = p_api_hook_id
   and   nvl(legislation_code,'X')
       = nvl(p_legislation_code,'X')
   and   nvl(application_id, -987123654)
       = nvl(p_application_id,-987123654)
   and   nvl(call_package, 'X')
       = nvl(p_call_package, 'X')
   and   nvl(call_procedure, 'X')
       = nvl(p_call_procedure, 'X');

Line: 966

  SELECT 'Y'
    FROM fnd_application app
   WHERE app.application_id = p_application_id;

Line: 1054

Procedure insert_validate(p_rec in hr_ahc_shd.g_rec_type,
                          p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 1176

End insert_validate;

Line: 1181

Procedure update_validate(p_rec in hr_ahc_shd.g_rec_type,
                          p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 1198

  chk_non_updateable_args
   (p_effective_date  => p_effective_date
   ,p_rec             => p_rec);

Line: 1288

End update_validate;

Line: 1293

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

Line: 1303

End delete_validate;