APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_PROJECT_TYPES_ALL

Line 30: l_rev_budget_flag Pa_Project_Types_All.Allow_Rev_Budget_Entry_Flag%TYPE;

26: x_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE) IS --File.Sql.39 bug 4440895
27:
28: l_no_of_app_plan_types NUMBER;
29: l_tmp_fin_plan_type_id NUMBER;
30: l_rev_budget_flag Pa_Project_Types_All.Allow_Rev_Budget_Entry_Flag%TYPE;
31: l_cost_budget_flag Pa_Project_Types_All.Allow_Cost_Budget_Entry_Flag%TYPE;
32: l_impact_type VARCHAR2(30); -- Bug 3734840
33: BEGIN
34: x_ci_est_qty := NULL;

Line 31: l_cost_budget_flag Pa_Project_Types_All.Allow_Cost_Budget_Entry_Flag%TYPE;

27:
28: l_no_of_app_plan_types NUMBER;
29: l_tmp_fin_plan_type_id NUMBER;
30: l_rev_budget_flag Pa_Project_Types_All.Allow_Rev_Budget_Entry_Flag%TYPE;
31: l_cost_budget_flag Pa_Project_Types_All.Allow_Cost_Budget_Entry_Flag%TYPE;
32: l_impact_type VARCHAR2(30); -- Bug 3734840
33: BEGIN
34: x_ci_est_qty := NULL;
35: x_ci_planned_qty := NULL;

Line 266: Pa_Projects_All p, Pa_Project_Types_All pt WHERE

262: SELECT NVL(Allow_Rev_Budget_Entry_Flag ,'N'),
263: NVL(Allow_Cost_Budget_Entry_Flag,'N') INTO
264: l_rev_budget_flag,
265: l_cost_budget_flag FROM
266: Pa_Projects_All p, Pa_Project_Types_All pt WHERE
267: p.project_id = p_project_id AND
268: p.project_type = pt.project_type AND
269: -- MOAC changes
270: -- removing the nvl from org_id.

Line 303: Pa_Project_Types_All pt

299: BEGIN
300: BEGIN
301: SELECT 'Y' INTO l_fp_allowed_flag FROM
302: Pa_Projects_All p,
303: Pa_Project_Types_All pt
304: WHERE
305: p.Project_Id = p_project_id AND
306: p.Project_Type = pt.Project_Type AND
307: -- MOAC changes