APPS.HR_DE_ORGANIZATION_UPLOAD SQL Statements

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

Line: 9

   SELECT hr_general.decode_lookup('DE_FED_STATE', bundesland) bundesland_description
         ,bundesland
         ,tax_office_no
         ,tax_office_name
   FROM   hr_de_tax_office_definition_v
   WHERE  bundesland = NVL(p_bundesland, bundesland)
   ORDER BY hr_general.decode_lookup('DE_FED_STATE', bundesland) ASC;

Line: 22

   SELECT provider_name
         ,hr_general.decode_lookup('DE_ORG_UPLOAD_PROV_TYPES', provider_type) provider_type_description
         ,provider_type
         ,health_insurance_type
         ,LPAD(east_betriebesnumber, 8, '0') east_betriebesnumber
         ,LPAD(west_betriebesnumber, 8, '0') west_betriebesnumber
         ,pension_insurance_type
   FROM   hr_de_socins_prov_definition_v
   WHERE  provider_type = NVL(p_provider_type, provider_type)
   ORDER BY hr_general.decode_lookup('DE_ORG_UPLOAD_PROV_TYPES', provider_type);

Line: 39

   SELECT organization_id
         ,object_version_number
   FROM   hr_all_organization_units
   WHERE  business_group_id = p_business_group_id
     AND  name              = p_organization_name;

Line: 50

   SELECT org_information2 || ':' || org_information1 value
   FROM   hr_organization_information
   WHERE  organization_id = p_organization_id;

Line: 60

   SELECT o.organization_id
         ,o.name
   FROM   hr_all_organization_units   o
         ,hr_organization_information i
   WHERE  o.business_group_id       = p_business_group_id
     AND  i.organization_id         = o.organization_id
     AND  i.org_information_context = 'DE_TAX_OFFICE_INFO'
     AND  i.org_information1        = p_tax_office_no;

Line: 76

   SELECT o.organization_id
         ,o.name
   FROM   hr_all_organization_units   o
         ,hr_organization_information i
   WHERE  o.business_group_id       = p_business_group_id
     AND  i.organization_id         = o.organization_id
     AND  i.org_information_context = 'DE_SOCIAL_INSURANCE_INFO'
     AND  (i.org_information1 = p_west_betriebsnummer OR i.org_information2 = p_east_betriebsnummer);

Line: 90

   SELECT *
   FROM   per_business_groups
   WHERE  business_group_id = p_business_group_id;

Line: 928

   INSERT INTO fnd_sessions
   (session_id
   ,effective_date)
   VALUES
   (userenv('sessionid')
   ,l_effective_date);

Line: 1082

   INSERT INTO fnd_sessions
   (session_id
   ,effective_date)
   VALUES
   (userenv('sessionid')
   ,l_effective_date);