APPS.PQH_WFS_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_worksheet_bdgt_elmnts a
    where  a.worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;

Line: 244

 select 'X'
 from pqh_worksheet_fund_srcs
 where worksheet_bdgt_elmnt_id    = p_worksheet_bdgt_elmnt_id
   and worksheet_fund_src_id      <> nvl(p_worksheet_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: 333

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

Line: 373

End insert_validate;

Line: 378

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

Line: 419

End update_validate;

Line: 424

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

Line: 434

End delete_validate;