APPS.GMS_BUDGET_CORE dependencies on PA_PERIOD_PROCESS_PKG

Line 133: and p.application_id = pa_period_process_pkg.application_id

129: select p.period_name, p.start_date, p.end_date
130: bulk collect into t_period_name, t_start_date, t_end_date
131: from gl_period_statuses p, pa_implementations i
132: where i.set_of_books_id = p.set_of_books_id
133: and p.application_id = pa_period_process_pkg.application_id
134: and p.adjustment_period_flag = 'N'
135: order by p.start_date;
136:
137: end if;

Line 283: and p.application_id = pa_period_process_pkg.application_id

279: select p.start_date
280: into x_period_start_date1
281: from gl_period_statuses p, pa_implementations i
282: where i.set_of_books_id = p.set_of_books_id
283: and p.application_id = pa_period_process_pkg.application_id
284: and p.adjustment_period_flag = 'N'
285: and x_start_date1 between p.start_date and p.end_date;
286:
287: select p.start_date

Line 291: and p.application_id = pa_period_process_pkg.application_id

287: select p.start_date
288: into x_period_start_date2
289: from gl_period_statuses p, pa_implementations i
290: where i.set_of_books_id = p.set_of_books_id
291: and p.application_id = pa_period_process_pkg.application_id
292: and p.adjustment_period_flag = 'N'
293: and x_start_date2 between p.start_date and p.end_date;
294:
295: select count(1) - 1

Line 299: and p.application_id = pa_period_process_pkg.application_id

295: select count(1) - 1
296: into x_periods
297: from gl_period_statuses p, pa_implementations i
298: where i.set_of_books_id = p.set_of_books_id
299: and p.application_id = pa_period_process_pkg.application_id
300: and p.adjustment_period_flag = 'N'
301: and p.start_date between least(x_period_start_date1,x_period_start_date2)
302: and greatest(x_period_start_date1,x_period_start_date2);
303:

Line 1212: and p.application_id = pa_period_process_pkg.application_id

1208: select start_date
1209: into x_fbp_start_date
1210: from gl_period_statuses p, pa_implementations i
1211: where i.set_of_books_id = p.set_of_books_id
1212: and p.application_id = pa_period_process_pkg.application_id
1213: and p.adjustment_period_flag = 'N'
1214: and p.period_name = x_first_budget_period;
1215:
1216: end if;

Line 2126: and p.application_id = pa_period_process_pkg.application_id

2122: select p.period_name
2123: into x_start_period_name
2124: from gl_period_statuses p, pa_implementations i
2125: where i.set_of_books_id = p.set_of_books_id
2126: and p.application_id = pa_period_process_pkg.application_id
2127: and p.adjustment_period_flag = 'N'
2128: and x_start_date between p.start_date and p.end_date;
2129:
2130: select p.period_name

Line 2134: and p.application_id = pa_period_process_pkg.application_id

2130: select p.period_name
2131: into x_end_period_name
2132: from gl_period_statuses p, pa_implementations i
2133: where i.set_of_books_id = p.set_of_books_id
2134: and p.application_id = pa_period_process_pkg.application_id
2135: and p.adjustment_period_flag = 'N'
2136: and x_end_date between p.start_date and p.end_date;
2137:
2138: END IF;