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 285: and p.application_id = pa_period_process_pkg.application_id

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;
287:
288: select end_date
289: into x_end_period_end_date

Line 293: and p.application_id = pa_period_process_pkg.application_id

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;
295:
296: end if;
297:

Line 412: where p.application_id = pa_period_process_pkg.application_id

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'
415: and p.start_date between x_start_period_start_date
416: and x_end_period_end_date;

Line 986: and p.application_id = pa_period_process_pkg.application_id

982: and not exists
983: (select 1
984: from pa_resource_list_members m1
985: where m1.parent_member_id = m.resource_list_member_id)
986: and p.application_id = pa_period_process_pkg.application_id
987: and p.set_of_books_id = i.set_of_books_id
988: and p.adjustment_period_flag = 'N'
989: and p.start_date between x_start_period_start_date
990: and x_end_period_end_date;

Line 1554: and p.application_id = pa_period_process_pkg.application_id

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
1554: and p.application_id = pa_period_process_pkg.application_id
1555: and p.set_of_books_id = i.set_of_books_id
1556: and p.adjustment_period_flag = 'N'
1557: and p.start_date between x_start_period_start_date
1558: and x_end_period_end_date;

Line 1988: and p.application_id = pa_period_process_pkg.application_id

1984: where m1.parent_member_id =
1985: m.resource_list_member_id)
1986: and t.project_id = x_project_id
1987: and t.task_id = t.top_task_id
1988: and p.application_id = pa_period_process_pkg.application_id
1989: and p.set_of_books_id = i.set_of_books_id
1990: and p.adjustment_period_flag = 'N'
1991: and p.start_date between x_start_period_start_date
1992: and x_end_period_end_date;

Line 2740: and p.application_id = pa_period_process_pkg.application_id

2736: and not exists
2737: (select 1
2738: from pa_tasks t1
2739: where t1.parent_task_id = t.task_id)
2740: and p.application_id = pa_period_process_pkg.application_id
2741: and p.set_of_books_id = i.set_of_books_id
2742: and p.adjustment_period_flag = 'N'
2743: and p.start_date between x_start_period_start_date
2744: and x_end_period_end_date;

Line 3186: and p.application_id = pa_period_process_pkg.application_id

3182: and not exists
3183: (select 1
3184: from pa_tasks t1
3185: where t1.parent_task_id = t.task_id)
3186: and p.application_id = pa_period_process_pkg.application_id
3187: and p.set_of_books_id = i.set_of_books_id
3188: and p.adjustment_period_flag = 'N'
3189: and p.start_date between x_start_period_start_date
3190: and x_end_period_end_date;