APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_FIN_PLAN_AMOUNT_SETS

Line 192: l_fin_plan_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

188: l_project_action_allowed varchar2(1);
189:
190: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
191: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
192: l_fin_plan_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
193: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
194: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
195: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
196: l_bv_rec_ver_num pa_budget_versions.record_version_number%TYPE;

Line 806: FROM pa_fin_plan_amount_sets

802: -- hr_utility.trace(to_char(l_stage));
803:
804: SELECT fin_plan_amount_set_id
805: INTO l_fin_plan_amount_set_id
806: FROM pa_fin_plan_amount_sets
807: WHERE amount_set_type_code = 'ALL'
808: AND fin_plan_amount_set_id = 1; /* Fix for 2744924. */
809:
810: l_stage := 600;

Line 4963: l_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE;

4959: l_debug_mode VARCHAR2(30);
4960:
4961: l_adj_percentage NUMBER ;
4962: l_target_project_id pa_projects.project_id%TYPE;
4963: l_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE;
4964: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE;
4965:
4966: l_tmp NUMBER;
4967:

Line 4964: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE;

4960:
4961: l_adj_percentage NUMBER ;
4962: l_target_project_id pa_projects.project_id%TYPE;
4963: l_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE;
4964: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE;
4965:
4966: l_tmp NUMBER;
4967:
4968:

Line 5665: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%type;

5661:
5662: l_source_period_profile_id pa_budget_versions.period_profile_id%TYPE;
5663: l_target_period_profile_id pa_budget_versions.period_profile_id%TYPE;
5664:
5665: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%type;
5666: l_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%type;
5667:
5668: l_adj_percentage NUMBER ;
5669: l_period_profiles_same_flag VARCHAR2(1);

Line 5666: l_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%type;

5662: l_source_period_profile_id pa_budget_versions.period_profile_id%TYPE;
5663: l_target_period_profile_id pa_budget_versions.period_profile_id%TYPE;
5664:
5665: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%type;
5666: l_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%type;
5667:
5668: l_adj_percentage NUMBER ;
5669: l_period_profiles_same_flag VARCHAR2(1);
5670: