APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_FIN_PLAN_TYPES_B

Line 794: FROM pa_fin_plan_types_b

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

Line 5673: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

5669: l_period_profiles_same_flag VARCHAR2(1);
5670:
5671: -- Bug 3927244
5672: l_copy_actuals_flag VARCHAR2(1) := 'Y';
5673: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
5674: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
5675: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
5676:
5677: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;

Line 5674: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

5670:
5671: -- Bug 3927244
5672: l_copy_actuals_flag VARCHAR2(1) := 'Y';
5673: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
5674: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
5675: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
5676:
5677: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
5678:

Line 5681: FROM pa_fin_plan_types_b pfb,

5677: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
5678:
5679: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS
5680: SELECT pfb.plan_class_code,nvl(pbv.wp_version_flag,'N'),etc_start_date
5681: FROM pa_fin_plan_types_b pfb,
5682: pa_budget_versions pbv
5683: WHERE pbv.budget_version_id = c_budget_version_id
5684: AND pbv.fin_plan_type_id = pfb.fin_plan_type_id;
5685: -- Bug 3927244