APPS.PER_SG_ORG_INFO_LEG_HOOK SQL Statements

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

Line: 35

      SELECT count(org_information_id)
      FROM hr_organization_information
      WHERE org_information_context= 'SG_LEGAL_ENTITY'
        AND org_information10 = p_org_information1
       AND organization_id = p_organization_id
       AND (org_information_id  <> p_org_information_id
            OR p_org_information_id IS NULL);

Line: 45

      SELECT count(org_information_id)
      FROM hr_organization_information
      WHERE org_information_context= 'SG_MULTI_CSN'
        AND org_information1 = p_org_information1
       AND organization_id = p_organization_id
       AND (org_information_id  <> p_org_information_id
            OR p_org_information_id IS NULL);

Line: 210

      SELECT org_information3,
             org_information15
      FROM hr_organization_information
      WHERE org_information_context= 'SG_LEGAL_ENTITY'
       AND organization_id = p_organization_id;

Line: 444

PROCEDURE CHECK_SG_ORG_INFO_TYPE_UPDATE
        (p_org_info_type_code IN VARCHAR2 --Organization Information type
        ,p_org_information_id IN NUMBER   --Organization Information ID
        ,p_org_information1   IN VARCHAR2
        ,p_org_information2   IN VARCHAR2
        ,p_org_information3   IN VARCHAR2
        ,p_org_information4   IN VARCHAR2
        ,p_org_information5   IN VARCHAR2
        ,p_org_information6   IN VARCHAR2
        ,p_org_information7   IN VARCHAR2
        ,p_org_information8   IN VARCHAR2
        ,p_org_information9   IN VARCHAR2
        ,p_org_information10  IN VARCHAR2
        ,p_org_information11  IN VARCHAR2
        ,p_org_information12  IN VARCHAR2
        ,p_org_information13  IN VARCHAR2
        ,p_org_information14  IN VARCHAR2
        ,p_org_information15  IN VARCHAR2
        ,p_org_information16  IN VARCHAR2
        ,p_org_information17  IN VARCHAR2
        ,p_org_information18  IN VARCHAR2
        ,p_org_information19  IN VARCHAR2
        ,p_org_information20  IN VARCHAR2
        )
IS
      l_organization_id   NUMBER;

Line: 494

        SELECT organization_id
	      ,org_information1
	      ,org_information2
	      ,org_information3
	      ,org_information4
	      ,org_information5
	      ,org_information6
	      ,org_information7
	      ,org_information8
	      ,org_information9
	      ,org_information10
	      ,org_information11
	      ,org_information12
	      ,org_information13
	      ,org_information14
	      ,org_information15
	      ,org_information16
	      ,org_information17
	      ,org_information18
	      ,org_information19
	      ,org_information20
	FROM  hr_organization_information
	WHERE org_information_id = p_org_information_id;

Line: 520

       l_procedure := g_package || 'check_sg_org_info_type_update';

Line: 650

END CHECK_SG_ORG_INFO_TYPE_UPDATE;