APPS.PER_FR_ORG_DDF_VALIDATION SQL Statements

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

Line: 16

  select 1
  from hr_organization_information
  where ORG_INFORMATION_CONTEXT = 'FR_DYN_PAYMETH_MAPPING_INFO'
  and   ORG_INFORMATION1        = p_org_information1
  and   ORGANIZATION_ID        <> p_organization_id;

Line: 23

  select 1
  from hr_organization_information
  where ORG_INFORMATION_CONTEXT = 'FR_DYN_PAYMETH_MAPPING_INFO'
  and   ORG_INFORMATION2        = p_org_information2
  and   ORGANIZATION_ID         = p_organization_id
  and   org_information_id     <> p_org_information_id;

Line: 93

   select nvl(ip.type, null)
   from hr_fr_insurance_providers_v ip
   where ip.organization_id = p_org_information3;