The following lines contain the word 'select', 'insert', 'update' or 'delete':
select null
from per_time_periods a
where a.time_period_id = p_end_time_period_id;
select null
from per_time_periods a
where a.time_period_id = p_start_time_period_id;
select null
from pqh_worksheet_details a
where a.worksheet_detail_id = p_worksheet_detail_id;
select start_date
from per_time_periods a
where a.time_period_id = p_start_time_period_id;
select end_date
from per_time_periods a
where a.time_period_id = p_end_time_period_id;
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;
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';
End insert_validate;
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';
End update_validate;
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';
End delete_validate;