APPS.PQH_BUDGET_DATA_MIGRATION SQL Statements

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

Line: 37

 SELECT *
 FROM per_budgets
 WHERE name = NVL(p_budget_name, name)
   AND business_group_id  = p_business_group_id
   AND NVL(budget_type_code,'X') <> 'OTA_BUDGET' ;

Line: 44

 SELECT *
 FROM  per_budget_versions
 WHERE budget_id = p_budget_id;

Line: 49

 SELECT *
 FROM  per_budget_elements
 WHERE  budget_version_id = p_budget_version_id;

Line: 54

 SELECT *
 FROM  per_budget_values
 WHERE budget_element_id = p_budget_element_id;

Line: 310

SELECT MIN(start_date),  MAX(end_date)
FROM per_time_periods
WHERE time_period_id IN
                     (
                      SELECT val.time_period_id
                      FROM  per_budget_values val,
                            per_budget_elements ele,
                            per_budget_versions ver
                      WHERE val.budget_element_id = ele.budget_element_id
                        AND ele.budget_version_id = ver.budget_version_id
                        AND ver.budget_id = p_per_budgets_rec.budget_id
                      );

Line: 328

SELECT start_date, start_date
FROM pay_calendars
WHERE period_set_name = p_per_budgets_rec.period_set_name;

Line: 336

 SELECT SUM(value)
 FROM per_budget_values
 WHERE budget_element_id IN
                          ( SELECT ele.budget_element_id
                            FROM per_budget_elements ele,
                                 per_budget_versions ver
                           WHERE  ele.budget_version_id = ver.budget_version_id
                             AND  ver.budget_id = p_per_budgets_rec.budget_id
                          );

Line: 437

      pqh_process_batch_log.insert_log
      (
       p_message_type_cd    =>  'ERROR',
       p_message_text       =>  SQLERRM
      );

Line: 464

 SELECT SUM(val.value)
 FROM per_budget_values val
 WHERE budget_element_id IN
  ( SELECT DISTINCT budget_element_id
    FROM per_budget_elements
    WHERE budget_version_id = p_per_budget_ver_rec.budget_version_id);

Line: 509

      pqh_process_batch_log.insert_log
      (
       p_message_type_cd    =>  'ERROR',
       p_message_text       =>  SQLERRM
      );

Line: 538

 SELECT SUM(val.value)
 FROM per_budget_values val
 WHERE budget_element_id = p_per_budget_elmnt_rec.budget_element_id;

Line: 593

      pqh_process_batch_log.insert_log
      (
       p_message_type_cd    =>  'ERROR',
       p_message_text       =>  SQLERRM
      );

Line: 666

      pqh_process_batch_log.insert_log
      (
       p_message_type_cd    =>  'ERROR',
       p_message_text       =>  SQLERRM
      );

Line: 678

SELECT pst.shared_type_id
FROM  per_shared_types_vl pst , hr_standard_lookups lk
WHERE lk.lookup_type = pst.lookup_type
  and lk.lookup_code = pst.system_type_cd
  and lk.meaning     = pst.shared_type_name
  and lk.lookup_code = p_unit
  and lk.lookup_type = 'BUDGET_MEASUREMENT_TYPE';

Line: 736

SELECT lookup_code, meaning
FROM hr_lookups
WHERE lookup_type = 'BUDGET_MEASUREMENT_TYPE'
  AND enabled_flag = 'Y'
  AND sysdate BETWEEN NVL(start_date_active,sysdate) AND NVL(end_date_active,sysdate)
  AND lookup_code NOT IN ( SELECT system_type_cd
                           FROM per_shared_types
                           WHERE lookup_type = 'BUDGET_MEASUREMENT_TYPE' );

Line: 797

 SELECT * FROM pqh_budgets
 WHERE budget_id NOT IN ( SELECT DISTINCT budget_id
                          FROM pqh_budget_versions );

Line: 865

SELECT *
FROM pqh_budget_periods
WHERE budget_period_id = p_budget_period_id;

Line: 870

 SELECT *
 FROM  pqh_dflt_budget_sets
 WHERE dflt_budget_set_name = p_budget_set_name;

Line: 875

 SELECT *
 FROM  pqh_dflt_budget_elements
 WHERE dflt_budget_set_id = p_dflt_budget_set_id;

Line: 880

 SELECT *
 FROM  pqh_dflt_fund_srcs
 WHERE dflt_budget_element_id = p_dflt_budget_element_id;

Line: 976

SELECT *
FROM pqh_budget_periods
WHERE budget_period_id = p_budget_period_id;

Line: 981

SELECT SUM(dflt_dist_percentage)
FROM pqh_dflt_budget_elements
WHERE dflt_budget_set_id  = p_dflt_budget_sets_rec.dflt_budget_set_id;

Line: 1135

  SELECT table_route_id
  FROM pqh_table_route
  WHERE table_alias =  p_table_alias;

Line: 1216

SELECT name
FROM per_budgets
WHERE budget_id = p_budget_id;

Line: 1267

SELECT version_number
FROM per_budget_versions
WHERE budget_version_id = p_budget_version_id;

Line: 1318

 SELECT *
 FROM per_budget_elements
 WHERE budget_element_id = p_budget_element_id ;

Line: 1380

 SELECT *
 FROM per_budget_values
 WHERE budget_value_id = p_budget_value_id ;

Line: 1385

 SELECT *
 FROM per_time_periods
 WHERE time_period_id = p_time_period_id ;

Line: 1444

 SELECT COUNT(*)
 FROM per_budgets
 WHERE name = NVL(p_budget_name, name)
   AND business_group_id  = p_business_group_id
   AND NVL(budget_type_code,'X') <> 'OTA_BUDGET' ;

Line: 1451

 SELECT COUNT(*)
 FROM pqh_dflt_budget_sets
 WHERE dflt_budget_set_name = p_budget_set_name;

Line: 1510

SELECT COUNT(budget_element_id)
FROM per_budget_elements
WHERE budget_version_id IN
  ( SELECT budget_version_id
      FROM per_budget_versions
    WHERE budget_id = p_per_budgets_rec.budget_id
  );

Line: 1519

SELECT COUNT(distinct budget_element_id)
FROM per_budget_values
WHERE budget_element_id IN
 ( SELECT budget_element_id
     FROM per_budget_elements
    WHERE budget_version_id IN
        ( SELECT budget_version_id
            FROM per_budget_versions
           WHERE budget_id = p_per_budgets_rec.budget_id
         )
  );

Line: 1555

          pqh_process_batch_log.insert_log
          (
           p_message_type_cd    =>  'ERROR',
           p_message_text       =>  l_message_text_out
          );

Line: 1581

Select name,business_group_id
  From per_budgets
 Where budget_id = p_budget_id;

Line: 1586

 SELECT dflt_budget_set_name
 FROM pqh_dflt_budget_sets
 WHERE dflt_budget_set_id = p_dflt_budget_set_id;