APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on GL_PERIODS

Line 236: l_act_period_type gl_periods.period_type%TYPE;

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

Line 436: gl_periods gp

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

Line 529: gl_periods gp

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