APPS.PER_GB_ORG_INFO SQL Statements

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

Line: 16

select 1
from   hr_organization_information
where  organization_id   = p_organization_id
and    org_information_context = p_org_info_type_code
and    org_information1  = p_org_information1;

Line: 82

PROCEDURE UPDATE_GB_ORG_INFO(
         p_org_info_type_code     VARCHAR2
        ,p_org_information1       VARCHAR2
        ,p_org_information3       VARCHAR2 --Added for bug 7338614
        ,p_org_information10      VARCHAR2
        ,p_org_information_id     NUMBER
        ) is

  l_tax_district_reference varchar2(10);

Line: 95

select 1
from   hr_organization_information
where  organization_id   = (select organization_id
                            from   hr_organization_information
                            where  org_information_id = p_org_information_id)
and    org_information_context = p_org_info_type_code
and    org_information1        = p_org_information1
and    org_information_id     <> p_org_information_id;

Line: 163

END UPDATE_GB_ORG_INFO;