APPS.PA_BUDGET_CORE dependencies on PA_PERIODS

Line 34: from PA_periods

30: x_err_stack in out NOCOPY varchar2) --File.Sql.39 bug 4440895
31: is
32: cursor c is
33: select period_name, start_date , end_date
34: from PA_periods
35: where start_date > x_start_period_date
36: order by start_date ;
37:
38: cursor c1 is

Line 40: from PA_periods

36: order by start_date ;
37:
38: cursor c1 is
39: select period_name, start_date , end_date
40: from PA_periods
41: where start_date < x_start_period_date
42: order by start_date desc;
43:
44: cursor c2 is

Line 80: from pa_periods

76: IF NVL(x_period_type ,'X') = 'P' THEN
77:
78: select count(*)
79: into number_period
80: from pa_periods
81: where start_date > x_start_period_date;
82:
83: ELSIF NVL(x_period_type ,'X') = 'G' THEN
84:

Line 126: from pa_periods

122: IF NVL(x_period_type ,'X') = 'P' THEN
123:
124: select count(*)
125: into number_period
126: from pa_periods
127: where start_date < x_start_period_date;
128: ELSIF NVL(x_period_type ,'X') = 'G' THEN
129: select count(*)
130: into number_period

Line 190: from pa_periods

186: x_period_start_date1 date;
187: x_period_start_date2 date;
188: cursor c is
189: select count(1) -1
190: from pa_periods
191: where start_date between least(x_period_start_date1,x_period_start_date2) and greatest(x_period_start_date1,x_period_start_date2);
192:
193: cursor c1 is
194: select count(1) -1

Line 213: from pa_periods

209:
210: IF NVL(x_period_type ,'X') = 'P' THEN
211: select start_date
212: into x_period_start_date1
213: from pa_periods
214: where x_start_date1 between start_date and end_date;
215: ELSIF NVL(x_period_type ,'X') = 'G' THEN
216: select start_date
217: into x_period_start_date1

Line 231: from pa_periods

227: IF NVL(x_period_type ,'X') = 'P' THEN
228:
229: select start_date
230: into x_period_start_date2
231: from pa_periods
232: where x_start_date2 between start_date and end_date;
233:
234: ELSIF NVL(x_period_type ,'X') = 'G' THEN
235:

Line 1746: from pa_periods

1742:
1743: IF NVL(x_time_phased_type_code ,'X') = 'P' THEN
1744: select start_date
1745: into x_fbp_start_date
1746: from pa_periods
1747: where period_name = x_first_budget_period;
1748: ELSIF NVL(x_time_phased_type_code ,'X') = 'G' THEN
1749: select start_date
1750: into x_fbp_start_date