APPS.FPA_MAIN_PROCESS_PVT dependencies on PA_FIN_PLAN_TYPES_TL

Line 21: cost_fin_plan PA_FIN_PLAN_TYPES_TL.NAME%TYPE,

17: (portfolio_name FPA_OBJECTS_TL.NAME%TYPE,
18: pc_name FPA_OBJECTS_TL.NAME%TYPE,
19: portfolio_type PA_CLASS_CODES.CLASS_CODE%TYPE,
20: inv_class_category PA_CLASS_CATEGORIES.CLASS_CATEGORY%TYPE,
21: cost_fin_plan PA_FIN_PLAN_TYPES_TL.NAME%TYPE,
22: benefit_fin_plan PA_FIN_PLAN_TYPES_TL.NAME%TYPE);
23:
24:
25:

Line 22: benefit_fin_plan PA_FIN_PLAN_TYPES_TL.NAME%TYPE);

18: pc_name FPA_OBJECTS_TL.NAME%TYPE,
19: portfolio_type PA_CLASS_CODES.CLASS_CODE%TYPE,
20: inv_class_category PA_CLASS_CATEGORIES.CLASS_CATEGORY%TYPE,
21: cost_fin_plan PA_FIN_PLAN_TYPES_TL.NAME%TYPE,
22: benefit_fin_plan PA_FIN_PLAN_TYPES_TL.NAME%TYPE);
23:
24:
25:
26: PROCEDURE GET_WF_ATTRIBUTES(

Line 83: FROM PA_FIN_PLAN_TYPES_TL PLC, PA_FIN_PLAN_TYPES_TL PLB

79:
80: BEGIN
81: SELECT PLC.NAME, PLB.NAME
82: INTO L_PC_ATTRIBUTES_REC.COST_FIN_PLAN, L_PC_ATTRIBUTES_REC.BENEFIT_FIN_PLAN
83: FROM PA_FIN_PLAN_TYPES_TL PLC, PA_FIN_PLAN_TYPES_TL PLB
84: WHERE
85: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_COST') = PLC.FIN_PLAN_TYPE_ID AND
86: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_BENEFIT') = PLB.FIN_PLAN_TYPE_ID;
87: EXCEPTION