APPS.PA_FP_GEN_FCST_AMT_PUB1 dependencies on PA_FIN_PLAN_TYPES_VL

Line 4043: l_src_plan_type_name pa_fin_plan_types_vl.NAME%type;

4039: P_CONTEXT IN VARCHAR2)
4040: RETURN VARCHAR2
4041: IS
4042: l_src_plan_type_id varchar2(50);
4043: l_src_plan_type_name pa_fin_plan_types_vl.NAME%type;
4044: l_dummy varchar2(50):=null;
4045: BEGIN
4046:
4047: SELECT DECODE(BV.VERSION_TYPE,

Line 4056: pa_fin_plan_types_vl PT

4052: INTO l_src_plan_type_id,
4053: l_src_plan_type_name
4054: FROM PA_PROJ_FP_OPTIONS OPT,
4055: PA_BUDGET_VERSIONS BV,
4056: pa_fin_plan_types_vl PT
4057: WHERE
4058: OPT.FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID
4059: AND P_BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID
4060: AND DECODE(BV.VERSION_TYPE,