APPS.PER_HU_ORG_INFO SQL Statements

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

Line: 27

PROCEDURE UPDATE_HU_ORG_INFO(p_org_information_id   NUMBER
                            ,p_org_info_type_code   VARCHAR2
                            ,p_org_information3     VARCHAR2
                            ,p_org_information4     VARCHAR2
                            ,p_org_information5     VARCHAR2
                            ) is

CURSOR get_information4 (p_org_information_id NUMBER) is
    SELECT org_information4 from hr_organization_information
    where ORG_INFORMATION_CONTEXT='HU_COMPANY_INFORMATION_DETAILS'
    and org_information_id= p_org_information_id;

Line: 40

    SELECT org_information5 from hr_organization_information
    where ORG_INFORMATION_CONTEXT='HU_COMPANY_INFORMATION_DETAILS'
    and org_information_id= p_org_information_id;

Line: 82

END UPDATE_HU_ORG_INFO;