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 156: from gl_period_statuses p,

152: t.task_id,
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

Line 440: from gl_period_statuses p,

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

Line 448: from gl_period_statuses p,

444: and p.set_of_books_id = i.set_of_books_id;
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;

Line 568: from gl_period_statuses p,

564: bulk collect into
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'

Line 1174: from gl_period_statuses p,

1170: l_end_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

Line 1781: from gl_period_statuses p,

1777: l_period_name,
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

Line 2245: from gl_period_statuses p,

2241: l_task_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

Line 3076: from gl_period_statuses p,

3072: l_period_name,
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

Line 3552: from gl_period_statuses p,

3548: l_task_id,
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