APPS.PA_BUDGET_UTILS dependencies on PA_PROJECTS_ALL

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