APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_FIN_PLAN_TYPES_B

Line 793: FROM pa_fin_plan_types_b

789: -- hr_utility.trace(to_char(l_stage));
790:
791: SELECT fin_plan_type_id
792: INTO l_fin_plan_type_id
793: FROM pa_fin_plan_types_b
794: WHERE fin_plan_type_code = 'ORG_FORECAST';
795:
796: l_stage := 500;
797: pa_debug.g_err_stage := l_stage||': Get Amount Set Id';

Line 5668: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

5664: l_period_profiles_same_flag VARCHAR2(1);
5665:
5666: -- Bug 3927244
5667: l_copy_actuals_flag VARCHAR2(1) := 'Y';
5668: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
5669: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
5670: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
5671:
5672: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;

Line 5669: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

5665:
5666: -- Bug 3927244
5667: l_copy_actuals_flag VARCHAR2(1) := 'Y';
5668: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
5669: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
5670: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
5671:
5672: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
5673:

Line 5676: FROM pa_fin_plan_types_b pfb,

5672: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
5673:
5674: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS
5675: SELECT pfb.plan_class_code,nvl(pbv.wp_version_flag,'N'),etc_start_date
5676: FROM pa_fin_plan_types_b pfb,
5677: pa_budget_versions pbv
5678: WHERE pbv.budget_version_id = c_budget_version_id
5679: AND pbv.fin_plan_type_id = pfb.fin_plan_type_id;
5680: -- Bug 3927244