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_PERIODS

Line 94: from pa_periods

90: cursor pa_cursor is
91: select period_name,
92: start_date,
93: end_date
94: from pa_periods
95: where start_date between x_start_period_start_date
96: and x_end_period_end_date;
97:
98: cursor gl_cursor is

Line 127: from pa_periods p,

123: t.task_id,
124: m.resource_list_member_id,
125: m.resource_id,
126: m.track_as_labor_flag
127: from pa_periods p,
128: pa_tasks t,
129: pa_resource_list_members m
130: where m.resource_list_id = x_resource_list_id
131: and nvl(m.migration_code, 'M') = 'M'

Line 429: from pa_periods

425: if (x_time_phased_type_code = 'P') then
426:
427: select start_date
428: into x_start_period_start_date
429: from pa_periods
430: where period_name = x_start_period;
431:
432: select end_date
433: into x_end_period_end_date

Line 434: from pa_periods

430: where period_name = x_start_period;
431:
432: select end_date
433: into x_end_period_end_date
434: from pa_periods
435: where period_name = x_end_period;
436:
437: else
438: select start_date

Line 500: from pa_periods

496: bulk collect into
497: l_period_name,
498: l_start_date,
499: l_end_date
500: from pa_periods
501: where start_date between x_start_period_start_date
502: and x_end_period_end_date;
503:
504: FOR i in l_period_name.FIRST..l_period_name.LAST LOOP

Line 1078: from pa_periods p,

1074: l_end_date,
1075: l_resource_list_member_id,
1076: l_resource_id,
1077: l_track_as_labor_flag
1078: from pa_periods p,
1079: pa_resource_list_members m
1080: where m.resource_list_id = x_resource_list_id
1081: and nvl(m.migration_code, 'M') = 'M'
1082: and not exists

Line 1700: from pa_periods p,

1696: l_period_name,
1697: l_start_date,
1698: l_end_date,
1699: l_task_id
1700: from pa_periods p,
1701: pa_tasks t
1702: where t.project_id = x_project_id
1703: and t.task_id = t.top_task_id
1704: and p.start_date between x_start_period_start_date

Line 2130: from pa_periods p,

2126: l_task_id,
2127: l_resource_list_member_id,
2128: l_resource_id,
2129: l_track_as_labor_flag
2130: from pa_periods p,
2131: pa_tasks t,
2132: pa_resource_list_members m
2133: where m.resource_list_id = x_resource_list_id
2134: and nvl(m.migration_code, 'M') = 'M'

Line 2988: from pa_periods p,

2984: l_period_name,
2985: l_start_date,
2986: l_end_date,
2987: l_task_id
2988: from pa_periods p,
2989: pa_tasks t
2990: where t.project_id = x_project_id
2991: and not exists
2992: (select 1

Line 3434: from pa_periods p,

3430: l_task_id,
3431: l_resource_list_member_id,
3432: l_resource_id,
3433: l_track_as_labor_flag
3434: from pa_periods p,
3435: pa_tasks t,
3436: pa_resource_list_members m
3437: where m.resource_list_id = x_resource_list_id
3438: and nvl(m.migration_code, 'M') = 'M'

Line 4656: l_start_period_name pa_periods_all.period_name%type;

4652: and b.budget_type_code = t.budget_type_code;
4653:
4654: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%type;
4655: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%type;
4656: l_start_period_name pa_periods_all.period_name%type;
4657: l_start_period_date pa_periods_all.start_date%type;
4658: l_budget_version_id pa_budget_versions.budget_version_id%type;
4659: l_budget_amount_code pa_budget_types.budget_amount_code%type;
4660: x_err_code number;

Line 4657: l_start_period_date pa_periods_all.start_date%type;

4653:
4654: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%type;
4655: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%type;
4656: l_start_period_name pa_periods_all.period_name%type;
4657: l_start_period_date pa_periods_all.start_date%type;
4658: l_budget_version_id pa_budget_versions.budget_version_id%type;
4659: l_budget_amount_code pa_budget_types.budget_amount_code%type;
4660: x_err_code number;
4661: x_err_stage varchar2(2000);

Line 4765: l_start_period_date pa_periods_all.start_date%type;

4761: l_budget_entry_method_code pa_budget_entry_methods.time_phased_type_code%type;
4762: l_budget_version_id pa_budget_versions.budget_version_id%type;
4763:
4764:
4765: l_start_period_date pa_periods_all.start_date%type;
4766: l_end_period_date pa_periods_all.end_date%type;
4767: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE; -- Bug 8682811
4768:
4769: l_request_id number;

Line 4766: l_end_period_date pa_periods_all.end_date%type;

4762: l_budget_version_id pa_budget_versions.budget_version_id%type;
4763:
4764:
4765: l_start_period_date pa_periods_all.start_date%type;
4766: l_end_period_date pa_periods_all.end_date%type;
4767: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE; -- Bug 8682811
4768:
4769: l_request_id number;
4770: