DBA Data[Home] [Help]

APPS.PA_FP_ROLLUP_PKG dependencies on PA_PROJECT_TYPES_ALL

Line 411: l_org_forecast_flag PA_PROJECT_TYPES_ALL.org_project_flag%TYPE;

407: l_debug_mode VARCHAR2(30);
408:
409: -- Bug 3362316, 08-JAN-2004: ---------------------
410:
411: l_org_forecast_flag PA_PROJECT_TYPES_ALL.org_project_flag%TYPE;
412:
413: -- End, Bug 3362316, 08-JAN-2004: ---------------------
414:
415: -- Bug 3441943, 18-FEB-2004: New Vars to sum people (labor) and equipment quantities ------------

Line 588: , pa_project_types_all pt

584: SELECT org_project_flag
585: INTO l_org_forecast_flag
586: FROM pa_budget_versions v
587: , pa_projects_all p
588: , pa_project_types_all pt
589: WHERE v.budget_version_id = p_budget_version_id
590: AND v.project_id = p.project_id
591: AND p.project_type = pt.project_type
592: /* Bug fix: 4510784 AND Nvl(p.org_id, -99) = nvl(pt.org_id,-99); */ /* Bug 4193069*/