APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on GL_DATE_PERIOD_MAP

Line 436: gl_date_period_map dpm,

432: DECODE(pfi.project_org_id,l_org_id,
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')

Line 529: gl_date_period_map dpm,

525: DECODE(pfi.project_org_id,l_org_id,
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')