APPS.PER_NL_QH_TAX SQL Statements

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

Line: 8

procedure update_nl_tax_data
(p_rec              in out nocopy per_qh_tax_query.taxrec
,p_person_id        in     per_all_people_f.person_id%type
,p_assignment_id    in     per_all_assignments_f.assignment_id%type
,p_legislation_code in     varchar2
,p_effective_date   in     date
) is
  l_proc varchar2(72) := g_package||'update_nl_tax_data';

Line: 23

         update per_all_people_f
	 set per_information1 = p_rec.tax_field1
	    ,per_information2 = p_rec.tax_field25
	    ,per_information3 = p_rec.tax_field26
	    ,per_information4 = p_rec.tax_field27
	    ,per_information5 = p_rec.tax_field23
	    ,per_information6 = p_rec.tax_field24
	    ,per_information7 = p_rec.tax_field28
	    ,per_information8 = p_rec.tax_field20
	    ,per_information10 = p_rec.tax_field29
	    ,per_information11 = p_rec.tax_field30
	    ,per_information12 = p_rec.tax_field31
	    ,first_name = p_rec.tax_field22
	    ,middle_names = p_rec.tax_field7
         where person_id = p_person_id
         and   p_effective_date between effective_start_date and effective_end_date;

Line: 40

           update per_all_people_f
	   set country_of_birth = null
           where person_id = p_person_id
           and   p_effective_date between effective_start_date and effective_end_date;

Line: 49

end update_nl_tax_data;

Line: 65

       select meaning
       into   l_lookup_meaning
       from   hr_lookups
       where  lookup_type = p_lookup_type
       and    lookup_code = p_lookup_code;

Line: 82

       select meaning
       into   l_lookup_meaning
       from   hr_lookups
       where  lookup_type = p_lookup_type
       and    lookup_code = p_lookup_code;

Line: 96

       select territory_short_name
       into   l_territory_name
       from   fnd_territories_vl
       where  territory_code = p_territory_code;

Line: 113

     select per_information1
           ,per_information2
           ,per_information3
           ,per_information4
           ,per_information5
           ,per_information6
           ,per_information7
           ,per_information8
           ,per_information10
           ,per_information11
           ,per_information12
           ,middle_names
           ,country_of_birth
           ,first_name
           ,full_name
     into   p_rec.tax_field1
           ,p_rec.tax_field25
           ,p_rec.tax_field26
           ,p_rec.tax_field27
           ,p_rec.tax_field23
           ,p_rec.tax_field24
           ,p_rec.tax_field28
           ,p_rec.tax_field20
           ,p_rec.tax_field29
           ,p_rec.tax_field30
           ,p_rec.tax_field31
           ,p_rec.tax_field7
           ,p_rec.tax_field32
           ,p_rec.tax_field22
           ,p_rec.tax_field5
     from   per_all_people_f
     where  person_id = p_person_id
     and    p_effective_date between effective_start_date and effective_end_date
     and    rownum = 1;

Line: 160

     select territory_short_name into p_rec.tax_field21
     from   fnd_territories_vl
     where  territory_code = p_rec.tax_field32;