[Home] [Help]
2526: cursor c0 is select budget_start_date,budget_end_date
2527: from pqh_budgets bgt, pqh_worksheets wks
2528: where wks.budget_id = bgt.budget_id
2529: and wks.worksheet_id = p_worksheet_id;
2530: cursor c1 is select job_id from per_jobs
2531: where business_group_id = p_business_group_id
2532: and date_from < l_budget_end_date
2533: and (date_to > l_budget_start_date or date_to is null);
2534: l_worksheet_detail_id number;