APPS.PQH_BCE_BUS SQL Statements

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

Line: 110

    select null
    from   per_time_period_types a
    where  a.period_type = p_dflt_elmnt_frequency;

Line: 186

    select null
    from   pqh_budgets a
    where  a.budget_id = p_budget_id;

Line: 378

select count(*)
from pqh_bdgt_cmmtmnt_elmnts
where budget_id = p_budget_id
  and element_type_id = p_element_type_id
  and (actual_commitment_type = 'BOTH' and p_actual_commitment_type in ('BOTH','COMMITMENT','ACTUAL')
  or (actual_commitment_type = 'COMMITMENT' and p_actual_commitment_type in ('BOTH','COMMITMENT'))
  or (actual_commitment_type = 'ACTUAL' and p_actual_commitment_type in ('BOTH','ACTUAL')));

Line: 387

select count(*)
from pqh_bdgt_cmmtmnt_elmnts
where budget_id = p_budget_id
  and element_type_id = p_element_type_id
  and bdgt_cmmtmnt_elmnt_id <> p_bdgt_cmmtmnt_elmnt_id
  and (actual_commitment_type = 'BOTH' and p_actual_commitment_type in ('BOTH','COMMITMENT','ACTUAL')
  or (actual_commitment_type = 'COMMITMENT' and p_actual_commitment_type in ('BOTH','COMMITMENT'))
  or (actual_commitment_type = 'ACTUAL' and p_actual_commitment_type in ('BOTH','ACTUAL')));

Line: 557

select count(*) from pay_balance_feeds feed
where feed.balance_type_id = p_balance_type_id;

Line: 590

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

Line: 647

End insert_validate;

Line: 652

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

Line: 709

End update_validate;

Line: 714

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

Line: 725

End delete_validate;