APPS.PER_EVT_BUS SQL Statements

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

Line: 27

    select pbg.security_group_id
      from per_business_groups pbg
         , per_events evt
     where evt.event_id = p_event_id
       and pbg.business_group_id = evt.business_group_id;

Line: 87

    select pbg.legislation_code
      from per_business_groups pbg
         , per_events evt
     where evt.event_id = p_event_id
       and pbg.business_group_id = evt.business_group_id;

Line: 312

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

Line: 347

End chk_non_updateable_args;

Line: 665

    select ppf.business_group_id
    from   per_all_people_f ppf
    where  ppf.person_id = p_internal_contact_person_id
    and    p_date_start between
           ppf.effective_start_date and ppf.effective_end_date
    and   (ppf.current_employee_flag = 'Y'
     or   (ppf.current_npw_flag = 'Y' and
           nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'));

Line: 765

    select business_group_id
    from hr_all_organization_units hou
    where hou.organization_id = p_organization_run_by_id
    and p_date_start between date_from and nvl(date_to, hr_api.g_eot);

Line: 849

      select business_group_id
        from per_all_assignments_f asg
       where asg.assignment_id = v_assignment_id
       and p_date_start between effective_start_date and effective_end_date;

Line: 935

    select business_group_id
    from hr_locations_all hln
    where hln.location_id = p_location_id;

Line: 1016

  select max(per.party_id)
  from    per_all_people_f per
  where   per.person_id =
          (select asg.person_id from per_all_assignments_f asg
           where asg.assignment_id = p_rec.assignment_id
           and p_rec.date_start
           between asg.effective_start_date
           and asg.effective_end_date);

Line: 1026

  select party_id
  from hz_parties hzp
  where hzp.party_id = p_rec.party_id;

Line: 1063

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

Line: 1163

End insert_validate;

Line: 1168

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

Line: 1186

  chk_non_updateable_args
    (p_rec
    );

Line: 1257

End update_validate;

Line: 1262

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

Line: 1274

End delete_validate;