DBA Data[Home] [Help]

APPS.PQH_WPR_BUS dependencies on PQH_BUDGETS

Line 691: l_budget_start_date pqh_budgets.budget_start_date%type;

687: l_dummy varchar2(1);
688: --
689: l_start_date per_time_periods.start_date%type;
690: l_end_date per_time_periods.end_date%type;
691: l_budget_start_date pqh_budgets.budget_start_date%type;
692: l_budget_end_date pqh_budgets.budget_end_date%type;
693: --
694: cursor c1 is
695: select start_date

Line 692: l_budget_end_date pqh_budgets.budget_end_date%type;

688: --
689: l_start_date per_time_periods.start_date%type;
690: l_end_date per_time_periods.end_date%type;
691: l_budget_start_date pqh_budgets.budget_start_date%type;
692: l_budget_end_date pqh_budgets.budget_end_date%type;
693: --
694: cursor c1 is
695: select start_date
696: from per_time_periods a

Line 707: From pqh_budgets bdt, pqh_worksheets wks , pqh_worksheet_details wdt

703: where a.time_period_id = p_end_time_period_id;
704: --
705: Cursor c3 is
706: Select bdt.BUDGET_START_DATE,bdt.BUDGET_END_DATE
707: From pqh_budgets bdt, pqh_worksheets wks , pqh_worksheet_details wdt
708: Where wdt.worksheet_detail_id = p_worksheet_detail_id
709: ANd wdt.worksheet_id = wks.worksheet_id
710: AND wks.budget_id = bdt.budget_id;
711: Begin