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 85: FROM PA_FIN_PLAN_TYPES_TL PLC, PA_FIN_PLAN_TYPES_TL PLB

81:
82: BEGIN
83: SELECT PLC.NAME, PLB.NAME
84: INTO L_PC_ATTRIBUTES_REC.COST_FIN_PLAN, L_PC_ATTRIBUTES_REC.BENEFIT_FIN_PLAN
85: FROM PA_FIN_PLAN_TYPES_TL PLC, PA_FIN_PLAN_TYPES_TL PLB
86: WHERE
87: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_COST') = PLC.FIN_PLAN_TYPE_ID AND
88: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_BENEFIT') = PLB.FIN_PLAN_TYPE_ID AND
89: PLC.LANGUAGE = USERENV('LANG') AND -- Bug Ref # 6450301