APPS.PA_FIN_PLAN_PVT dependencies on PA_PROJECT_TYPES

Line 235: -- pa_project_types_all, need to join based on org_id as well

231:
232: /* ------------------------------------------------------------------------ */
233:
234: -- 11/16/02 dlai: bug fix 2668857 - when joining pa_projects_all with
235: -- pa_project_types_all, need to join based on org_id as well
236:
237: -- 12-FEB-04 jwhite - Bug 3440026
238: -- Commented obsolete call to
239: -- PA_BUDGET_UTILS.summerize_project_totals

Line 286: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;

282: x_err_stack VARCHAR2(2000);
283:
284: -- local variables
285: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
286: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
287: l_version_type pa_budget_versions.version_type%TYPE;
288: l_ac_flag VARCHAR2(1);
289: l_ar_flag VARCHAR2(1);
290: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;

Line 457: from pa_project_types_all pt,

453: /* l_created_by, Commented for bug 6176649 */
454: l_fin_plan_type_id,
455: l_fin_plan_class_code,
456: l_auto_baseline_project
457: from pa_project_types_all pt,
458: pa_projects_all pr,
459: pa_budget_versions bv,
460: pa_proj_fp_options opt,
461: pa_fin_plan_types_b pavl

Line 1329: -- pa_project_types_all, need to join based on org_id as well

1325: /* ------------------------------------------------------------------------ */
1326:
1327: -- HISTORY
1328: -- 11/16/02 dlai: bug fix 2668857 - when joining pa_projects_all with
1329: -- pa_project_types_all, need to join based on org_id as well
1330: PROCEDURE Submit_Current_Working_FinPlan
1331: (p_project_id IN pa_budget_versions.project_id%TYPE,
1332: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1333: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

Line 1355: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;

1351:
1352: -- local variables
1353: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
1354: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1355: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
1356: l_version_type pa_budget_versions.version_type%TYPE;
1357: l_ac_flag VARCHAR2(1);
1358: l_ar_flag VARCHAR2(1);
1359: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE;

Line 1472: from pa_project_types_all pt,

1468: -- l_entry_level_code,
1469: l_pm_product_code,
1470: /* l_created_by, Commented for bug 6176649 */
1471: l_fin_plan_type_id
1472: from pa_project_types_all pt,
1473: pa_projects_all pr,
1474: pa_budget_versions bv,
1475: -- pa_budget_entry_methods be,
1476: pa_proj_fp_options opt,