APPS.HR_H2PI_MAP SQL Statements

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

Line: 47

  INSERT INTO hr_h2pi_id_mapping
    (to_business_group_id, from_id, to_id,  table_name)
  SELECT distinct hr_h2pi_upload.g_to_business_group_id,
         p_from_id,
         p_to_id,
         p_table_name
  FROM   hr_h2pi_id_mapping im1
  WHERE NOT EXISTS (SELECT 1
                    FROM   hr_h2pi_id_mapping im2
                    WHERE  to_business_group_id =
                                   hr_h2pi_upload.g_to_business_group_id
                    AND    from_id = p_from_id
                    AND    to_id = p_to_id
                    AND    table_name = p_table_name);

Line: 98

  SELECT to_id INTO l_to_id
    FROM hr_h2pi_id_mapping
   WHERE to_business_group_id = hr_h2pi_upload.g_to_business_group_id
     AND table_name = p_table_name
     AND from_id = p_from_id;

Line: 152

  SELECT from_id INTO l_from_id
    FROM hr_h2pi_id_mapping
   WHERE to_business_group_id = hr_h2pi_upload.g_to_business_group_id
     AND table_name = p_table_name
     AND to_id = p_to_id;