[Home] [Help]
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
153: m.resource_list_member_id,
154: m.resource_id,
155: m.track_as_labor_flag
156: from gl_period_statuses p,
157: pa_implementations i,
158: pa_tasks t,
159: pa_resource_list_members m
160: where m.resource_list_id = x_resource_list_id
161: and not exists
359:
360: /* -- Original Logic
361:
362:
363: -- Added pa_implementations table and corr join for bug 1763100
364:
365: select m.resource_list_member_id,
366: m.track_as_labor_flag,
367: r.unit_of_measure
369: x_uncat_track_as_labor_flag,
370: x_uncat_unit_of_measure
371: from pa_resources r,
372: pa_resource_list_members m,
373: pa_implementations i,
374: pa_resource_lists l
375: where l.uncategorized_flag = 'Y'
376: and l.resource_list_id = m.resource_list_id
377: and i.business_group_id = l.business_group_id
393: x_uncat_track_as_labor_flag,
394: x_uncat_unit_of_measure
395: from pa_resources r,
396: pa_resource_list_members m,
397: pa_implementations i,
398: pa_resource_lists l
399: where l.uncategorized_flag = 'Y'
400: and l.resource_list_id = m.resource_list_id
401: and i.business_group_id = l.business_group_id
437: else
438: select start_date
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:
445:
446: select end_date
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:
565: l_period_name,
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
1171: l_resource_list_member_id,
1172: l_resource_id,
1173: l_track_as_labor_flag
1174: from gl_period_statuses p,
1175: pa_implementations i,
1176: pa_resource_list_members m
1177: where m.resource_list_id = x_resource_list_id
1178: and not exists
1179: (select 1
1778: l_start_date,
1779: l_end_date,
1780: l_task_id
1781: from gl_period_statuses p,
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
2242: l_resource_list_member_id,
2243: l_resource_id,
2244: l_track_as_labor_flag
2245: from gl_period_statuses p,
2246: pa_implementations i,
2247: pa_tasks t,
2248: pa_resource_list_members m
2249: where m.resource_list_id = x_resource_list_id
2250: and not exists
3073: l_start_date,
3074: l_end_date,
3075: l_task_id
3076: from gl_period_statuses p,
3077: pa_implementations i,
3078: pa_tasks t
3079: where t.project_id = x_project_id
3080: and not exists
3081: (select 1
3549: l_resource_list_member_id,
3550: l_resource_id,
3551: l_track_as_labor_flag
3552: from gl_period_statuses p,
3553: pa_implementations i,
3554: pa_tasks t,
3555: pa_resource_list_members m
3556: where m.resource_list_id = x_resource_list_id
3557: and not exists