APPS.HR_RO_ORG_VALIDATIONS SQL Statements

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

Line: 37

      select to_number(reverse(l_num_part)),
             to_number(reverse(l_testKey))
        into l_num_part_rev,
             l_testKey_rev
        from dual;

Line: 88

PROCEDURE UPDATE_RO_ORG_INFO(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_information6     VARCHAR2
                            ,p_org_information7     VARCHAR2
                            ,p_org_information8     VARCHAR2
                            ,p_org_information_id   NUMBER
                            ,p_effective_date       DATE
                            ) IS
   l_proc         varchar2(30) := 'UPDATE_RO_ORG_INFO';

Line: 111

END UPDATE_RO_ORG_INFO;