APPS.PQH_BGT_BUS SQL Statements

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

Line: 113

    select null
    from   per_shared_types a
    where  a.shared_type_id = p_budget_unit3_id;

Line: 208

    select null
    from   per_shared_types a
    where  a.shared_type_id = p_budget_unit2_id;

Line: 306

    select null
    from   per_shared_types a
    where  a.shared_type_id = p_budget_unit1_id;

Line: 418

    select budget_unit1_id,budget_unit2_id,budget_unit3_id,budget_name,budget_start_date,budget_end_date
    from   pqh_budgets
    where  position_control_flag ='Y'
    and (business_group_id = p_business_group_id and business_group_id is not null)
    and budget_start_date p_budget_start_date
    and budget_id <> nvl(p_budget_id,0);

Line: 515

    select null
    from   pay_calendars a
    where  a.period_set_name = p_period_set_name;

Line: 603

SELECT *
FROM gl_budgets
WHERE budget_name = p_gl_budget_name ;

Line: 608

SELECT start_date,end_date
FROM gl_budgets_v
WHERE budget_name = p_gl_budget_name ;

Line: 613

SELECT 'X'
FROM   gl_sets_of_books a
WHERE a.set_of_books_id = nvl(p_gl_set_of_books_id,-9999);

Line: 1016

SELECT COUNT(*)
FROM per_time_periods
WHERE period_set_name = p_period_set_name
  AND start_date BETWEEN p_budget_start_date AND p_budget_end_date
  AND end_date BETWEEN p_budget_start_date AND p_budget_end_date ;

Line: 1024

SELECT MIN(start_date)
FROM  per_time_periods
WHERE period_set_name = p_period_set_name;

Line: 1030

SELECT MIN(start_date)
FROM per_time_periods tp,
     pqh_budget_periods bpr,
     pqh_budget_details bdt,
     pqh_budget_versions bvr
WHERE time_period_id = bpr.start_time_period_id
  and bpr.budget_detail_id = bdt.budget_detail_id
  AND bdt.budget_version_id = bvr.budget_version_id
  and bvr.budget_id = p_budget_id;

Line: 1042

SELECT MIN(start_date)
FROM per_time_periods tp,
     pqh_worksheet_periods bpr,
     pqh_worksheet_details bdt,
     pqh_worksheets bvr
WHERE time_period_id = bpr.start_time_period_id
  and bpr.worksheet_detail_id = bdt.worksheet_detail_id
  AND bdt.worksheet_id = bvr.worksheet_id
  AND nvl(bvr.transaction_status,'PENDING') = 'PENDING'
  and bvr.budget_id = p_budget_id;

Line: 1193

SELECT COUNT(*)
FROM per_time_periods
WHERE period_set_name = p_period_set_name
  AND start_date BETWEEN p_budget_start_date AND p_budget_end_date
  AND end_date BETWEEN p_budget_start_date AND p_budget_end_date ;

Line: 1202

SELECT MAX(end_date)
FROM per_time_periods
WHERE period_set_name = p_period_set_name;

Line: 1208

SELECT MIN(start_date)
FROM per_time_periods tp,
     pqh_budget_periods bpr,
     pqh_budget_details bdt,
     pqh_budget_versions bvr
WHERE time_period_id = bpr.start_time_period_id
  and bpr.budget_detail_id = bdt.budget_detail_id
  AND bdt.budget_version_id = bvr.budget_version_id
  and bvr.budget_id = p_budget_id;

Line: 1220

SELECT MIN(start_date)
FROM per_time_periods tp,
     pqh_worksheet_periods bpr,
     pqh_worksheet_details bdt,
     pqh_worksheets bvr
WHERE time_period_id = bpr.start_time_period_id
  and bpr.worksheet_detail_id = bdt.worksheet_detail_id
  AND bdt.worksheet_id = bvr.worksheet_id
  AND nvl(bvr.transaction_status,'PENDING') = 'PENDING'
  and bvr.budget_id = p_budget_id;

Line: 1336

 select system_type_cd
 from per_shared_types
 where shared_type_id = p_shared_type_id;

Line: 1481

 select 'X'
 from pqh_budgets
 where budget_name = p_budget_name
   and budget_id <> nvl(p_budget_id,0);

Line: 1523

  select a.system_type_cd,
         a.shared_type_name
  from   per_shared_types a
  where  a.shared_type_id = p_budget_unit1_id;

Line: 1618

  select a.system_type_cd,
         a.shared_type_name
  from   per_shared_types a
  where  a.shared_type_id = p_budget_unit2_id;

Line: 1717

  select a.system_type_cd,
         a.shared_type_name
  from   per_shared_types a
  where  a.shared_type_id = p_budget_unit3_id;

Line: 1883

    select null
    from   fnd_currencies a
    where  a.currency_code = p_currency_code;

Line: 2010

Procedure insert_validate(p_rec in pqh_bgt_shd.g_rec_type
                         ,p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 2160

End insert_validate;

Line: 2165

Procedure update_validate(p_rec in pqh_bgt_shd.g_rec_type
                         ,p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 2316

End update_validate;

Line: 2321

Procedure delete_validate(p_rec in pqh_bgt_shd.g_rec_type
                         ,p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 2332

End delete_validate;

Line: 2345

    select a.legislation_code
    from   per_business_groups a,
           pqh_budgets b
    where b.budget_id      = p_budget_id
    and   a.business_group_id = b.business_group_id;