APPS.PA_FP_GEN_FCST_AMT_PUB1 dependencies on PA_FIN_PLAN_TYPES_VL

Line 4019: l_src_plan_type_name pa_fin_plan_types_vl.NAME%type;

4015: P_CONTEXT IN VARCHAR2)
4016: RETURN VARCHAR2
4017: IS
4018: l_src_plan_type_id varchar2(50);
4019: l_src_plan_type_name pa_fin_plan_types_vl.NAME%type;
4020: l_dummy varchar2(50):=null;
4021: BEGIN
4022:
4023: SELECT DECODE(BV.VERSION_TYPE,

Line 4032: pa_fin_plan_types_vl PT

4028: INTO l_src_plan_type_id,
4029: l_src_plan_type_name
4030: FROM PA_PROJ_FP_OPTIONS OPT,
4031: PA_BUDGET_VERSIONS BV,
4032: pa_fin_plan_types_vl PT
4033: WHERE
4034: OPT.FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID
4035: AND P_BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID
4036: AND DECODE(BV.VERSION_TYPE,