APPS.HR_SA_VALIDATE_PKG SQL Statements

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

Line: 26

    SELECT /*+ INDEX(ppt,PER_PERSON_TYPES_PK) */ 'Y'
    FROM   per_person_types ppt
    WHERE  ppt.system_person_type IN ('CWK','EMP','APL')
    AND    ppt.person_type_Id = p_person_type_id;

Line: 31

    SELECT 'Y'
    FROM   per_person_types
    WHERE  system_person_type LIKE 'EMP%'
    AND    person_type_Id = p_person_type_id;

Line: 175

   SELECT person_type_id
   FROM   per_all_people_f
   WHERE  person_id = p_person_id
   AND    p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line: 605

	Select nationality
	From per_all_people_f ppf , fnd_sessions fnd
	Where ppf.person_id = l_person_id
	and    fnd.session_id = userenv('sessionid')
	And fnd.effective_date between ppf.effective_start_date and ppf.effective_end_date;

Line: 634

  PROCEDURE update_person_eit_validate
  (p_person_extra_info_id	    IN 	    number
  ,p_pei_information_category       IN      varchar2  default hr_api.g_varchar2
  ,p_pei_information1               IN      varchar2  default hr_api.g_varchar2
  ,p_pei_information2               IN      varchar2  default hr_api.g_varchar2
  ,p_pei_information3               IN      varchar2  default hr_api.g_varchar2
  ,p_pei_information4               IN      varchar2  default hr_api.g_varchar2
  ,p_pei_information5               IN      varchar2  default hr_api.g_varchar2
  ,p_pei_information6               IN      varchar2  default hr_api.g_varchar2
  ,p_pei_information7               IN      varchar2  default hr_api.g_varchar2
  ,p_pei_information8               IN      varchar2  default hr_api.g_varchar2
  ,p_pei_information9               IN      varchar2  default hr_api.g_varchar2
  ,p_pei_information10              IN      varchar2  default hr_api.g_varchar2
  ) is
  l_valid_date1    varchar2(10);

Line: 653

	Select person_id
	From per_people_extra_info
	Where person_extra_info_id = l_person_extra_info_id;

Line: 657

	Select nationality
	From per_all_people_f ppf , fnd_sessions fnd
	Where ppf.person_id = l_person_id
	and    fnd.session_id = userenv('sessionid')
	And fnd.effective_date between ppf.effective_start_date and ppf.effective_end_date;

Line: 686

  END update_person_eit_validate;

Line: 696

		SELECT NATIONALITY
		FROM   per_all_people_f
		WHERE  person_id = l_person_id
	AND    p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line: 705

	SELECT person_id
	INTO l_person_id
	FROM per_all_assignments_f
	WHERE assignment_id = p_assignment_id
	AND p_effective_date BETWEEN effective_start_date AND effective_end_date;