APPS.PA_FIN_PLAN_PVT dependencies on PA_BUDGET_ENTRY_METHODS

Line 291: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_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;
291: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE;
292: l_fin_plan_level_code VARCHAR2(30);
293: l_fin_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
294: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
295: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;

Line 295: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;

291: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE;
292: l_fin_plan_level_code VARCHAR2(30);
293: l_fin_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
294: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
295: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
296: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
297: l_pm_product_code pa_budget_versions.pm_product_code%TYPE;
298: l_workflow_is_used VARCHAR2(1); -- flag to determine if workflow is used
299: l_warnings_only_flag VARCHAR2(1);

Line 296: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;

292: l_fin_plan_level_code VARCHAR2(30);
293: l_fin_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
294: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
295: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
296: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
297: l_pm_product_code pa_budget_versions.pm_product_code%TYPE;
298: l_workflow_is_used VARCHAR2(1); -- flag to determine if workflow is used
299: l_warnings_only_flag VARCHAR2(1);
300: l_funding_level varchar2(2) default NULL;

Line 502: from pa_budget_entry_methods

498:
499: if l_budget_entry_method_code is not null then
500: select entry_level_code
501: into l_entry_level_code
502: from pa_budget_entry_methods
503: where budget_entry_method_code = l_budget_entry_method_code;
504: end if;
505:
506: --dbms_output.put_line('big select statement executed');

Line 1359: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%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;
1360: l_fin_plan_level_code VARCHAR2(30);
1361: l_fin_plan_type_code VARCHAR2(30);
1362: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
1363: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;

Line 1363: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;

1359: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE;
1360: l_fin_plan_level_code VARCHAR2(30);
1361: l_fin_plan_type_code VARCHAR2(30);
1362: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
1363: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
1364: l_pm_product_code pa_budget_versions.pm_product_code%TYPE;
1365: l_workflow_is_used VARCHAR2(1); -- flag to determine if workflow is used
1366: l_warnings_only_flag VARCHAR2(1);
1367: l_mark_as_original varchar2(30) := 'N';

Line 1475: -- pa_budget_entry_methods be,

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,
1477: pa_fin_plan_types_b pavl
1478: where bv.budget_version_id = p_budget_version_id and
1479: opt.fin_plan_version_id = bv.budget_version_id and