DBA Data[Home] [Help]

APPS.PAY_GB_AEI_API SQL Statements

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

Line: 48

    select legislation_code
    from per_business_groups pbg
    where pbg.business_group_id = p_business_group_id;
Line: 152

    select legislation_code
    from per_business_groups pbg
    where pbg.business_group_id = p_business_group_id;
Line: 188

  hr_assignment_extra_info_api.update_assignment_extra_info
  (p_validate                   => p_validate
  ,p_assignment_extra_info_id   => p_assignment_extra_info_id
  ,p_object_version_number      => p_object_version_number
  ,p_aei_information_category   => p_aei_information_category
  ,p_aei_information1           => p_aei_information1
  ,p_aei_information2           => p_aei_information2
  ,p_aei_information3           => p_aei_information3
  ,p_aei_information4           => p_aei_information4
  ,p_aei_information5           => p_aei_information5
  ,p_aei_information6           => p_aei_information6
  ,p_aei_information7           => P_aei_information7
  ,p_aei_information8           => P_aei_information8
  ,p_aei_information9           => P_aei_information9
  ,p_aei_information10          => P_aei_information10
  ,p_aei_information11          => P_aei_information11
  ,p_aei_information12          => P_aei_information12 -- Bug 6994632 added for Prev Tax Pay Notified
  );
Line: 237

    select legislation_code
    from per_business_groups pbg
    where pbg.business_group_id = p_business_group_id;
Line: 243

   select per_information10
   from   per_all_people_f
   where  person_id = c_person_id
   and    c_effective_date between
        effective_start_date and effective_end_date;
Line: 259

    SELECT hsck.segment1, period_of_service_id
    FROM  hr_soft_coding_keyflex hsck,
          pay_all_payrolls_f papf,
          per_all_assignments_f paaf
    WHERE hsck.soft_coding_keyflex_id = papf.soft_coding_keyflex_id
    AND papf.payroll_id = paaf.payroll_id
    AND paaf.assignment_id = c_assignment_id
    AND c_effective_date between
          papf.effective_start_date and papf.effective_end_date
    AND c_effective_date between
          paaf.effective_start_date and paaf.effective_end_date;
Line: 282

   select distinct
          a.assignment_id,
          extra.assignment_extra_info_id,
          extra.object_version_number ovn,
          extra.aei_information_category,
          extra.aei_information1,
          extra.aei_information2,
          extra.aei_information3,
          extra.aei_information4
   from   per_all_assignments_f a,
          pay_all_payrolls_f pay,
          hr_soft_coding_keyflex flex,
          per_assignment_status_types past,
          per_assignment_extra_info extra
   where  a.person_id   = c_person_id
   and    flex.segment1 = c_tax_ref
   and    pay.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
   and    a.payroll_id  = pay.payroll_id
   and    a.assignment_status_type_id = past.assignment_status_type_id
   and    past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
   and    a.period_of_service_id = c_period_of_service_id
   and    c_effective_date between
          pay.effective_start_date and pay.effective_end_date
   and    a.effective_start_date <= pay_gb_eoy_archive.get_agg_active_end(c_assignment_id, c_tax_ref, c_effective_date)
   and    a.effective_end_date   >= pay_gb_eoy_archive.get_agg_active_start(c_assignment_id, c_tax_ref, c_effective_date)
   and    extra.assignment_id(+)    = a.assignment_id
   and    extra.information_type(+) = p_information_type
   and    a.assignment_id          <> c_assignment_id
   ;
Line: 316

   select max(effective_end_date)
   from   per_all_assignments_f a,
          per_assignment_status_types past
   where  a.assignment_id = c_assignment_id
   and    a.assignment_status_type_id = past.assignment_status_type_id
   and    past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
Line: 327

   select max(effective_end_date) + 1
   from   per_all_people_f
   where  person_id = c_person_id
   and    nvl(per_information10,'N') = 'N'
   and    effective_end_date < c_effective_date;
Line: 338

   select 1
   from   per_all_assignments_f a
   where  a.assignment_id = c_assignment_id
   and    a.effective_end_date   >= c_start_date
   and    a.effective_start_date <= c_end_date;
Line: 513

               hr_assignment_extra_info_api.update_assignment_extra_info
               (p_validate                   => p_validate
               ,p_assignment_extra_info_id   => r_rec.assignment_extra_info_id
               ,p_object_version_number      => l_object_version_number
               ,p_aei_information_category   => r_rec.aei_information_category
               ,p_aei_information1           => r_rec.aei_information1
               ,p_aei_information2           => r_rec.aei_information2
               ,p_aei_information3           => p_aei_information3
               ,p_aei_information4           => r_rec.aei_information4);
Line: 640

               hr_assignment_extra_info_api.update_assignment_extra_info
               (p_validate                   => p_validate
               ,p_assignment_extra_info_id   => r_rec.assignment_extra_info_id
               ,p_object_version_number      => l_object_version_number
               ,p_aei_information_category   => r_rec.aei_information_category
               ,p_aei_information1           => r_rec.aei_information1
               ,p_aei_information2           => r_rec.aei_information2
               ,p_aei_information3           => r_rec.aei_information3
               ,p_aei_information4           => p_aei_information4);
Line: 689

    select legislation_code
    from per_business_groups pbg
    where pbg.business_group_id = p_business_group_id;
Line: 696

   select per_information10
   from   per_all_people_f
   where  person_id = c_person_id
   and    c_effective_date between
        effective_start_date and effective_end_date;
Line: 719

    select aei_information3, aei_information4, information_type
    from   per_assignment_extra_info
    where  assignment_extra_info_id = c_assignment_extra_info_id;
Line: 727

    SELECT hsck.segment1, period_of_service_id
    FROM  hr_soft_coding_keyflex hsck,
          pay_all_payrolls_f papf,
          per_all_assignments_f paaf
    WHERE hsck.soft_coding_keyflex_id = papf.soft_coding_keyflex_id
    AND papf.payroll_id = paaf.payroll_id
    AND paaf.assignment_id = c_assignment_id
    AND c_effective_date between
          papf.effective_start_date and papf.effective_end_date
    AND c_effective_date between
          paaf.effective_start_date and paaf.effective_end_date;
Line: 753

   select distinct
          a.assignment_id,
          extra.assignment_extra_info_id,
          extra.object_version_number ovn,
          extra.aei_information_category,
          extra.aei_information1,
          extra.aei_information2,
          extra.aei_information3,
          extra.aei_information4
   from   per_all_assignments_f a,
          pay_all_payrolls_f pay,
          hr_soft_coding_keyflex flex,
          per_assignment_status_types past,
          per_assignment_extra_info extra
   where  a.person_id   = c_person_id
   and    flex.segment1 = c_tax_ref
   and    pay.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
   and    a.payroll_id  = pay.payroll_id
   and    extra.assignment_id(+)      = a.assignment_id
   and    extra.information_type(+)   = c_information_type
   and    a.assignment_status_type_id = past.assignment_status_type_id
   and    past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
   and    a.period_of_service_id      = c_period_of_service_id
   and    c_effective_date between
          pay.effective_start_date and pay.effective_end_date
   and    a.effective_start_date <= pay_gb_eoy_archive.get_agg_active_end(c_assignment_id, c_tax_ref, c_effective_date)
   and    a.effective_end_date   >= pay_gb_eoy_archive.get_agg_active_start(c_assignment_id, c_tax_ref, c_effective_date)
   and    a.assignment_id        <> c_assignment_id
  ;
Line: 787

   select max(effective_end_date)
   from   per_all_assignments_f a,
          per_assignment_status_types past
   where  a.assignment_id = c_assignment_id
   and    a.assignment_status_type_id = past.assignment_status_type_id
   and    past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
Line: 798

   select max(effective_end_date) + 1
   from   per_all_people_f
   where  person_id = c_person_id
   and    nvl(per_information10,'N') = 'N'
   and    effective_end_date < c_effective_date;
Line: 809

   select 1
   from   per_all_assignments_f a
   where  a.assignment_id = c_assignment_id
   and    a.effective_end_date   >= c_start_date
   and    a.effective_start_date <= c_end_date;
Line: 875

     hr_assignment_extra_info_api.update_assignment_extra_info
     (p_validate                   => p_validate
     ,p_assignment_extra_info_id   => p_assignment_extra_info_id
     ,p_object_version_number      => p_object_version_number
     ,p_aei_information_category   => p_aei_information_category
     ,p_aei_information1           => p_aei_information1
     ,p_aei_information2           => p_aei_information2
     ,p_aei_information3           => p_aei_information3
     ,p_aei_information4           => p_aei_information4);
Line: 986

               hr_assignment_extra_info_api.update_assignment_extra_info
               (p_validate                   => p_validate
               ,p_assignment_extra_info_id   => r_rec.assignment_extra_info_id
               ,p_object_version_number      => l_object_version_number
               ,p_aei_information_category   => r_rec.aei_information_category
               ,p_aei_information1           => r_rec.aei_information1
               ,p_aei_information2           => r_rec.aei_information2
               ,p_aei_information3           => null
               ,p_aei_information4           => r_rec.aei_information4);
Line: 1111

               hr_assignment_extra_info_api.update_assignment_extra_info
               (p_validate                   => p_validate
               ,p_assignment_extra_info_id   => r_rec.assignment_extra_info_id
               ,p_object_version_number      => l_object_version_number
               ,p_aei_information_category   => r_rec.aei_information_category
               ,p_aei_information1           => r_rec.aei_information1
               ,p_aei_information2           => r_rec.aei_information2
               ,p_aei_information3           => p_aei_information3
               ,p_aei_information4           => r_rec.aei_information4);
Line: 1231

               hr_assignment_extra_info_api.update_assignment_extra_info
               (p_validate                   => p_validate
               ,p_assignment_extra_info_id   => r_rec.assignment_extra_info_id
               ,p_object_version_number      => l_object_version_number
               ,p_aei_information_category   => r_rec.aei_information_category
               ,p_aei_information1           => r_rec.aei_information1
               ,p_aei_information2           => r_rec.aei_information2
               ,p_aei_information3           => r_rec.aei_information3
               ,p_aei_information4           => null);
Line: 1356

               hr_assignment_extra_info_api.update_assignment_extra_info
               (p_validate                   => p_validate
               ,p_assignment_extra_info_id   => r_rec.assignment_extra_info_id
               ,p_object_version_number      => l_object_version_number
               ,p_aei_information_category   => r_rec.aei_information_category
               ,p_aei_information1           => r_rec.aei_information1
               ,p_aei_information2           => r_rec.aei_information2
               ,p_aei_information3           => r_rec.aei_information3
               ,p_aei_information4           => p_aei_information4);
Line: 1395

    select legislation_code
    from per_business_groups pbg
    where pbg.business_group_id = p_business_group_id;
Line: 1403

    select per_information10
    from   per_all_people_f
    where  person_id = c_person_id
    and    c_effective_date between
           effective_start_date and effective_end_date;
Line: 1422

    select aei_information3, aei_information4, information_type, assignment_id
    from   per_assignment_extra_info
    where  assignment_extra_info_id = c_assignment_extra_info_id;
Line: 1430

    SELECT hsck.segment1, period_of_service_id, person_id
    FROM   hr_soft_coding_keyflex hsck,
           pay_all_payrolls_f papf,
           per_all_assignments_f paaf
    WHERE  hsck.soft_coding_keyflex_id = papf.soft_coding_keyflex_id
    AND    papf.payroll_id = paaf.payroll_id
    AND    paaf.assignment_id = c_assignment_id
    AND    c_effective_date between
             papf.effective_start_date and papf.effective_end_date
    AND    c_effective_date between
             paaf.effective_start_date and paaf.effective_end_date;
Line: 1456

   select distinct
          a.assignment_id,
          extra.assignment_extra_info_id,
          extra.object_version_number ovn,
          extra.aei_information_category,
          extra.aei_information1,
          extra.aei_information2,
          extra.aei_information3,
          extra.aei_information4
   from   per_all_assignments_f a,
          pay_all_payrolls_f pay,
          hr_soft_coding_keyflex flex,
          per_assignment_status_types past,
          per_assignment_extra_info extra
   where  a.person_id   = c_person_id
   and    flex.segment1 = c_tax_ref
   and    pay.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
   and    a.payroll_id  = pay.payroll_id
   and    extra.assignment_id(+)      = a.assignment_id
   and    extra.information_type(+)   = c_information_type
   and    a.assignment_status_type_id = past.assignment_status_type_id
   and    past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
   and    a.period_of_service_id = c_period_of_service_id
   and    c_effective_date between
            pay.effective_start_date and pay.effective_end_date
   and    a.effective_start_date <= pay_gb_eoy_archive.get_agg_active_end(c_assignment_id, c_tax_ref, c_effective_date)
   and    a.effective_end_date   >= pay_gb_eoy_archive.get_agg_active_start(c_assignment_id, c_tax_ref, c_effective_date)
   and    a.assignment_id        <> c_assignment_id
  ;
Line: 1489

   select max(effective_end_date)
   from   per_all_assignments_f a,
          per_assignment_status_types past
   where  a.assignment_id = c_assignment_id
   and    a.assignment_status_type_id = past.assignment_status_type_id
   and    past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
Line: 1500

   select max(effective_end_date) + 1
   from   per_all_people_f
   where  person_id = c_person_id
   and    nvl(per_information10,'N') = 'N'
   and    effective_end_date < c_effective_date;
Line: 1511

   select 1
   from   per_all_assignments_f a
   where  a.assignment_id = c_assignment_id
   and    a.effective_end_date   >= c_start_date
   and    a.effective_start_date <= c_end_date;
Line: 1568

  hr_assignment_extra_info_api.delete_assignment_extra_info
     (p_validate                 => false,
      p_assignment_extra_info_id => p_assignment_extra_info_id,
      p_object_version_number    => p_object_version_number);
Line: 1677

               hr_assignment_extra_info_api.update_assignment_extra_info
               (p_validate                   => p_validate
               ,p_assignment_extra_info_id   => r_rec.assignment_extra_info_id
               ,p_object_version_number      => l_object_version_number
               ,p_aei_information_category   => r_rec.aei_information_category
               ,p_aei_information1           => r_rec.aei_information1
               ,p_aei_information2           => r_rec.aei_information2
               ,p_aei_information3           => null
               ,p_aei_information4           => r_rec.aei_information4);
Line: 1794

               hr_assignment_extra_info_api.update_assignment_extra_info
               (p_validate                   => p_validate
               ,p_assignment_extra_info_id   => r_rec.assignment_extra_info_id
               ,p_object_version_number      => l_object_version_number
               ,p_aei_information_category   => r_rec.aei_information_category
               ,p_aei_information1           => r_rec.aei_information1
               ,p_aei_information2           => r_rec.aei_information2
               ,p_aei_information3           => r_rec.aei_information3
               ,p_aei_information4           => null);
Line: 1842

    select legislation_code
    from per_business_groups pbg
    where pbg.business_group_id = p_business_group_id;
Line: 1926

    select legislation_code
    from per_business_groups pbg
    where pbg.business_group_id = p_business_group_id;
Line: 1961

  hr_assignment_extra_info_api.update_assignment_extra_info
  (p_validate                   => p_validate
  ,p_assignment_extra_info_id   => p_assignment_extra_info_id
  ,p_object_version_number      => p_object_version_number
  ,p_aei_information_category   => p_aei_information_category
  ,p_aei_information1           => p_aei_information1
  ,p_aei_information2           => p_aei_information2
  ,p_aei_information3           => p_aei_information3
  ,p_aei_information4           => p_aei_information4
  ,p_aei_information5           => p_aei_information5
  ,p_aei_information6           => p_aei_information6
  );
Line: 2010

    select legislation_code
    from per_business_groups pbg
    where pbg.business_group_id = p_business_group_id;
Line: 2107

    select legislation_code
    from per_business_groups pbg
    where pbg.business_group_id = p_business_group_id;
Line: 2146

  hr_assignment_extra_info_api.update_assignment_extra_info
  (p_validate                   => p_validate
  ,p_assignment_extra_info_id   => p_assignment_extra_info_id
  ,p_object_version_number      => p_object_version_number
,p_aei_information_category => p_aei_information_category
,p_aei_information1         => p_aei_information1
,p_aei_information2         => p_aei_information2
,p_aei_information3         => p_aei_information3
,p_aei_information4         => p_aei_information4
,p_aei_information5         => p_aei_information5
,p_aei_information6         => p_aei_information6
,p_aei_information7         => p_aei_information7
,p_aei_information8         => p_aei_information8
,p_aei_information9         => p_aei_information9
,p_aei_information10        => p_aei_information10
,p_aei_information11        => p_aei_information11);