DBA Data[Home] [Help]

APPS.PA_BUDGET_PVT dependencies on PA_PROJECT_TYPES

Line 201: FROM pa_project_types ppt

197: (c_project_id pa_projects.project_id%type)
198: IS
199: SELECT ppt.allow_cost_budget_entry_flag
200: ,ppt.allow_rev_budget_entry_flag
201: FROM pa_project_types ppt
202: ,pa_projects_all ppa
203: WHERE ppa.project_id = c_project_id
204: AND ppa.project_type = ppt.project_type;
205:

Line 386: l_allow_cost_budget_entry_flag pa_project_types_all.allow_cost_budget_entry_flag%TYPE;

382: l_old_budget_version_id pa_budget_versions.budget_version_id%TYPE;
383: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
384: l_approved_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
385:
386: l_allow_cost_budget_entry_flag pa_project_types_all.allow_cost_budget_entry_flag%TYPE;
387: l_allow_rev_budget_entry_flag pa_project_types_all.allow_rev_budget_entry_flag%TYPE;
388:
389: -- Budget Integration Variables --------------------------
390: l_fck_req_flag VARCHAR2(1) := NULL;

Line 387: l_allow_rev_budget_entry_flag pa_project_types_all.allow_rev_budget_entry_flag%TYPE;

383: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
384: l_approved_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
385:
386: l_allow_cost_budget_entry_flag pa_project_types_all.allow_cost_budget_entry_flag%TYPE;
387: l_allow_rev_budget_entry_flag pa_project_types_all.allow_rev_budget_entry_flag%TYPE;
388:
389: -- Budget Integration Variables --------------------------
390: l_fck_req_flag VARCHAR2(1) := NULL;
391: l_bdgt_intg_flag VARCHAR2(1) := NULL;