APPS.HR_DM_BUSINESS SQL Statements

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

Line: 102

  SELECT business_group_id
  FROM per_business_groups
  WHERE business_group_id = r_migration_data.business_group_id;

Line: 179

  SELECT count(*)
    FROM hr_dm_migrations
    WHERE status IN ('S', 'NS', 'E');

Line: 258

  SELECT status
    FROM hr_dm_migrations
    WHERE (migration_id = r_migration_data.migration_id);

Line: 338

  SELECT request_id
    FROM hr_dm_migration_requests
    WHERE (migration_id = r_migration_data.migration_id)
      AND (master_slave <> 'M');

Line: 494

  SELECT business_group_id
  FROM per_business_groups
  WHERE business_group_id = r_migration_data.business_group_id;

Line: 573

  SELECT business_group_created
    FROM hr_dm_migrations
    WHERE (migration_id = r_migration_data.migration_id);

Line: 578

  SELECT business_group_id
  FROM per_business_groups
  WHERE business_group_id = r_migration_data.business_group_id;

Line: 684

  SELECT count(*)
    FROM hr_dm_migrations
    WHERE status IN ('S', 'NS', 'E');

Line: 771

  SELECT status
    FROM hr_dm_migrations
    WHERE (migration_id = r_migration_data.migration_id);

Line: 845

  SELECT status
    FROM hr_dm_migrations
    WHERE (migration_id = r_migration_data.migration_id);

Line: 936

  SELECT business_group_id
    FROM hr_dm_migrations
    WHERE (migration_id = r_migration_data.migration_id)
      AND (UPPER(source_database_instance) =
                      UPPER(r_migration_data.source_database_instance))
      AND (UPPER(destination_database_instance) =
                      UPPER(r_migration_data.destination_database_instance));

Line: 945

  SELECT MAX(effective_date)
    FROM hr_dm_migrations
    WHERE (status = 'F')
      AND (business_group_id = l_business_group_id)
      AND (migration_type = 'FW')
      AND
      (
        (
          UPPER(source_database_instance) =
                      UPPER(r_migration_data.source_database_instance)
        AND
          UPPER(destination_database_instance) =
                      UPPER(r_migration_data.destination_database_instance)
        )
      OR
        (
          UPPER(source_database_instance) =
                      UPPER(r_migration_data.destination_database_instance)
        AND
          UPPER(destination_database_instance) =
                      UPPER(r_migration_data.source_database_instance)
        )
      );

Line: 970

  SELECT MAX(effective_date)
    FROM hr_dm_migrations
    WHERE (status = 'F')
      AND (business_group_id = l_business_group_id)
      AND (migration_type = l_migration_type_test)
      AND (effective_date > NVL(l_last_fw_date,
                        hr_general.start_of_time))
      AND
      (
        (
          UPPER(source_database_instance) =
                      UPPER(r_migration_data.source_database_instance)
        AND
          UPPER(destination_database_instance) =
                      UPPER(r_migration_data.destination_database_instance)
        )
      OR
        (
          UPPER(source_database_instance) =
                      UPPER(r_migration_data.destination_database_instance)
        AND
          UPPER(destination_database_instance) =
                      UPPER(r_migration_data.source_database_instance)
        )
      );

Line: 1125

  SELECT source_database_instance, destination_database_instance
    FROM hr_dm_migrations
    WHERE (migration_id = r_migration_data.migration_id);