APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on GL_PERIODS

Line 237: l_act_period_type gl_periods.period_type%TYPE;

233: l_prv_forecast_element_id pa_org_fcst_elements.forecast_element_id%TYPE;
234: l_utl_hours pa_budget_lines.utilization_hours%TYPE;
235: l_utl_capacity pa_budget_lines.capacity%TYPE;
236: l_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
237: l_act_period_type gl_periods.period_type%TYPE;
238:
239:
240: CURSOR fl_lines_task IS
241: SELECT

Line 437: gl_periods gp

433: DECODE(pfi.tp_amount_type,'REVENUE_TRANSFER',
434: NVL(sum(pfi.projfunc_transfer_price),0),0),0),0) tp_rev_out
435: FROM pa_forecast_items pfi,
436: gl_date_period_map dpm,
437: gl_periods gp
438: WHERE pfi.project_organization_id = l_organization_id
439: and nvl(pfi.project_org_id,-99) = l_org_id
440: AND pfi.forecast_item_type in ('A','R','U')
441: AND pfi.delete_flag = 'N'

Line 530: gl_periods gp

526: DECODE(pfi.tp_amount_type,'REVENUE_TRANSFER',
527: NVL(sum(pfi.projfunc_transfer_price),0),0),0),0) tp_rev_out
528: FROM pa_forecast_items pfi,
529: gl_date_period_map dpm,
530: gl_periods gp
531: WHERE pfi.expenditure_organization_id = l_organization_id
532: and nvl(pfi.expenditure_org_id,-99) = l_org_id
533: AND pfi.forecast_item_type in ('A','R','U')
534: AND pfi.delete_flag = 'N'