APPS.PA_FP_VIEW_PLANS_PUB dependencies on PA_PROJECTS_ALL

Line 66: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;

62: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
63: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
64: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
65: IS
66: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
67: l_default_amount_type_code VARCHAR2(30);
68: l_default_amount_subtype_code VARCHAR2(30);
69: l_start_date DATE;
70: ll_plan_start_date DATE;

Line 174: pa_projects_all pa

170: 'TXN')
171: into l_project_id,
172: l_projfunc_currency_code
173: from pa_budget_versions bv,
174: pa_projects_all pa
175: where bv.budget_version_id = p_orgfcst_version_id and
176: bv.project_id = pa.project_id;
177: select nvl(org_id,-99)
178: into l_org_id

Line 179: from pa_projects_all

175: where bv.budget_version_id = p_orgfcst_version_id and
176: bv.project_id = pa.project_id;
177: select nvl(org_id,-99)
178: into l_org_id
179: from pa_projects_all
180: where project_id = l_project_id;
181: pa_fp_view_plans_pub.G_FP_ORG_ID := l_org_id;
182: x_view_currency_code := l_projfunc_currency_code; -- OUTPUT: x_view_currency_code
183:

Line 979: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;

975: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
976: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
977: ) is
978:
979: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
980: l_default_amount_type_code VARCHAR2(30);
981: l_default_amount_subtype_code VARCHAR2(30);
982: l_start_date DATE;
983: ll_plan_start_date DATE;

Line 1111: from pa_projects_all

1107:
1108: -- GET PROJECT CURRENCY
1109: select projfunc_currency_code
1110: into x_view_currency_code
1111: from pa_projects_all
1112: where project_id = p_project_id;
1113:
1114: open ci_csr;
1115: loop

Line 1170: from pa_projects_all

1166: x_ar_flag := 'Y';
1167: -- get PROJECT CURRENCY
1168: select projfunc_currency_code
1169: into x_view_currency_code
1170: from pa_projects_all
1171: where project_id = p_project_id;
1172: pa_fp_view_plans_pub.G_FP_CURRENCY_TYPE := 'PROJFUNC';
1173: else
1174: -- NOT APPROVED REVENUE: go with Project Currency

Line 1179: from pa_projects_all

1175: x_ar_flag := 'N';
1176: -- get PROJECT CURRENCY
1177: select project_currency_code
1178: into x_view_currency_code
1179: from pa_projects_all
1180: where project_id = p_project_id;
1181: pa_fp_view_plans_pub.G_FP_CURRENCY_TYPE := 'PROJECT';
1182: end if; -- approved revenue flag
1183: /*

Line 1543: pa_projects_all pa

1539: 'TXN')
1540: into l_project_id,
1541: l_projfunc_currency_code
1542: from pa_budget_versions bv,
1543: pa_projects_all pa
1544: where bv.budget_version_id = pa_fp_view_plans_pub.G_FP_VIEW_VERSION_ID and
1545: bv.project_id = pa.project_id;
1546: select nvl(org_id,-99)
1547: into l_org_id

Line 1548: from pa_projects_all

1544: where bv.budget_version_id = pa_fp_view_plans_pub.G_FP_VIEW_VERSION_ID and
1545: bv.project_id = pa.project_id;
1546: select nvl(org_id,-99)
1547: into l_org_id
1548: from pa_projects_all
1549: where project_id = l_project_id;
1550: pa_fp_view_plans_pub.G_FP_ORG_ID := l_org_id;
1551: x_view_currency_code := l_projfunc_currency_code; -- OUTPUT: x_view_currency_code
1552: