DBA Data[Home] [Help]

APPS.IGW_BUDGETS_PVT dependencies on PA_BUDGET_PERIODS_V

Line 340: from pa_budget_periods_v pv

336: --dbms_output.put_line('end date'||least(rec_budget_details.end_date ,l_budget_end_date) );
337: --dbms_output.put_line('l_time_phased_type_code'||l_time_phased_type_code);
338: select period_name
339: into l_period_name
340: from pa_budget_periods_v pv
341: where period_type_code = l_time_phased_type_code
342: and period_start_date >= l_budget_start_date
343: and period_end_date <= l_budget_end_date
344: and rownum < 2;

Line 437: from pa_budget_periods_v

433: if (l_time_phased_type_code IN ('G', 'P')) then
434: Begin
435: select period_name
436: into l_period_name
437: from pa_budget_periods_v
438: where period_type_code = l_time_phased_type_code
439: and period_start_date >= l_budget_start_date
440: and period_end_date <= l_budget_end_date
441: and rownum < 2;