APPS.PQH_DFS_BUS SQL Statements

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

Line: 110

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

Line: 186

    select null
    from   pqh_dflt_budget_elements a
    where  a.dflt_budget_element_id = p_dflt_budget_element_id;

Line: 244

 select 'X'
 from pqh_dflt_fund_srcs
 where dflt_budget_element_id = p_dflt_budget_element_id
   and dflt_fund_src_id <> nvl(p_dflt_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: 305

 select SUM(NVL(dflt_dist_percentage,0))
 from pqh_dflt_fund_srcs
 where dflt_budget_element_id = p_dflt_budget_element_id;

Line: 358

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

Line: 396

End insert_validate;

Line: 401

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

Line: 441

End update_validate;

Line: 446

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

Line: 456

End delete_validate;