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 177: pa_projects_all pa

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

Line 182: from pa_projects_all

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

Line 627: pa_projects_all ppa

623: select gp.START_DATE INTO l_start_date
624: from gl_periods gp,
625: gl_sets_of_books gsb,
626: pa_implementations_all pia,
627: pa_projects_all ppa
628: where
629: gp.period_set_name = gsb.period_set_name
630: and gp.period_type = gsb.accounted_period_type
631: and gsb.set_of_books_id = pia.set_of_books_id

Line 639: pa_projects_all ppa

635: elsif ll_plan_period_type = 'PA' THEN
636: select gp.START_DATE INTO l_start_date
637: from gl_periods gp,
638: pa_implementations_all pia,
639: pa_projects_all ppa
640: where
641: gp.period_set_name = pia.period_set_name
642: and gp.period_type = pia.pa_period_type
643: and pia.org_id = ppa.org_id

Line 1075: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;

1071: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1072: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1073: ) is
1074:
1075: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
1076: l_default_amount_type_code VARCHAR2(30);
1077: l_default_amount_subtype_code VARCHAR2(30);
1078: l_start_date DATE;
1079: ll_plan_start_date DATE;

Line 1207: from pa_projects_all

1203:
1204: -- GET PROJECT CURRENCY
1205: select projfunc_currency_code
1206: into x_view_currency_code
1207: from pa_projects_all
1208: where project_id = p_project_id;
1209:
1210: open ci_csr;
1211: loop

Line 1266: from pa_projects_all

1262: x_ar_flag := 'Y';
1263: -- get PROJECT CURRENCY
1264: select projfunc_currency_code
1265: into x_view_currency_code
1266: from pa_projects_all
1267: where project_id = p_project_id;
1268: pa_fp_view_plans_pub.G_FP_CURRENCY_TYPE := 'PROJFUNC';
1269: else
1270: -- NOT APPROVED REVENUE: go with Project Currency

Line 1275: from pa_projects_all

1271: x_ar_flag := 'N';
1272: -- get PROJECT CURRENCY
1273: select project_currency_code
1274: into x_view_currency_code
1275: from pa_projects_all
1276: where project_id = p_project_id;
1277: pa_fp_view_plans_pub.G_FP_CURRENCY_TYPE := 'PROJECT';
1278: end if; -- approved revenue flag
1279: /*

Line 1639: pa_projects_all pa

1635: 'TXN')
1636: into l_project_id,
1637: l_projfunc_currency_code
1638: from pa_budget_versions bv,
1639: pa_projects_all pa
1640: where bv.budget_version_id = pa_fp_view_plans_pub.G_FP_VIEW_VERSION_ID and
1641: bv.project_id = pa.project_id;
1642: select nvl(org_id,-99)
1643: into l_org_id

Line 1644: from pa_projects_all

1640: where bv.budget_version_id = pa_fp_view_plans_pub.G_FP_VIEW_VERSION_ID and
1641: bv.project_id = pa.project_id;
1642: select nvl(org_id,-99)
1643: into l_org_id
1644: from pa_projects_all
1645: where project_id = l_project_id;
1646: pa_fp_view_plans_pub.G_FP_ORG_ID := l_org_id;
1647: x_view_currency_code := l_projfunc_currency_code; -- OUTPUT: x_view_currency_code
1648: