APPS.PA_FP_UPGRADE_PKG dependencies on PA_CONTROL_ITEMS

Line 4352: l_ci_id pa_control_items.ci_id%TYPE;

4348:
4349: l_project_id pa_projects.project_id%TYPE;
4350: l_bv_id pa_budget_versions.budget_version_id%TYPE;
4351: l_budg_ver_id pa_budget_versions.budget_version_id%TYPE;
4352: l_ci_id pa_control_items.ci_id%TYPE;
4353: l_op_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4354:
4355: /* For bug 5084161 */
4356: l_ci_status_code pa_control_items.status_code%TYPE;

Line 4356: l_ci_status_code pa_control_items.status_code%TYPE;

4352: l_ci_id pa_control_items.ci_id%TYPE;
4353: l_op_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4354:
4355: /* For bug 5084161 */
4356: l_ci_status_code pa_control_items.status_code%TYPE;
4357: l_process_flag varchar2(1);
4358: /* For bug 5084161 */
4359:
4360: l_retcode number;

Line 4389: pa_control_items ci,

4385: ci.status_code
4386: FROM pa_projects prj,
4387: pa_budget_versions bv,
4388: pa_fin_plan_types_b fp,
4389: pa_control_items ci,
4390: pa_proj_fp_options op
4391: WHERE segment1 BETWEEN NVL(c_from_project_number,segment1) AND NVL(c_to_project_number,segment1)
4392: AND DECODE(c_project_statuses,'ALL','ACTIVE',prj.project_status_code) = 'ACTIVE'
4393: AND bv.project_id = prj.project_id