APPS.PER_RU_ORG_INFO SQL Statements

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

Line: 67

 PROCEDURE UPDATE_RU_ORG_INFO(
                  p_org_information_id   NUMBER
                 ,p_org_info_type_code   VARCHAR2
                 ,p_org_information1     VARCHAR2
		         ,p_org_information2     VARCHAR2
			     ,p_org_information3     VARCHAR2
			     ,p_org_information4     VARCHAR2
			     ,p_org_information5     VARCHAR2
			     ,p_org_information7     VARCHAR2
			     ,p_org_information8     VARCHAR2
			     ,p_org_information12    VARCHAR2
                            ) is
  l_org_id number;

Line: 82

	 select organization_id
	 from hr_organization_information
	 where org_information_id = p_org_information_id;

Line: 155

 END UPDATE_RU_ORG_INFO;