eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BUDGET_CORE dependencies on GL_PERIOD_STATUSES

Line 46: from GL_PERIOD_STATUSES P, PA_IMPLEMENTATIONS I

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

Line 56: from GL_PERIOD_STATUSES P, PA_IMPLEMENTATIONS I

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

Line 87: from GL_PERIOD_STATUSES P, PA_IMPLEMENTATIONS I

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;

Line 131: from GL_PERIOD_STATUSES P, PA_IMPLEMENTATIONS I

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;

Line 195: from GL_PERIOD_STATUSES P, PA_IMPLEMENTATIONS I

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
195: from GL_PERIOD_STATUSES P, PA_IMPLEMENTATIONS I
196: where I.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
197: AND P.APPLICATION_ID = pa_period_process_pkg.application_id
198: AND P.ADJUSTMENT_PERIOD_FLAG = 'N'
199: and start_date between least(x_period_start_date1,x_period_start_date2) and greatest(x_period_start_date1,x_period_start_date2);

Line 218: from GL_PERIOD_STATUSES P, PA_IMPLEMENTATIONS I

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
218: from GL_PERIOD_STATUSES P, PA_IMPLEMENTATIONS I
219: where I.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
220: AND P.APPLICATION_ID = pa_period_process_pkg.application_id
221: AND P.ADJUSTMENT_PERIOD_FLAG = 'N'
222: AND x_start_date1 between start_date and end_date;

Line 239: from GL_PERIOD_STATUSES P, PA_IMPLEMENTATIONS I

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

Line 1161: , gl_period_statuses s

1157: begin
1158: l_cls_prds_exists := 'N';
1159: SELECT 'Y' into l_cls_prds_exists
1160: FROM pa_budget_lines l
1161: , gl_period_statuses s
1162: , pa_implementations i
1163: , pa_budget_versions v
1164: where s.application_id = pa_period_process_pkg.application_id
1165: and i.set_of_books_id = s.set_of_books_id

Line 1304: from gl_period_statuses s

1300: x_err_stage := 'About to delete budget lines in closed gl periods in dest';
1301: delete from pa_budget_lines
1302: where budget_version_id=l_dest_version_id
1303: and period_name not in (select s.period_name
1304: from gl_period_statuses s
1305: , pa_implementations i
1306: where s.application_id = pa_period_process_pkg.application_id
1307: and i.set_of_books_id = s.set_of_books_id
1308: and s.closing_status in ('C','P'));

Line 1452: from gl_period_statuses s

1448: and sra.resource_assignment_id=pbl.resource_assignment_id
1449: and sra.resource_list_member_id=dra.resource_list_member_id
1450: and sra.task_id=dra.task_id
1451: and pbl.period_name not in (select s.period_name
1452: from gl_period_statuses s
1453: , pa_implementations_all i
1454: where s.application_id = pa_period_process_pkg.application_id
1455: and i.set_of_books_id = s.set_of_books_id
1456: and s.closing_status in ('C','P'));

Line 1751: from GL_PERIOD_STATUSES P, PA_IMPLEMENTATIONS I

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
1751: from GL_PERIOD_STATUSES P, PA_IMPLEMENTATIONS I
1752: where I.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
1753: AND P.APPLICATION_ID = pa_period_process_pkg.application_id
1754: AND P.ADJUSTMENT_PERIOD_FLAG = 'N'
1755: AND period_name = x_first_budget_period;