DBA Data[Home] [Help]

APPS.PA_FP_CI_INCLUDE_PKG dependencies on PA_PROJ_FP_OPTIONS

Line 41: l_s_fin_plan_pref_code pa_proj_fp_options. fin_plan_preference_code%TYPE;

37:
38: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
39: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
40:
41: l_s_fin_plan_pref_code pa_proj_fp_options. fin_plan_preference_code%TYPE;
42: l_s_multi_curr_flag pa_proj_fp_options. plan_in_multi_curr_flag%TYPE;
43: l_s_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
44: l_s_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
45: l_s_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;

Line 42: l_s_multi_curr_flag pa_proj_fp_options. plan_in_multi_curr_flag%TYPE;

38: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
39: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
40:
41: l_s_fin_plan_pref_code pa_proj_fp_options. fin_plan_preference_code%TYPE;
42: l_s_multi_curr_flag pa_proj_fp_options. plan_in_multi_curr_flag%TYPE;
43: l_s_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
44: l_s_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
45: l_s_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
46: l_s_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;

Line 43: l_s_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;

39: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
40:
41: l_s_fin_plan_pref_code pa_proj_fp_options. fin_plan_preference_code%TYPE;
42: l_s_multi_curr_flag pa_proj_fp_options. plan_in_multi_curr_flag%TYPE;
43: l_s_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
44: l_s_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
45: l_s_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
46: l_s_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
47: l_s_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;

Line 44: l_s_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;

40:
41: l_s_fin_plan_pref_code pa_proj_fp_options. fin_plan_preference_code%TYPE;
42: l_s_multi_curr_flag pa_proj_fp_options. plan_in_multi_curr_flag%TYPE;
43: l_s_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
44: l_s_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
45: l_s_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
46: l_s_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
47: l_s_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
48: l_s_version_type pa_budget_versions.version_type%TYPE;

Line 45: l_s_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;

41: l_s_fin_plan_pref_code pa_proj_fp_options. fin_plan_preference_code%TYPE;
42: l_s_multi_curr_flag pa_proj_fp_options. plan_in_multi_curr_flag%TYPE;
43: l_s_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
44: l_s_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
45: l_s_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
46: l_s_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
47: l_s_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
48: l_s_version_type pa_budget_versions.version_type%TYPE;
49: l_s_ci_id pa_budget_versions.ci_id%TYPE;

Line 448: (select 1 from pa_proj_fp_options

444: select 'Y'
445: into l_appr_bdgt_pt_exists
446: from dual
447: where exists
448: (select 1 from pa_proj_fp_options
449: where project_id = p_project_id
450: and approved_cost_plan_type_flag = 'Y'
451: and approved_rev_plan_type_flag = 'Y'
452: and fin_plan_option_level_code = 'PLAN_TYPE'