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 189: from pa_periods

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

Line 212: from pa_periods

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

Line 230: from pa_periods

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

Line 1742: from pa_periods

1738:
1739: IF NVL(x_time_phased_type_code ,'X') = 'P' THEN
1740: select start_date
1741: into x_fbp_start_date
1742: from pa_periods
1743: where period_name = x_first_budget_period;
1744: ELSIF NVL(x_time_phased_type_code ,'X') = 'G' THEN
1745: select start_date
1746: into x_fbp_start_date