APPS.PA_FP_ORG_FCST_UTILS dependencies on PA_SUMM_BALANCES

Line 383: pa_summ_balances psb

379: CURSOR get_utilization_amts IS
380: SELECT psb.amount_type_id,
381: nvl(sum(psb.period_balance),0)
382: FROM pa_objects po,
383: pa_summ_balances psb
384: WHERE po.object_type_code = 'ORG'
385: AND po.expenditure_org_id = p_org_id
386: AND po.project_org_id = -1
387: AND po.expenditure_organization_id = p_organization_id

Line 407: l_amount_type_id pa_summ_balances.amount_type_id%TYPE;

403: AND psb.global_exp_period_end_date = trunc(to_date('01/01/1420','MM/DD/YYYY'))
404: AND psb.amount_type_id in (32,37,38) /* 32-Weighted hours, 37-capacity, 38-Reduced Capacity */
405: GROUP BY amount_type_id;
406:
407: l_amount_type_id pa_summ_balances.amount_type_id%TYPE;
408: l_period_balance pa_summ_balances.period_balance%TYPE :=0;
409: l_hours pa_summ_balances.period_balance%TYPE :=0;
410: l_capacity pa_summ_balances.period_balance%TYPE :=0;
411: l_reduced_capacity pa_summ_balances.period_balance%TYPE :=0;

Line 408: l_period_balance pa_summ_balances.period_balance%TYPE :=0;

404: AND psb.amount_type_id in (32,37,38) /* 32-Weighted hours, 37-capacity, 38-Reduced Capacity */
405: GROUP BY amount_type_id;
406:
407: l_amount_type_id pa_summ_balances.amount_type_id%TYPE;
408: l_period_balance pa_summ_balances.period_balance%TYPE :=0;
409: l_hours pa_summ_balances.period_balance%TYPE :=0;
410: l_capacity pa_summ_balances.period_balance%TYPE :=0;
411: l_reduced_capacity pa_summ_balances.period_balance%TYPE :=0;
412:

Line 409: l_hours pa_summ_balances.period_balance%TYPE :=0;

405: GROUP BY amount_type_id;
406:
407: l_amount_type_id pa_summ_balances.amount_type_id%TYPE;
408: l_period_balance pa_summ_balances.period_balance%TYPE :=0;
409: l_hours pa_summ_balances.period_balance%TYPE :=0;
410: l_capacity pa_summ_balances.period_balance%TYPE :=0;
411: l_reduced_capacity pa_summ_balances.period_balance%TYPE :=0;
412:
413: l_stage NUMBER := 0;

Line 410: l_capacity pa_summ_balances.period_balance%TYPE :=0;

406:
407: l_amount_type_id pa_summ_balances.amount_type_id%TYPE;
408: l_period_balance pa_summ_balances.period_balance%TYPE :=0;
409: l_hours pa_summ_balances.period_balance%TYPE :=0;
410: l_capacity pa_summ_balances.period_balance%TYPE :=0;
411: l_reduced_capacity pa_summ_balances.period_balance%TYPE :=0;
412:
413: l_stage NUMBER := 0;
414:

Line 411: l_reduced_capacity pa_summ_balances.period_balance%TYPE :=0;

407: l_amount_type_id pa_summ_balances.amount_type_id%TYPE;
408: l_period_balance pa_summ_balances.period_balance%TYPE :=0;
409: l_hours pa_summ_balances.period_balance%TYPE :=0;
410: l_capacity pa_summ_balances.period_balance%TYPE :=0;
411: l_reduced_capacity pa_summ_balances.period_balance%TYPE :=0;
412:
413: l_stage NUMBER := 0;
414:
415: BEGIN