APPS.PER_US_ORG_INFO_LEG_HOOK SQL Statements

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

Line: 4

 PROCEDURE UPDATE_US_ORG_INFO
         (P_ORG_INFORMATION_ID          IN     NUMBER
         ,p_org_info_type_code          IN     VARCHAR2
         ,p_org_information1            IN     VARCHAR2
         ,p_org_information2            IN     VARCHAR2
        )
IS
  --
    CURSOR csr_tax_rules
    (p_organization_id              IN     NUMBER
    ,p_org_info_type_code           IN     VARCHAR2
    ,p_org_information1             IN     VARCHAR2

    )
  IS
    select 'Y'
    from hr_organization_information
        where ORG_INFORMATION_CONTEXT like p_org_info_type_code
        and ORG_INFORMATION_CONTEXT in
               ( 'State Tax Rules', 'State Tax Rules 2', 'Local Tax Rules')  --RLN 7421633
         and org_information1 = p_org_information1
         and organization_id = p_organization_id
         and org_information_id <> P_ORG_INFORMATION_ID
      ;

Line: 43

        select hoi.organization_id
        into   l_org_id
        from hr_organization_information hoi
        where P_ORG_INFORMATION_ID = hoi.org_information_id
--        and   ORG_INFORMATION_CONTEXT = p_org_info_type_code
        and rownum = 1;

Line: 75

END UPDATE_US_ORG_INFO;

Line: 79

PROCEDURE INSERT_US_ORG_INFO
         (p_organization_id             IN     NUMBER
         ,p_org_info_type_code         IN     VARCHAR2
         ,p_org_information1            IN     VARCHAR2
         ,p_org_information2            IN     VARCHAR2
        )
IS
  --
  CURSOR csr_tax_rules
    (p_organization_id              IN     NUMBER
    ,p_org_info_type_code           IN     VARCHAR2
    ,p_org_information1             IN     VARCHAR2

    )
  IS
    select 'Y'
    from hr_organization_information
        where ORG_INFORMATION_CONTEXT like p_org_info_type_code
         and org_information1 = p_org_information1
         and organization_id = p_organization_id
      ;

Line: 128

END INSERT_US_ORG_INFO;

Line: 146

    select 'Y'
    from hr_organization_information
        where ORG_INFORMATION_CONTEXT like p_org_information_context
         and org_information1 = p_org_information1
         and organization_id = p_organization_id
      ;