DBA Data[Home] [Help]

APPS.PA_FP_VIEW_PLANS_PUB dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 1159: pa_resource_lists_all_bg rl

1155: l_ac_flag,
1156: l_ar_flag,
1157: l_uncategorized_flag
1158: from pa_budget_versions bv,
1159: pa_resource_lists_all_bg rl
1160: where bv.budget_version_id = ci_rec.budget_version_id and
1161: bv.resource_list_id = rl.resource_list_id;
1162:
1163: -- >>>> BUG FIX 2650878: project or projfunc, depending on AR flag <<<<

Line 1291: pa_resource_lists_all_bg rl

1287: l_compl_resource_list_id,
1288: l_compl_rv_number,
1289: l_compl_uncategorized_flag
1290: from pa_budget_versions bv,
1291: pa_resource_lists_all_bg rl
1292: where bv.budget_version_id = ci_rec.budget_version_id and
1293: bv.resource_list_id = rl.resource_list_id;
1294: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := l_ci_budget_version_id;
1295: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := ci_rec.budget_version_id;

Line 1353: pa_resource_lists_all_bg rl

1349: l_compl_resource_list_id,
1350: l_compl_rv_number,
1351: l_compl_uncategorized_flag
1352: from pa_budget_versions bv,
1353: pa_resource_lists_all_bg rl
1354: where bv.budget_version_id = ci_rec.budget_version_id and
1355: bv.resource_list_id = rl.resource_list_id;
1356: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := ci_rec.budget_version_id;
1357: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := l_ci_budget_version_id;

Line 1416: pa_resource_lists_all_bg rl

1412: l_compl_resource_list_id,
1413: l_compl_rv_number,
1414: l_compl_uncategorized_flag
1415: from pa_budget_versions bv,
1416: pa_resource_lists_all_bg rl
1417: where bv.budget_version_id = ci_rec.budget_version_id and
1418: bv.resource_list_id = rl.resource_list_id;
1419: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := ci_rec.budget_version_id;
1420: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := l_ci_budget_version_id;

Line 1478: pa_resource_lists_all_bg rl

1474: l_compl_resource_list_id,
1475: l_compl_rv_number,
1476: l_compl_uncategorized_flag
1477: from pa_budget_versions bv,
1478: pa_resource_lists_all_bg rl
1479: where bv.budget_version_id = ci_rec.budget_version_id and
1480: bv.resource_list_id = rl.resource_list_id;
1481: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := l_ci_budget_version_id;
1482: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := ci_rec.budget_version_id;