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_PERIOD_PROCESS_PKG

Line 104: where p.application_id = pa_period_process_pkg.application_id

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
107: and p.start_date between x_start_period_start_date
108: and x_end_period_end_date;

Line 171: and p.application_id = pa_period_process_pkg.application_id

167: and not exists
168: (select 1
169: from pa_tasks t1
170: where t1.parent_task_id = t.task_id)
171: and p.application_id = pa_period_process_pkg.application_id
172: and p.set_of_books_id = i.set_of_books_id
173: and p.adjustment_period_flag = 'N'
174: and p.start_date between x_start_period_start_date
175: and x_end_period_end_date;

Line 443: and p.application_id = pa_period_process_pkg.application_id

439: into x_start_period_start_date
440: from gl_period_statuses p,
441: pa_implementations i
442: where p.period_name = x_start_period
443: and p.application_id = pa_period_process_pkg.application_id
444: and p.set_of_books_id = i.set_of_books_id;
445:
446: select end_date
447: into x_end_period_end_date

Line 451: and p.application_id = pa_period_process_pkg.application_id

447: into x_end_period_end_date
448: from gl_period_statuses p,
449: pa_implementations i
450: where p.period_name = x_end_period
451: and p.application_id = pa_period_process_pkg.application_id
452: and p.set_of_books_id = i.set_of_books_id;
453:
454: end if;
455:

Line 570: where p.application_id = pa_period_process_pkg.application_id

566: l_start_date,
567: l_end_date
568: from gl_period_statuses p,
569: pa_implementations i
570: where p.application_id = pa_period_process_pkg.application_id
571: and p.set_of_books_id = i.set_of_books_id
572: and p.adjustment_period_flag = 'N'
573: and p.start_date between x_start_period_start_date
574: and x_end_period_end_date;

Line 1182: and p.application_id = pa_period_process_pkg.application_id

1178: and not exists
1179: (select 1
1180: from pa_resource_list_members m1
1181: where m1.parent_member_id = m.resource_list_member_id)
1182: and p.application_id = pa_period_process_pkg.application_id
1183: and p.set_of_books_id = i.set_of_books_id
1184: and p.adjustment_period_flag = 'N'
1185: and p.start_date between x_start_period_start_date
1186: and x_end_period_end_date;

Line 1786: and p.application_id = pa_period_process_pkg.application_id

1782: pa_implementations i,
1783: pa_tasks t
1784: where t.project_id = x_project_id
1785: and t.task_id = t.top_task_id
1786: and p.application_id = pa_period_process_pkg.application_id
1787: and p.set_of_books_id = i.set_of_books_id
1788: and p.adjustment_period_flag = 'N'
1789: and p.start_date between x_start_period_start_date
1790: and x_end_period_end_date;

Line 2257: and p.application_id = pa_period_process_pkg.application_id

2253: where m1.parent_member_id =
2254: m.resource_list_member_id)
2255: and t.project_id = x_project_id
2256: and t.task_id = t.top_task_id
2257: and p.application_id = pa_period_process_pkg.application_id
2258: and p.set_of_books_id = i.set_of_books_id
2259: and p.adjustment_period_flag = 'N'
2260: and p.start_date between x_start_period_start_date
2261: and x_end_period_end_date; */

Line 3084: and p.application_id = pa_period_process_pkg.application_id

3080: and not exists
3081: (select 1
3082: from pa_tasks t1
3083: where t1.parent_task_id = t.task_id)
3084: and p.application_id = pa_period_process_pkg.application_id
3085: and p.set_of_books_id = i.set_of_books_id
3086: and p.adjustment_period_flag = 'N'
3087: and p.start_date between x_start_period_start_date
3088: and x_end_period_end_date;

Line 3567: and p.application_id = pa_period_process_pkg.application_id

3563: and not exists
3564: (select 1
3565: from pa_tasks t1
3566: where t1.parent_task_id = t.task_id)
3567: and p.application_id = pa_period_process_pkg.application_id
3568: and p.set_of_books_id = i.set_of_books_id
3569: and p.adjustment_period_flag = 'N'
3570: and p.start_date between x_start_period_start_date
3571: and x_end_period_end_date;