APPS.PQH_BFS_BUS SQL Statements

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

Line: 110

    select null
    from   pqh_budget_elements a
    where  a.budget_element_id = p_budget_element_id;

Line: 169

 select 'X'
 from pqh_budget_fund_srcs
 where budget_element_id            = p_budget_element_id
   and budget_fund_src_id           <> nvl(p_budget_fund_src_id,0)
   and nvl(cost_allocation_keyflex_id,0)   = nvl(p_cost_allocation_keyflex_id,0)
   and nvl(project_id,0)                   = nvl(p_project_id,0)
   and nvl(award_id,0)                     = nvl(p_award_id,0)
   and nvl(task_id,0)                      = nvl(p_task_id,0)
   and nvl(expenditure_type,0)             = nvl(p_expenditure_type,0)
   and nvl(organization_id,0)              = nvl(p_organization_id,0)
;

Line: 232

    select null
    from   pay_cost_allocation_keyflex a
    where  a.cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;

Line: 277

Procedure insert_validate(p_rec in pqh_bfs_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 310

End insert_validate;

Line: 315

Procedure update_validate(p_rec in pqh_bfs_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 349

End update_validate;

Line: 354

Procedure delete_validate(p_rec in pqh_bfs_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 364

End delete_validate;