APPS.PAY_GB_PERSON_TITLE_UPDATE SQL Statements

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

Line: 20

	SELECT name
	       FROM   per_business_groups
	       WHERE  business_group_id =p_bg_id;

Line: 26

	SELECT   ppf.person_id person_id,
		 ppf.title title,
	         ppf.national_identifier national_identifier,
	         ppf.employee_number employee_number,
	         ppf.object_version_number object_version_number,
	         ppf.effective_start_date effective_start_date,
	         ppf.effective_end_date effective_end_date,
	         ppf.full_name full_name
	FROM     per_all_people_f   ppf
        WHERE    ppf.business_group_id = p_bg_id
                 and ppf.title='HU_PROF'
	order by ppf.person_id;

Line: 68

    fnd_file.put_line(FND_FILE.OUTPUT,'                                  Title '||rpad(p_title,30)||'updated for the following records');

Line: 85

 HR_PERSON_API.update_gb_person(
                                p_effective_date => v_csr_person.effective_start_date
                               ,p_datetrack_update_mode => 'CORRECTION'
                               ,p_person_id  => l_person_id
                               ,p_object_version_number => l_ovn
                               ,p_employee_number => l_emp_no
                               ,p_effective_start_date => l_eff_sdt
                               ,p_effective_end_date => l_eff_edt
                               ,p_full_name =>l_full_name
                               ,p_title => p_title
                               ,p_comment_id => l_comment_id
                               ,p_name_combination_warning  =>l_name_combination_warning
                               ,p_assign_payroll_warning => l_assign_payroll_warning
                               ,p_orig_hire_warning => l_orig_hire_warning);

Line: 107

    fnd_file.put_line(FND_FILE.OUTPUT,'--------------------------------No Person record with HU_PROF title, So no records updated---------------------------------');