APPS.PA_FP_CI_MERGE dependencies on PA_CI_TYPES_B

Line 10475: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%TYPE;

10471:
10472: l_part_impl_err VARCHAR2(1);
10473: l_ci_name VARCHAR2(300);
10474:
10475: l_ci_type_class_code pa_ci_types_b.ci_type_class_code%TYPE;
10476:
10477: -- Bug 3986129: Added the following
10478: l_targ_ver_plan_prc_code pa_budget_versions.plan_processing_code%TYPE;
10479: --CBS 12.2 enhancement changes Start here

Line 10777: pa_ci_types_b pct

10773: pct.ci_type_class_code
10774: INTO l_ci_number,
10775: l_ci_type_class_code
10776: FROM pa_control_items pci,
10777: pa_ci_types_b pct
10778: WHERE pci.ci_id = p_ci_id_tbl(i)
10779: AND pci.ci_type_id=pct.ci_type_id;
10780:
10781: IF l_copy_ci_ver_flag='Y' THEN

Line 13327: select 1 from pa_ci_types_b ci_id_to,

13323:
13324:
13325: CURSOR check_supp_cost_reg_flag (ci_id_t number,ci_id_f number)
13326: is
13327: select 1 from pa_ci_types_b ci_id_to,
13328: pa_ci_types_b ci_id_from
13329: where ci_id_to.ci_type_id in(
13330: select ci_type_id
13331: from pa_control_items where ci_id=ci_id_t)

Line 13328: pa_ci_types_b ci_id_from

13324:
13325: CURSOR check_supp_cost_reg_flag (ci_id_t number,ci_id_f number)
13326: is
13327: select 1 from pa_ci_types_b ci_id_to,
13328: pa_ci_types_b ci_id_from
13329: where ci_id_to.ci_type_id in(
13330: select ci_type_id
13331: from pa_control_items where ci_id=ci_id_t)
13332: and ci_id_from.ci_type_id in (

Line 13726: select 1 from pa_ci_types_b ci_id_to,

13722: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
13723:
13724: CURSOR check_dir_cost_reg_flag (ci_id_t number,ci_id_f number)
13725: is
13726: select 1 from pa_ci_types_b ci_id_to,
13727: pa_ci_types_b ci_id_from
13728: where ci_id_to.ci_type_id in(
13729: select ci_type_id
13730: from pa_control_items where ci_id=ci_id_t)

Line 13727: pa_ci_types_b ci_id_from

13723:
13724: CURSOR check_dir_cost_reg_flag (ci_id_t number,ci_id_f number)
13725: is
13726: select 1 from pa_ci_types_b ci_id_to,
13727: pa_ci_types_b ci_id_from
13728: where ci_id_to.ci_type_id in(
13729: select ci_type_id
13730: from pa_control_items where ci_id=ci_id_t)
13731: and ci_id_from.ci_type_id in (