APPS.PA_FP_WP_GEN_AMT_UTILS dependencies on PA_PROJ_FP_OPTIONS

Line 9: from pa_proj_fp_options opt,

5: return number is
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

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 66: l_time_phase_code pa_proj_fp_options.cost_time_phased_code%type;

62: END get_wp_track_cost_amt_flag;
63:
64: FUNCTION get_wp_pt_time_phase_code(p_project_id IN NUMBER)
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

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';