DBA Data[Home] [Help]

APPS.PA_FP_GEN_AMOUNT_UTILS dependencies on PA_FIN_PLAN_TYPES_B

Line 230: PA_FIN_PLAN_TYPES_B FB

226: X_FP_COLS_REC.X_GEN_SRC_WP_VER_CODE
227: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT, PA_PROJ_FP_OPTIONS OPT1,
228: PA_PROJECTS_ALL P, PA_IMPLEMENTATIONS_ALL I,
229: PA_FIN_PLAN_AMOUNT_SETS FP,
230: PA_FIN_PLAN_TYPES_B FB
231: WHERE BV.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
232: AND OPT.PROJECT_ID = BV.PROJECT_ID
233: AND OPT.FIN_PLAN_TYPE_ID = BV.FIN_PLAN_TYPE_ID
234: AND OPT.FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID

Line 1460: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;

1456: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_AMOUNT_UTILS.VALIDATE_SUPPORT_CASES';
1457:
1458: l_wp_track_cost_flag VARCHAR2(1);
1459: l_rev_gen_method VARCHAR2(1);
1460: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;
1461:
1462: l_source_wp_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1463: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
1464: l_source_fp_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

Line 2270: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;

2266: X_MSG_DATA OUT NOCOPY VARCHAR2)
2267: IS
2268: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_AMOUNT_UTILS.DEFAULT_BDGT_SRC_VER';
2269:
2270: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;
2271: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
2272:
2273: -- Variables for Budget Generation source version defaulting logic
2274: l_wp_status PA_PROJ_FP_OPTIONS.GEN_SRC_COST_WP_VER_CODE%TYPE;