APPS.PA_BUDGET_UTILS dependencies on PA_PROJECTS

Line 246: pa_projects p

242: t.cost_budget_resource_list_id
243: into x_allow_budget_entry_flag,
244: x_resource_list_id
245: from pa_project_types t,
246: pa_projects p
247: where p.project_id = x_project_id
248: and p.project_type = t.project_type;
249:
250: else

Line 257: pa_projects p

253: t.rev_budget_resource_list_id
254: into x_allow_budget_entry_flag,
255: x_resource_list_id
256: from pa_project_types t,
257: pa_projects p
258: where p.project_id = x_project_id
259: and p.project_type = t.project_type;
260:
261: end if;

Line 323: pa_projects p

319: t.cost_budget_entry_method_code
320: into x_allow_budget_entry_flag,
321: x_budget_entry_method_code
322: from pa_project_types t,
323: pa_projects p
324: where p.project_id = x_project_id
325: and p.project_type = t.project_type;
326:
327: else

Line 334: pa_projects p

330: t.rev_budget_entry_method_code
331: into x_allow_budget_entry_flag,
332: x_budget_entry_method_code
333: from pa_project_types t,
334: pa_projects p
335: where p.project_id = x_project_id
336: and p.project_type = t.project_type;
337:
338: end if;

Line 2134: l_Projfunc_Currency_Code pa_projects_all.projfunc_currency_code%TYPE := NULL;

2130: from pa_budget_versions
2131: where budget_version_id = x_budget_version_id;
2132:
2133:
2134: l_Projfunc_Currency_Code pa_projects_all.projfunc_currency_code%TYPE := NULL;
2135: l_Project_Currency_Code pa_projects_all.project_currency_code%TYPE := NULL;
2136: l_Txn_Currency_Code pa_projects_all.projfunc_currency_code%TYPE := NULL;
2137:
2138: l_Return_Status VARCHAR2(1) :=NULL;

Line 2135: l_Project_Currency_Code pa_projects_all.project_currency_code%TYPE := NULL;

2131: where budget_version_id = x_budget_version_id;
2132:
2133:
2134: l_Projfunc_Currency_Code pa_projects_all.projfunc_currency_code%TYPE := NULL;
2135: l_Project_Currency_Code pa_projects_all.project_currency_code%TYPE := NULL;
2136: l_Txn_Currency_Code pa_projects_all.projfunc_currency_code%TYPE := NULL;
2137:
2138: l_Return_Status VARCHAR2(1) :=NULL;
2139: l_Msg_Data VARCHAR2(2000) :=NULL;

Line 2136: l_Txn_Currency_Code pa_projects_all.projfunc_currency_code%TYPE := NULL;

2132:
2133:
2134: l_Projfunc_Currency_Code pa_projects_all.projfunc_currency_code%TYPE := NULL;
2135: l_Project_Currency_Code pa_projects_all.project_currency_code%TYPE := NULL;
2136: l_Txn_Currency_Code pa_projects_all.projfunc_currency_code%TYPE := NULL;
2137:
2138: l_Return_Status VARCHAR2(1) :=NULL;
2139: l_Msg_Data VARCHAR2(2000) :=NULL;
2140: l_Msg_Count NUMBER := 0;

Line 3913: FROM pa_projects_all

3909: , projfunc_currency_code
3910: INTO pa_budget_utils.G_projfunc_currency_code
3911: , pa_budget_utils.G_project_currency_code
3912: , pa_budget_utils.G_txn_currency_code
3913: FROM pa_projects_all
3914: WHERE project_id = p_project_id;
3915:
3916: -- Save P_project_id to Skip this Fetch for Subsequent Calls
3917: pa_budget_utils.G_project_id := p_project_id;

Line 4217: l_org_id pa_projects_all.org_id%TYPE := NULL;

4213: , x_err_code OUT NOCOPY NUMBER
4214: )
4215: IS
4216:
4217: l_org_id pa_projects_all.org_id%TYPE := NULL;
4218:
4219: Begin
4220:
4221:

Line 4236: FROM pa_projects_all

4232: -- by the calling object.
4233:
4234: SELECT org_id
4235: INTO l_org_id
4236: FROM pa_projects_all
4237: WHERE project_id = p_project_id;
4238:
4239:
4240: -- Set the Operating Unit Context