APPS.PQH_WDT_BUS SQL Statements

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

Line: 110

    select null
    from   pqh_worksheet_details a
    where  a.worksheet_detail_id = p_parent_worksheet_detail_id;

Line: 186

    select null
    from   pqh_worksheets a
    where  a.worksheet_id = p_worksheet_id;

Line: 264

    select null
    from   per_grades a
    where  a.grade_id = p_grade_id;

Line: 269

    select budgeted_entity_cd
      From pqh_budgets bdt,pqh_worksheets wks
     Where wks.worksheet_id = p_worksheet_id
       ANd bdt.budget_id    = wks.budget_id;

Line: 372

    select null
    from   per_jobs a
    where  a.job_id = p_job_id;

Line: 448

    select null
    from   pqh_position_transactions a
    where  a.position_transaction_id = p_position_transaction_id;

Line: 524

    select null
    from   pqh_budget_details a
    where  a.budget_detail_id = p_budget_detail_id;

Line: 604

    select null
    from   hr_all_organization_units a
    where  a.organization_id = p_organization_id;

Line: 609

   Select start_organization_id,org_structure_version_id
    From pqh_worksheets wfs , pqh_budgets bdt
   Where wfs.worksheet_id = p_worksheet_id
     AND wfs.budget_id = bdt.budget_id;

Line: 616

   Select null from dual
   Where p_organization_id in
         (Select ORGANIZATION_ID_CHILD
            from per_org_structure_elements
           where org_structure_version_id = l_org_structure_version_id);

Line: 1199

    select null
    from   hr_all_positions_f a
    where  a.position_id = p_position_id;

Line: 1251

    select null
    from   fnd_user a
    where  a.user_id = p_user_id;

Line: 1468

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

Line: 1583

End insert_validate;

Line: 1588

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

Line: 1705

End update_validate;

Line: 1710

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

Line: 1721

End delete_validate;