APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_PROJECT_TYPES_ALL

Line 37: l_rev_budget_flag Pa_Project_Types_All.Allow_Rev_Budget_Entry_Flag%TYPE;

33: x_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE) IS --File.Sql.39 bug 4440895
34:
35: l_no_of_app_plan_types NUMBER;
36: l_tmp_fin_plan_type_id NUMBER;
37: l_rev_budget_flag Pa_Project_Types_All.Allow_Rev_Budget_Entry_Flag%TYPE;
38: l_cost_budget_flag Pa_Project_Types_All.Allow_Cost_Budget_Entry_Flag%TYPE;
39: l_impact_type VARCHAR2(30); -- Bug 3734840
40: BEGIN
41: x_ci_est_qty := NULL;

Line 38: l_cost_budget_flag Pa_Project_Types_All.Allow_Cost_Budget_Entry_Flag%TYPE;

34:
35: l_no_of_app_plan_types NUMBER;
36: l_tmp_fin_plan_type_id NUMBER;
37: l_rev_budget_flag Pa_Project_Types_All.Allow_Rev_Budget_Entry_Flag%TYPE;
38: l_cost_budget_flag Pa_Project_Types_All.Allow_Cost_Budget_Entry_Flag%TYPE;
39: l_impact_type VARCHAR2(30); -- Bug 3734840
40: BEGIN
41: x_ci_est_qty := NULL;
42: x_ci_planned_qty := NULL;

Line 290: Pa_Projects_All p, Pa_Project_Types_All pt WHERE

286: SELECT NVL(Allow_Rev_Budget_Entry_Flag ,'N'),
287: NVL(Allow_Cost_Budget_Entry_Flag,'N') INTO
288: l_rev_budget_flag,
289: l_cost_budget_flag FROM
290: Pa_Projects_All p, Pa_Project_Types_All pt WHERE
291: p.project_id = p_project_id AND
292: p.project_type = pt.project_type AND
293: -- MOAC changes
294: -- removing the nvl from org_id.

Line 327: Pa_Project_Types_All pt

323: BEGIN
324: BEGIN
325: SELECT 'Y' INTO l_fp_allowed_flag FROM
326: Pa_Projects_All p,
327: Pa_Project_Types_All pt
328: WHERE
329: p.Project_Id = p_project_id AND
330: p.Project_Type = pt.Project_Type AND
331: -- MOAC changes