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_CORE1 dependencies on PA_PERIODS

Line 94: from pa_periods

90: cursor pa_cursor is
91: select period_name,
92: start_date,
93: end_date
94: from pa_periods
95: where start_date between x_start_period_start_date
96: and x_end_period_end_date;
97:
98: cursor gl_cursor is

Line 271: from pa_periods

267: if (x_time_phased_type_code = 'P') then
268:
269: select start_date
270: into x_start_period_start_date
271: from pa_periods
272: where period_name = x_start_period;
273:
274: select end_date
275: into x_end_period_end_date

Line 276: from pa_periods

272: where period_name = x_start_period;
273:
274: select end_date
275: into x_end_period_end_date
276: from pa_periods
277: where period_name = x_end_period;
278:
279: else
280: select start_date

Line 342: from pa_periods

338: bulk collect into
339: l_period_name,
340: l_start_date,
341: l_end_date
342: from pa_periods
343: where start_date between x_start_period_start_date
344: and x_end_period_end_date;
345:
346: FOR i in l_period_name.FIRST..l_period_name.LAST LOOP

Line 882: from pa_periods p,

878: l_end_date,
879: l_resource_list_member_id,
880: l_resource_id,
881: l_track_as_labor_flag
882: from pa_periods p,
883: pa_resource_list_members m
884: where m.resource_list_id = x_resource_list_id
885: and nvl(m.migration_code, 'M') = 'M'
886: and not exists

Line 1468: from pa_periods p,

1464: l_period_name,
1465: l_start_date,
1466: l_end_date,
1467: l_task_id
1468: from pa_periods p,
1469: pa_tasks t
1470: where t.project_id = x_project_id
1471: and t.task_id = t.top_task_id
1472: and p.start_date between x_start_period_start_date

Line 1861: from pa_periods p,

1857: l_task_id,
1858: l_resource_list_member_id,
1859: l_resource_id,
1860: l_track_as_labor_flag
1861: from pa_periods p,
1862: pa_tasks t,
1863: pa_resource_list_members m
1864: where m.resource_list_id = x_resource_list_id
1865: and nvl(m.migration_code, 'M') = 'M'

Line 2644: from pa_periods p,

2640: l_period_name,
2641: l_start_date,
2642: l_end_date,
2643: l_task_id
2644: from pa_periods p,
2645: pa_tasks t
2646: where t.project_id = x_project_id
2647: and not exists
2648: (select 1

Line 3053: from pa_periods p,

3049: l_task_id,
3050: l_resource_list_member_id,
3051: l_resource_id,
3052: l_track_as_labor_flag
3053: from pa_periods p,
3054: pa_tasks t,
3055: pa_resource_list_members m
3056: where m.resource_list_id = x_resource_list_id
3057: and nvl(m.migration_code, 'M') = 'M'

Line 4238: l_start_period_name pa_periods_all.period_name%type;

4234: and b.budget_type_code = t.budget_type_code;
4235:
4236: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%type;
4237: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%type;
4238: l_start_period_name pa_periods_all.period_name%type;
4239: l_start_period_date pa_periods_all.start_date%type;
4240: l_budget_version_id pa_budget_versions.budget_version_id%type;
4241: l_budget_amount_code pa_budget_types.budget_amount_code%type;
4242: x_err_code number;

Line 4239: l_start_period_date pa_periods_all.start_date%type;

4235:
4236: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%type;
4237: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%type;
4238: l_start_period_name pa_periods_all.period_name%type;
4239: l_start_period_date pa_periods_all.start_date%type;
4240: l_budget_version_id pa_budget_versions.budget_version_id%type;
4241: l_budget_amount_code pa_budget_types.budget_amount_code%type;
4242: x_err_code number;
4243: x_err_stage varchar2(2000);

Line 4346: l_start_period_date pa_periods_all.start_date%type;

4342: l_budget_entry_method_code pa_budget_entry_methods.time_phased_type_code%type;
4343: l_budget_version_id pa_budget_versions.budget_version_id%type;
4344:
4345:
4346: l_start_period_date pa_periods_all.start_date%type;
4347: l_end_period_date pa_periods_all.end_date%type;
4348:
4349: l_request_id number;
4350:

Line 4347: l_end_period_date pa_periods_all.end_date%type;

4343: l_budget_version_id pa_budget_versions.budget_version_id%type;
4344:
4345:
4346: l_start_period_date pa_periods_all.start_date%type;
4347: l_end_period_date pa_periods_all.end_date%type;
4348:
4349: l_request_id number;
4350:
4351: exc_wrong_period_set exception;