APPS.PA_BUDGET_UTILS dependencies on PA_PROJECTS_ALL

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

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

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

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

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

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

Line 3917: FROM pa_projects_all

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

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

4217: , x_err_code OUT NOCOPY NUMBER
4218: )
4219: IS
4220:
4221: l_org_id pa_projects_all.org_id%TYPE := NULL;
4222:
4223: Begin
4224:
4225:

Line 4240: FROM pa_projects_all

4236: -- by the calling object.
4237:
4238: SELECT org_id
4239: INTO l_org_id
4240: FROM pa_projects_all
4241: WHERE project_id = p_project_id;
4242:
4243:
4244: -- Set the Operating Unit Context