[Home] [Help]
42: order by start_date desc;
43:
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
52:
53:
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
83: ELSIF NVL(x_period_type ,'X') = 'G' THEN
84:
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;
127: where start_date < x_start_period_date;
128: ELSIF NVL(x_period_type ,'X') = 'G' THEN
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;
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
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);
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
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;
234:
235:
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;
1154: l_cls_prds_exists := 'N';
1155: SELECT 'Y' into l_cls_prds_exists
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
1297: delete from pa_budget_lines
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;
1445: and sra.resource_list_member_id=dra.resource_list_member_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';
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
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;