APPS.PA_FP_WP_GEN_AMT_UTILS dependencies on PA_FIN_PLAN_TYPES_B

Line 10: pa_fin_plan_types_b pt

6: l_pt_id number := null;
7: begin
8: select opt.fin_plan_type_id into l_pt_id
9: from pa_proj_fp_options opt,
10: pa_fin_plan_types_b pt
11: where
12: opt.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_TYPE' and
13: opt.FIN_PLAN_TYPE_ID = pt.FIN_PLAN_TYPE_ID and
14: nvl(pt.USE_FOR_WORKPLAN_FLAG,'N') = 'Y' and

Line 52: FROM pa_proj_fp_options opt, pa_fin_plan_types_b pt

48: IS
49: l_flag VARCHAR2(5) := NULL;
50: BEGIN
51: SELECT NVL(TRACK_WORKPLAN_COSTS_FLAG,'N') INTO l_flag
52: FROM pa_proj_fp_options opt, pa_fin_plan_types_b pt
53: WHERE opt.project_id = P_PROJECT_ID
54: AND opt.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_TYPE'
55: AND pt.fin_plan_type_id = opt.fin_plan_type_id
56: AND NVL(pt.USE_FOR_WORKPLAN_FLAG,'N') = 'Y';

Line 69: FROM pa_proj_fp_options opt, pa_fin_plan_types_b pt

65: RETURN VARCHAR2 IS
66: l_time_phase_code pa_proj_fp_options.cost_time_phased_code%type;
67: BEGIN
68: SELECT opt.cost_time_phased_code INTO l_time_phase_code
69: FROM pa_proj_fp_options opt, pa_fin_plan_types_b pt
70: WHERE opt.project_id = P_PROJECT_ID
71: AND opt.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_TYPE'
72: AND pt.fin_plan_type_id = opt.fin_plan_type_id
73: AND NVL(pt.USE_FOR_WORKPLAN_FLAG,'N') = 'Y';