APPS.XLE_UPGRADE_UTILS SQL Statements

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

Line: 16

 SELECT o.organization_id
 FROM hr_all_organization_units o,
      hr_organization_information o2,
      hr_organization_information o3
WHERE o.organization_id = o2.organization_id
 AND o.organization_id = o3.organization_id
 AND o3.organization_id = o2.organization_id
 AND o2.org_information_context || '' = 'CLASS'
 AND o3.org_information_context = 'Operating Unit Information'
 AND o2.org_information1 = 'OPERATING_UNIT'
 AND o2.org_information2 = 'Y'
 AND o.organization_id = p_org_id;

Line: 31

 SELECT to_number(o3.org_information3)
FROM hr_organization_information o3,
     hr_all_organization_units o,
     hr_organization_information o2
   WHERE o.organization_id = o2.organization_id
   AND o.organization_id = o3.organization_id
   AND o3.organization_id = o2.organization_id
   AND o2.org_information_context || '' = 'CLASS'
   AND o3.org_information_context = 'Operating Unit Information'
   AND o2.org_information1 = 'OPERATING_UNIT'
   AND o2.org_information2 = 'Y'
   AND o.organization_id = p_org_id;

Line: 44

 cursor acct_env_type(l_sob_id IN NUMBER) is select accounting_env_type from xle_sob_interface where set_of_books_id = l_sob_id;

Line: 46

 cursor def_legal_context(l_sob_id IN VARCHAR2) is select legal_entity_Id from xle_le_sob_interface where set_of_books_id = l_sob_id;

Line: 48

 cursor check_le(p_org_Id IN NUMBER) is select legal_entity_id from xle_le_ou_interface where organization_id = p_org_id;

Line: 51

select O3.org_information2
from
    HR_ALL_ORGANIZATION_UNITS O,
    HR_ORGANIZATION_INFORMATION O2,
    HR_ORGANIZATION_INFORMATION O3
where
    O.organization_id=p_org_id
    AND O.ORGANIZATION_ID = O2.ORGANIZATION_ID
    AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID
    AND O2.ORG_INFORMATION_CONTEXT = 'CLASS'
    AND O3.ORG_INFORMATION_CONTEXT = 'Operating Unit Information'
    AND O2.ORG_INFORMATION1 = 'OPERATING_UNIT'
    AND O2.ORG_INFORMATION2 = 'Y'
 and exists(select le.legal_entity_id from xle_le_interface le where le.legal_entity_id = O3.org_information2);

Line: 66

 cursor le_bsv(l_sob_id IN NUMBER) is select legal_entity_id from  xle_le_bsv_interface where set_of_books_id = l_sob_id and rownum = 1;