APPS.PER_IN_DATA_PUMP SQL Statements

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

Line: 20

   SELECT unique_key_id
     INTO   l_id
     FROM   hr_pump_batch_line_user_keys
    WHERE  user_key_value = p_user_key_value;

Line: 48

   SELECT opm.object_version_number
   INTO   l_ovn
   FROM   PAY_ORG_PAYMENT_METHODS_F opm
          ,hr_pump_batch_line_user_keys key
   WHERE  key.user_key_value = p_org_payment_method_user_key
   AND    opm.ORG_PAYMENT_METHOD_ID = key.unique_key_id
   AND    p_effective_date between
          opm.effective_start_date and opm.effective_end_date;

Line: 101

 SELECT ctk_rel.object_version_number
   INTO   l_contact_relationship_ovn
   FROM   per_contact_relationships    ctk_rel,
          hr_pump_batch_line_user_keys key
  WHERE   key.user_key_value = p_contact_rel_user_key
    AND   ctk_rel.contact_relationship_id  = key.unique_key_id;

Line: 142

   SELECT  contact_info.object_version_number
     INTO  l_ovn
     FROM  per_contact_extra_info_f contact_info,
           hr_pump_batch_line_user_keys key
    WHERE  key.user_key_value = p_contact_extra_info_user_key
      AND  contact_info.contact_extra_info_id  = key.unique_key_id
      AND  p_effective_date BETWEEN
          contact_info.effective_start_date AND contact_info.effective_end_date;

Line: 175

 SELECT  people_extra_info.object_version_number
   INTO  l_person_extra_info_ovn
   FROM  per_people_extra_info   people_extra_info,
         hr_pump_batch_line_user_keys key
  WHERE  key.user_key_value = p_person_extra_info_user_key
    AND  people_extra_info.PERSON_EXTRA_INFO_ID  = key.unique_key_id;

Line: 236

  SELECT ttl.territory_code into l_territory_code
    FROM FND_TERRITORIES_TL ttl , FND_TERRITORIES t
   WHERE ttl.TERRITORY_SHORT_NAME = p_issuing_country
     AND ttl.TERRITORY_CODE = t.TERRITORY_CODE;

Line: 316

  SELECT organization_id INTO l_organization_id
    FROM HR_ALL_ORGANIZATION_UNITS
   WHERE name = p_org_name;