APPS.PER_HRWF_SYNCH SQL Statements

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

Line: 82

           select *
           from per_all_people_f
           where person_id                   = l_person_id
           and   trunc(effective_start_date) = l_start_date
           and   trunc(effective_end_date)   = l_end_date;

Line: 91

           select *
           from per_all_assignments_f
           where assignment_id               = l_assignment_id
           and   trunc(effective_start_date) = l_start_date
           and   trunc(effective_end_date)   = l_end_date;

Line: 220

  l_update_date     varchar2(30);

Line: 221

  l_updated_by      varchar2(20);

Line: 229

  l_update varchar(1) default 'Y'; -- Bug 4597033

Line: 234

    select name
    from   wf_local_roles
    where  orig_system    = 'PER'
    and    orig_system_id = p_person_id
    and rownum = 1; -- This extra WHERE condition is added as per the request of "tpapired"

Line: 276

    if nvl(p_action,'NO_DELETE') = 'DELETE' then
      --
      hr_utility.set_location('Delete Person '||l_proc,20);

Line: 280

                  p_name          => 'DELETE',
                  p_value         => 'TRUE',
                  p_parameterlist => l_parameters);

Line: 335

         l_update := 'N'; -- Bug 4597033

Line: 411

        if l_update = 'Y' then
          wf_event.addparametertolist(
                        p_name          => 'WFSYNCH_OVERWRITE',
                        p_value         => 'TRUE',
                        p_parameterlist => l_parameters);

Line: 506

     select min(effective_start_date)
     from   per_all_assignments_f
     where  assignment_id            = l_assignment_id
     and    position_id              = l_position_id
     and    nvl(assignment_type,'Z') = 'E'
     and    nvl(primary_flag,'Z')    = 'Y';

Line: 514

     select max(nvl(date_end, hr_api.g_eot))
     from   per_all_positions
     where  position_id = l_position_id;

Line: 550

    if nvl(p_action,'NO_DELETE') = 'DELETE' then
      hr_utility.set_location('Delete Assignment  ',25);

Line: 669

    select name
    from   wf_local_roles
    where  orig_system    = 'PER'
    and    orig_system_id = p_person_id
    and rownum = 1; -- This extra WHERE condition is added as per the request of "tpapired"

Line: 732

              select party_id
                from per_all_people_f
               where person_id = p_rec.person_id;