APPS.PA_FIN_PLAN_TYPES_UTILS dependencies on PA_CONTROL_ITEMS

Line 533: p_ci_type_id IN pa_control_items.ci_type_id%TYPE)

529: /* FP M - dbora - Function to check for any partially implemented COs in a plan type
530: */
531: FUNCTION partially_impl_cos_exist
532: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
533: p_ci_type_id IN pa_control_items.ci_type_id%TYPE)
534: RETURN VARCHAR2 is
535:
536: l_return_flag VARCHAR2(1);
537: l_partial_cos_exist VARCHAR2(1);

Line 576: pa_control_items ci

572: FROM DUAL
573: WHERE
574: EXISTS (SELECT 'X'
575: FROM pa_budget_versions bv,
576: pa_control_items ci
577: WHERE ci.ci_id=bv.ci_id
578: AND bv.fin_plan_type_id= p_fin_plan_type_id
579: AND bv.rev_partially_impl_flag='Y'
580: AND ci.ci_type_id = p_ci_type_id);