APPS.PA_FP_CI_IMPLEMENT_PKG dependencies on PA_PROJ_FP_OPTIONS

Line 28: l_ci_ver_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;

24: l_total_proj_revenue pa_budget_versions.total_project_revenue%TYPE;
25: l_total_projfunc_revenue pa_budget_versions.revenue%TYPE;
26: l_bv_id pa_budget_versions.budget_version_id%TYPE;
27:
28: l_ci_ver_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
29: l_funding_level VARCHAR2(100);
30: l_err_code NUMBER := null;
31: l_err_stage varchar2(1000) := null;
32: l_err_stack varchar2(1000) := null;

Line 148: pa_proj_fp_options po WHERE

144: l_budget_version_id,
145: l_agreement_id,
146: l_ci_ver_planning_level
147: FROM PA_BUDGET_VERSIONS bv,
148: pa_proj_fp_options po WHERE
149: bv.project_id = p_project_id
150: AND bv.approved_rev_plan_type_flag = 'Y'
151: AND bv.version_type IN ('REVENUE','ALL')
152: AND po.project_id = bv.project_id