APPS.PA_BUDGET_CORE dependencies on PA_PERIOD_PROCESS_PKG

Line 48: AND P.APPLICATION_ID = pa_period_process_pkg.application_id

44: cursor c2 is
45: select period_name, start_date , end_date
46: from GL_PERIOD_STATUSES P, PA_IMPLEMENTATIONS I
47: where I.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
48: AND P.APPLICATION_ID = pa_period_process_pkg.application_id
49: AND P.ADJUSTMENT_PERIOD_FLAG = 'N'
50: and start_date > x_start_period_date
51: order by start_date ;
52:

Line 58: AND P.APPLICATION_ID = pa_period_process_pkg.application_id

54: cursor c3 is
55: select period_name, start_date , end_date
56: from GL_PERIOD_STATUSES P, PA_IMPLEMENTATIONS I
57: where I.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
58: AND P.APPLICATION_ID = pa_period_process_pkg.application_id
59: AND P.ADJUSTMENT_PERIOD_FLAG = 'N'
60: and start_date < x_start_period_date
61: order by start_date desc;
62:

Line 89: AND P.APPLICATION_ID = pa_period_process_pkg.application_id

85: select count(*)
86: into number_period
87: from GL_PERIOD_STATUSES P, PA_IMPLEMENTATIONS I
88: where I.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
89: AND P.APPLICATION_ID = pa_period_process_pkg.application_id
90: AND P.ADJUSTMENT_PERIOD_FLAG = 'N'
91: AND start_date > x_start_period_date;
92: END IF ;
93:

Line 133: AND P.APPLICATION_ID = pa_period_process_pkg.application_id

129: select count(*)
130: into number_period
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: AND start_date < x_start_period_date;
136: END IF ;
137:

Line 196: AND P.APPLICATION_ID = pa_period_process_pkg.application_id

192: cursor c1 is
193: select count(1) -1
194: from GL_PERIOD_STATUSES P, PA_IMPLEMENTATIONS I
195: where I.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
196: AND P.APPLICATION_ID = pa_period_process_pkg.application_id
197: AND P.ADJUSTMENT_PERIOD_FLAG = 'N'
198: and start_date between least(x_period_start_date1,x_period_start_date2) and greatest(x_period_start_date1,x_period_start_date2);
199:
200:

Line 219: AND P.APPLICATION_ID = pa_period_process_pkg.application_id

215: select start_date
216: into x_period_start_date1
217: from GL_PERIOD_STATUSES P, PA_IMPLEMENTATIONS I
218: where I.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
219: AND P.APPLICATION_ID = pa_period_process_pkg.application_id
220: AND P.ADJUSTMENT_PERIOD_FLAG = 'N'
221: AND x_start_date1 between start_date and end_date;
222:
223: END IF;

Line 240: AND P.APPLICATION_ID = pa_period_process_pkg.application_id

236: select start_date
237: into x_period_start_date2
238: from GL_PERIOD_STATUSES P, PA_IMPLEMENTATIONS I
239: where I.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
240: AND P.APPLICATION_ID = pa_period_process_pkg.application_id
241: AND P.ADJUSTMENT_PERIOD_FLAG = 'N'
242: AND x_start_date2 between start_date and end_date;
243:
244: END IF;

Line 1160: where s.application_id = pa_period_process_pkg.application_id

1156: FROM pa_budget_lines l
1157: , gl_period_statuses s
1158: , pa_implementations i
1159: , pa_budget_versions v
1160: where s.application_id = pa_period_process_pkg.application_id
1161: and i.set_of_books_id = s.set_of_books_id
1162: and l.budget_version_id=v.budget_version_id
1163: and s.closing_status in ('C','P')
1164: and l.period_name = s.period_name

Line 1302: where s.application_id = pa_period_process_pkg.application_id

1298: where budget_version_id=l_dest_version_id
1299: and period_name not in (select s.period_name
1300: from gl_period_statuses s
1301: , pa_implementations i
1302: where s.application_id = pa_period_process_pkg.application_id
1303: and i.set_of_books_id = s.set_of_books_id
1304: and s.closing_status in ('C','P'));
1305: end if;
1306:

Line 1450: where s.application_id = pa_period_process_pkg.application_id

1446: and sra.task_id=dra.task_id
1447: and pbl.period_name not in (select s.period_name
1448: from gl_period_statuses s
1449: , pa_implementations_all i
1450: where s.application_id = pa_period_process_pkg.application_id
1451: and i.set_of_books_id = s.set_of_books_id
1452: and s.closing_status in ('C','P'));
1453: x_err_stage := 'About to delete unused resource assignments from dest';
1454: delete from pa_resource_assignments

Line 1749: AND P.APPLICATION_ID = pa_period_process_pkg.application_id

1745: select start_date
1746: into x_fbp_start_date
1747: from GL_PERIOD_STATUSES P, PA_IMPLEMENTATIONS I
1748: where I.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
1749: AND P.APPLICATION_ID = pa_period_process_pkg.application_id
1750: AND P.ADJUSTMENT_PERIOD_FLAG = 'N'
1751: AND period_name = x_first_budget_period;
1752: END IF ;
1753: