APPS.GMS_BUDGET_CORE dependencies on PA_PERIODS

Line 124: from pa_periods p

120: if x_period_type = 'P' then
121:
122: select p.period_name, p.start_date, p.end_date
123: bulk collect into t_period_name, t_start_date, t_end_date
124: from pa_periods p
125: order by p.start_date;
126:
127: elsif x_period_type = 'G' then
128:

Line 263: from pa_periods

259: if x_period_type = 'P' then
260:
261: select start_date
262: into x_period_start_date1
263: from pa_periods
264: where x_start_date1 between start_date and end_date;
265:
266: select start_date
267: into x_period_start_date2

Line 268: from pa_periods

264: where x_start_date1 between start_date and end_date;
265:
266: select start_date
267: into x_period_start_date2
268: from pa_periods
269: where x_start_date2 between start_date and end_date;
270:
271: select count(1) - 1
272: into x_periods

Line 273: from pa_periods

269: where x_start_date2 between start_date and end_date;
270:
271: select count(1) - 1
272: into x_periods
273: from pa_periods
274: where start_date between least(x_period_start_date1, x_period_start_date2)
275: and greatest(x_period_start_date1, x_period_start_date2);
276:
277: elsif x_period_type = 'G' then

Line 1203: from pa_periods

1199: if x_time_phased_type_code = 'P' then
1200:
1201: select start_date
1202: into x_fbp_start_date
1203: from pa_periods
1204: where period_name = x_first_budget_period;
1205:
1206: elsif x_time_phased_type_code = 'G' then
1207:

Line 2112: from pa_periods

2108: IF x_time_phase_type_code = 'P' THEN
2109:
2110: select period_name
2111: into x_start_period_name
2112: from pa_periods
2113: where x_start_date between start_date and end_date;
2114:
2115: select period_name
2116: into x_end_period_name

Line 2117: from pa_periods

2113: where x_start_date between start_date and end_date;
2114:
2115: select period_name
2116: into x_end_period_name
2117: from pa_periods
2118: where x_end_date between start_date and end_date;
2119:
2120: ELSIF x_time_phase_type_code = 'G' THEN
2121:

Line 2208: from pa_periods

2204: cursor pa_cursor is
2205: select period_name,
2206: start_date,
2207: end_date
2208: from pa_periods
2209: where start_date between x_start_period_start_date
2210: and x_end_period_end_date;
2211:
2212: cursor gl_cursor is

Line 2329: from pa_periods

2325: if (x_time_phased_type_code = 'P') then
2326:
2327: select start_date
2328: into x_start_period_start_date
2329: from pa_periods
2330: where period_name = x_start_period;
2331:
2332: select end_date
2333: into x_end_period_end_date

Line 2334: from pa_periods

2330: where period_name = x_start_period;
2331:
2332: select end_date
2333: into x_end_period_end_date
2334: from pa_periods
2335: where period_name = x_end_period;
2336:
2337: else
2338: select start_date

Line 2966: FROM gms_balances gmsb, pa_periods pp

2962: ) IS
2963: CURSOR seltxnaccums_p (x_prd_start_date IN DATE, x_prd_end_date IN DATE) IS
2964: SELECT gmsb.actual_period_to_date tot_burdened_cost,
2965: gmsb.actual_period_to_date tot_billable_burdened_cost
2966: FROM gms_balances gmsb, pa_periods pp
2967: WHERE gmsb.project_id = x_project_id
2968: AND gmsb.budget_version_id = x_current_budget_version_id
2969: AND gmsb.task_id = DECODE (
2970: x_task_id,

Line 3078: FROM gms_balances gmsb, pa_periods pp

3074: ) IS
3075: CURSOR selresaccums_p (x_prd_start_date IN DATE, x_prd_end_date IN DATE) IS
3076: SELECT gmsb.actual_period_to_date tot_burdened_cost,
3077: gmsb.actual_period_to_date tot_billable_burdened_cost
3078: FROM gms_balances gmsb, pa_periods pp
3079: WHERE gmsb.project_id = x_project_id
3080: AND gmsb.budget_version_id = x_current_budget_version_id
3081: AND gmsb.task_id = DECODE (
3082: x_task_id,