DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_FIN_PLAN_AMOUNT_SETS

Line 191: l_fin_plan_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

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

Line 805: FROM pa_fin_plan_amount_sets

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

Line 4962: l_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE;

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

Line 4963: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE;

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

Line 5660: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%type;

5656:
5657: l_source_period_profile_id pa_budget_versions.period_profile_id%TYPE;
5658: l_target_period_profile_id pa_budget_versions.period_profile_id%TYPE;
5659:
5660: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%type;
5661: l_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%type;
5662:
5663: l_adj_percentage NUMBER ;
5664: l_period_profiles_same_flag VARCHAR2(1);

Line 5661: l_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%type;

5657: l_source_period_profile_id pa_budget_versions.period_profile_id%TYPE;
5658: l_target_period_profile_id pa_budget_versions.period_profile_id%TYPE;
5659:
5660: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%type;
5661: l_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%type;
5662:
5663: l_adj_percentage NUMBER ;
5664: l_period_profiles_same_flag VARCHAR2(1);
5665: