APPS.PA_BUDGET_CORE1 dependencies on PA_IMPLEMENTATIONS

Line 103: pa_implementations i

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

Line 205: -- Added pa_implementations table and corr join for bug 1763100

201:
202: /* -- Original Logic
203:
204:
205: -- Added pa_implementations table and corr join for bug 1763100
206:
207: select m.resource_list_member_id,
208: m.track_as_labor_flag,
209: r.unit_of_measure

Line 215: pa_implementations i,

211: x_uncat_track_as_labor_flag,
212: x_uncat_unit_of_measure
213: from pa_resources r,
214: pa_resource_list_members m,
215: pa_implementations i,
216: pa_resource_lists l
217: where l.uncategorized_flag = 'Y'
218: and l.resource_list_id = m.resource_list_id
219: and i.business_group_id = l.business_group_id

Line 239: pa_implementations i,

235: x_uncat_track_as_labor_flag,
236: x_uncat_unit_of_measure
237: from pa_resources r,
238: pa_resource_list_members m,
239: pa_implementations i,
240: pa_resource_lists l
241: where l.uncategorized_flag = 'Y'
242: and l.resource_list_id = m.resource_list_id
243: and i.business_group_id = l.business_group_id

Line 283: pa_implementations i

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;
287:

Line 291: pa_implementations i

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;
295:

Line 411: pa_implementations i

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

Line 979: pa_implementations i,

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
983: (select 1

Line 1550: pa_implementations i,

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

Line 1977: pa_implementations i,

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
1981: and not exists

Line 2733: pa_implementations i,

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
2737: (select 1

Line 3172: pa_implementations i,

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
3176: and not exists