DBA Data[Home] [Help]

APPS.PQH_WPR_BUS SQL Statements

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

Line: 110

    select null
    from   per_time_periods a
    where  a.time_period_id = p_end_time_period_id;
Line: 185

    select null
    from   per_time_periods a
    where  a.time_period_id = p_start_time_period_id;
Line: 260

    select null
    from   pqh_worksheet_details a
    where  a.worksheet_detail_id = p_worksheet_detail_id;
Line: 695

    select start_date
    from   per_time_periods a
    where  a.time_period_id = p_start_time_period_id;
Line: 701

    select end_date
    from   per_time_periods a
    where  a.time_period_id = p_end_time_period_id;
Line: 706

    Select bdt.BUDGET_START_DATE,bdt.BUDGET_END_DATE
      From pqh_budgets bdt, pqh_worksheets wks , pqh_worksheet_details wdt
     Where wdt.worksheet_detail_id = p_worksheet_detail_id
       ANd wdt.worksheet_id        = wks.worksheet_id
       AND wks.budget_id           = bdt.budget_id;
Line: 800

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

End insert_validate;
Line: 872

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

End update_validate;
Line: 944

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

End delete_validate;