DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_TYPES_UTILS dependencies on PA_PT_CO_IMPL_STATUSES

Line 651: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,

647: */
648:
649: FUNCTION GET_CONCAT_STATUSES
650: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
651: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
652: p_impact_type_code IN pa_pt_co_impl_statuses.version_type%TYPE)
653: RETURN VARCHAR2 IS
654:
655: l_concat_status VARCHAR2(2000);

Line 652: p_impact_type_code IN pa_pt_co_impl_statuses.version_type%TYPE)

648:
649: FUNCTION GET_CONCAT_STATUSES
650: (p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
651: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
652: p_impact_type_code IN pa_pt_co_impl_statuses.version_type%TYPE)
653: RETURN VARCHAR2 IS
654:
655: l_concat_status VARCHAR2(2000);
656:

Line 664: PA_PT_CO_IMPL_STATUSES ptco

660:
661: CURSOR c_status_csr (c_impact_type_code VARCHAR2) IS
662: SELECT ci.project_status_name
663: FROM PA_CI_STATUSES_V ci,
664: PA_PT_CO_IMPL_STATUSES ptco
665: WHERE ptco.ci_type_id=p_ci_type_id
666: AND ptco.fin_plan_type_id=p_fin_plan_type_id
667: AND ptco.version_type=c_impact_type_code
668: AND ci.ci_type_id = ptco.ci_type_id