APPS.PER_GB_ORG_INFO SQL Statements

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

Line: 19

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

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_information6       VARCHAR2 -- Added for the bug fix 13076448
		,p_org_information20      VARCHAR2
        ,p_org_information_id     NUMBER
		) is

  l_tax_district_reference varchar2(10);

Line: 138

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

END UPDATE_GB_ORG_INFO;