APPS.PE_FR_ADDITIONAL_ORG_RULES SQL Statements

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

Line: 120

  select organization_id
  from   hr_organization_information
  where  org_information_id = p_org_information_id;

Line: 130

  select null
  from   hr_organization_information
  where  org_information_context =  p_context
  and    organization_id = p_org_id
  and    org_information_id <> nvl(p_org_info_id, -1)
  and    org_information3 = p_wa_type
  and    org_information5 <> p_wa_order;

Line: 147

  select 'Y'
  from   hr_organization_information
  where  org_information_context = p_context
  and    organization_id         = p_org_id
  and    org_information_id     <> nvl(p_org_info_id, -1)
  and    p_org_info2            >= nvl(org_information1,p_sot)
  and    p_org_info1            <= nvl(org_information2,p_eot)
  and   (p_org_info3            is null or
         p_org_info3             = nvl(org_information3,'NULL_CONTEXTUAL_SEG'))
  and    rownum                  < 2;