APPS.PER_PDS_BUS SQL Statements

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

Line: 127

     select min(asg.effective_start_date)
          , asg.assignment_id
     from   per_assignments_f asg
     where  asg.period_of_service_id = p_period_of_service_id
     group by asg.assignment_id
     order by 1 desc;

Line: 135

     select max(per.effective_start_date)
     from   per_all_people_f per
     where  per.person_id = p_person_id;

Line: 140

	select ptu.effective_start_date
	from per_person_type_usages_f ptu, per_person_types ppt
	where ptu.person_id = p_person_id
	and ptu.person_type_id = ppt.person_type_id
	and ptu.effective_start_date > p_actual_termination_date
	and ppt.system_person_type in ('EMP','CWK');

Line: 252

		if (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') then
          open not_allowed_ppt;

Line: 396

     SELECT pds2.date_start
           ,pds2.actual_termination_date
           ,pds2.last_standard_process_date
           ,pds2.final_process_date
     FROM   per_periods_of_service pds1
           ,per_periods_of_service pds2
     WHERE  pds1.period_of_service_id = p_period_of_service_id
     AND    pds1.person_id = pds2.person_id
     AND    pds1.period_of_service_id <> pds2.period_of_service_id
     AND    pds2.date_start > pds1.date_start
     ORDER BY pds2.date_start;

Line: 411

     SELECT pds2.final_process_date
     FROM   per_periods_of_service pds1
           ,per_periods_of_service pds2
     WHERE  pds1.period_of_service_id = p_period_of_service_id
     AND    pds1.person_id = pds2.person_id
     AND    pds1.period_of_service_id <> pds2.period_of_service_id
     AND    pds2.date_start > pds1.date_start;

Line: 422

     SELECT MAX(pds2.final_process_date)
     FROM   per_periods_of_service pds1
           ,per_periods_of_service pds2
     WHERE  pds1.period_of_service_id = p_period_of_service_id
     AND    pds1.person_id = pds2.person_id
     AND    pds1.period_of_service_id <> pds2.period_of_service_id
     AND    pds2.date_start < pds1.date_start;

Line: 795

    select bus.legislation_code
    from   per_business_groups bus
    where  bus.business_group_id = p_business_group_id;

Line: 1005

    select bus.legislation_code
    from   per_business_groups bus
    where  bus.business_group_id = p_business_group_id;

Line: 1384

     select null
     from   per_periods_of_service pds
     where  pds.person_id  = p_person_id
     and    pds.date_start = p_date_start;

Line: 1390

     select null
     from   per_all_people_f p,
            per_person_types pt
     where  p.person_id            = p_person_id
     and    p.effective_start_date = p_date_start
     and    pt.person_type_id      = p.person_type_id
     and    pt.system_person_type  in ('EMP', 'EMP_APL');

Line: 1616

  select null
  from  per_all_people_f per
  where per.person_id         = p_termination_accepted_person
  and   nvl(p_accepted_termination_date, p_effective_date) >=
                              (select min(per2.effective_start_date)
                               from   per_all_people_f per2
                               where  per2.person_id = per.person_id)
  and   nvl(p_accepted_termination_date, p_effective_date) <=
                              (select max(per3.effective_end_date)
                               from   per_all_people_f per3
                               where  per3.person_id = per.person_id);

Line: 1733

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

Line: 1802

end check_non_updateable_args;

Line: 2205

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

Line: 2421

End insert_validate;

Line: 2426

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

Line: 2442

  check_non_updateable_args(p_rec => p_rec);

Line: 2637

End update_validate;

Line: 2642

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

Line: 2652

End delete_validate;

Line: 2665

    select pbg.legislation_code
      from per_business_groups  pbg
         , per_periods_of_service pds
     where pds.period_of_service_id         = p_period_of_service_id
       and pbg.business_group_id = pds.business_group_id;