APPS.HR_KW_VALIDATE_PKG SQL Statements

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

Line: 27

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

Line: 32

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

Line: 150

   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: 157

   SELECT 'Y'
   FROM   per_person_types ppt
   WHERE  ppt.system_person_type IN ('CWK')
   AND    ppt.person_type_id = p_person_type_id;

Line: 803

PROCEDURE VALIDATE_UPDATE_ORG_INF(
      p_effective_date                 IN  DATE
     ,p_org_information_id             IN  NUMBER
     ,p_org_info_type_code             IN  VARCHAR2
     ,p_org_information1               IN  VARCHAR2 DEFAULT null
     ,p_org_information2               IN  VARCHAR2 DEFAULT null
     ,p_org_information3               IN  VARCHAR2 DEFAULT null
     ,p_org_information4               IN  VARCHAR2 DEFAULT null
     ,p_org_information5               IN  VARCHAR2 DEFAULT null
     ,p_org_information6               IN  VARCHAR2 DEFAULT null
     ,p_org_information7               IN  VARCHAR2 DEFAULT null
     ,p_org_information8               IN  VARCHAR2 DEFAULT null
     ,p_org_information9               IN  VARCHAR2 DEFAULT null
     ,p_org_information10              IN  VARCHAR2 DEFAULT null
 )
AS
return_value VARCHAR2(100);

Line: 899

END VALIDATE_UPDATE_ORG_INF;

Line: 915

        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: 924

	SELECT person_id
	INTO l_person_id
	FROM per_all_assignments_f
	WHERE assignment_id = p_assignment_id;

Line: 936

	SELECT Org_Information1
	INTO l_local_nationality
	FROM HR_ORGANIZATION_INFORMATION
	WHERE ORG_INFORMATION_CONTEXT = 'KW_BG_DETAILS'
	AND ORGANIZATION_ID = l_organization_id;