APPS.PAY_TDU_BUS SQL Statements

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

Line: 27

  (p_insert               IN boolean,
   p_time_definition_id   IN number
  ) IS
--
  cursor csr_parent_bus_leg is
  select business_group_id,
         legislation_code
  from   pay_time_definitions
  where  time_definition_id = p_time_definition_id;

Line: 54

  IF (p_insert) THEN

    hr_startup_data_api_support.chk_startup_action
      (p_generic_allowed   => TRUE
      ,p_startup_allowed   => TRUE
      ,p_user_allowed      => TRUE
      ,p_business_group_id => l_business_group_id
      ,p_legislation_code  => l_legislation_code
      ,p_legislation_subgroup => null
      );

Line: 118

  select null
  from   pay_time_definitions
  where  time_definition_id = p_time_definition_id;

Line: 201

  select hrl.meaning
  from   hr_standard_lookups hrl
  where  hrl.lookup_type = 'PAY_TIME_DEFINITION_USAGE'
  and    hrl.lookup_code = p_usage_type
  and    hrl.enabled_flag = 'Y';

Line: 208

  select nvl(definition_type,'P')
  from   pay_time_definitions
  where  time_definition_id = p_time_definition_id;

Line: 285

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

Line: 316

End insert_validate;

Line: 321

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

Line: 337

End delete_validate;