APPS.PER_APL_BUS SQL Statements

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

Line: 18

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

Line: 60

end check_non_updateable_args;

Line: 92

procedure df_update_validate
  (p_rec in per_apl_shd.g_rec_type) is
--
  l_proc    varchar2(72) := g_package||'df_update_validate';

Line: 196

end df_update_validate;

Line: 201

Procedure insert_validate(p_rec in per_apl_shd.g_rec_type
			 ,p_effective_date in date
			 ,p_validate_df_flex in boolean default true) is -- 4689836
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 307

End insert_validate;

Line: 312

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

Line: 339

  per_apl_bus.check_non_updateable_args(p_rec => p_rec);

Line: 382

  per_apl_bus.df_update_validate(p_rec => p_rec);

Line: 385

End update_validate;

Line: 390

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

Line: 400

End delete_validate;

Line: 426

    select   per.business_group_id,
             typ.system_person_type
    from     per_all_people_f     per,
             per_person_types typ
    where    per.person_id   = p_person_id
      and    per.person_type_id = typ.person_type_id
      and    per.effective_start_date = p_date_received;

Line: 438

    select application_id
    from   per_applications
    where  person_id     = p_person_id
      and  date_received = p_date_received;

Line: 660

     select assignment_id
     from   per_assignments_f
     where  application_id = p_application_id
     and  assignment_type ='A' -- 13782503
     and  effective_start_date > p_date_end;

Line: 668

     select ppf.person_id
     from   per_people_f      ppf,
            per_applications  pa
     where  pa.application_id        = p_application_id
     and    pa.person_id             = ppf.person_id
     and    ppf.effective_start_date > p_date_end

     --bug no 5105005
          and CURRENT_APPLICANT_FLAG <> 'Y';

Line: 721

        hr_utility.set_message(801,'HR_51234_APL_INVALID_UPDATE');

Line: 745

      if csr_chk_asg_future_changes%found and (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'N')then
	--
        close csr_chk_asg_future_changes;

Line: 929

    select pbg.legislation_code
      from per_business_groups  pbg
         , per_applications     apl
     where apl.application_id    = p_application_id
       and pbg.business_group_id = apl.business_group_id;