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 GL_PERIOD_STATUSES

Line 102: from gl_period_statuses p,

98: cursor gl_cursor is
99: select p.period_name,
100: p.start_date,
101: p.end_date
102: from gl_period_statuses p,
103: pa_implementations i
104: where p.application_id = pa_period_process_pkg.application_id
105: and p.set_of_books_id = i.set_of_books_id
106: and p.adjustment_period_flag = 'N' -- Added for bug 3688017

Line 282: from gl_period_statuses p,

278:
279: else
280: select start_date
281: into x_start_period_start_date
282: from gl_period_statuses p,
283: pa_implementations i
284: where p.period_name = x_start_period
285: and p.application_id = pa_period_process_pkg.application_id
286: and p.set_of_books_id = i.set_of_books_id;

Line 290: from gl_period_statuses p,

286: and p.set_of_books_id = i.set_of_books_id;
287:
288: select end_date
289: into x_end_period_end_date
290: from gl_period_statuses p,
291: pa_implementations i
292: where p.period_name = x_end_period
293: and p.application_id = pa_period_process_pkg.application_id
294: and p.set_of_books_id = i.set_of_books_id;

Line 410: from gl_period_statuses p,

406: bulk collect into
407: l_period_name,
408: l_start_date,
409: l_end_date
410: from gl_period_statuses p,
411: pa_implementations i
412: where p.application_id = pa_period_process_pkg.application_id
413: and p.set_of_books_id = i.set_of_books_id
414: and p.adjustment_period_flag = 'N'

Line 978: from gl_period_statuses p,

974: l_end_date,
975: l_resource_list_member_id,
976: l_resource_id,
977: l_track_as_labor_flag
978: from gl_period_statuses p,
979: pa_implementations i,
980: pa_resource_list_members m
981: where m.resource_list_id = x_resource_list_id
982: and not exists

Line 1549: from gl_period_statuses p,

1545: l_period_name,
1546: l_start_date,
1547: l_end_date,
1548: l_task_id
1549: from gl_period_statuses p,
1550: pa_implementations i,
1551: pa_tasks t
1552: where t.project_id = x_project_id
1553: and t.task_id = t.top_task_id

Line 1976: from gl_period_statuses p,

1972: l_task_id,
1973: l_resource_list_member_id,
1974: l_resource_id,
1975: l_track_as_labor_flag
1976: from gl_period_statuses p,
1977: pa_implementations i,
1978: pa_tasks t,
1979: pa_resource_list_members m
1980: where m.resource_list_id = x_resource_list_id

Line 2732: from gl_period_statuses p,

2728: l_period_name,
2729: l_start_date,
2730: l_end_date,
2731: l_task_id
2732: from gl_period_statuses p,
2733: pa_implementations i,
2734: pa_tasks t
2735: where t.project_id = x_project_id
2736: and not exists

Line 3171: from gl_period_statuses p,

3167: l_task_id,
3168: l_resource_list_member_id,
3169: l_resource_id,
3170: l_track_as_labor_flag
3171: from gl_period_statuses p,
3172: pa_implementations i,
3173: pa_tasks t,
3174: pa_resource_list_members m
3175: where m.resource_list_id = x_resource_list_id