DBA Data[Home] [Help]

APPS.PA_FP_VIEW_PLANS_TXN_PUB dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 419: pa_resource_lists_all_bg rl

415: l_rv_number,
416: l_uncategorized_flag,
417: l_c_budget_status_code
418: FROM pa_budget_versions bv,
419: pa_resource_lists_all_bg rl
420: WHERE bv.budget_version_id = p_cost_version_id and
421: bv.resource_list_id = rl.resource_list_id;
422:
423:

Line 462: pa_resource_lists_all_bg rl

458: l_compl_rv_number,
459: l_compl_uncategorized_flag,
460: l_r_budget_status_code
461: FROM pa_budget_versions bv,
462: pa_resource_lists_all_bg rl
463: WHERE bv.budget_version_id = p_rev_version_id and
464: bv.resource_list_id = rl.resource_list_id;
465:
466:

Line 961: pa_resource_lists_all_bg rl

957: l_ac_flag,
958: l_ar_flag,
959: l_uncategorized_flag
960: from pa_budget_versions bv,
961: pa_resource_lists_all_bg rl
962: where bv.budget_version_id = p_budget_version_id and
963: bv.resource_list_id = rl.resource_list_id;
964: pa_fp_view_plans_txn_pub.G_SINGLE_VERSION_ID := p_budget_version_id;
965: -- >>>>> BUG FIX 2602849: need to check only AR flag <<<<<

Line 2516: pa_resource_lists_all_bg rl

2512: l_ar_flag,
2513: l_uncategorized_flag,
2514: l_agreement_id
2515: from pa_budget_versions bv,
2516: pa_resource_lists_all_bg rl
2517: where bv.budget_version_id = ci_rec.budget_version_id and
2518: bv.resource_list_id = rl.resource_list_id;
2519:
2520: -- >>>> BUG FIX 2650878: project or projfunc, depending on AR flag <<<<

Line 2681: pa_resource_lists_all_bg rl

2677: l_compl_resource_list_id,
2678: l_compl_rv_number,
2679: l_compl_uncategorized_flag
2680: from pa_budget_versions bv,
2681: pa_resource_lists_all_bg rl
2682: where bv.budget_version_id = ci_rec.budget_version_id and
2683: bv.resource_list_id = rl.resource_list_id;
2684: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2685: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := ci_rec.budget_version_id;

Line 2739: pa_resource_lists_all_bg rl

2735: l_compl_resource_list_id,
2736: l_compl_rv_number,
2737: l_compl_uncategorized_flag
2738: from pa_budget_versions bv,
2739: pa_resource_lists_all_bg rl
2740: where bv.budget_version_id = ci_rec.budget_version_id and
2741: bv.resource_list_id = rl.resource_list_id;
2742: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := ci_rec.budget_version_id;
2743: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;

Line 2806: pa_resource_lists_all_bg rl

2802: l_compl_resource_list_id,
2803: l_compl_rv_number,
2804: l_compl_uncategorized_flag
2805: from pa_budget_versions bv,
2806: pa_resource_lists_all_bg rl
2807: where bv.budget_version_id = ci_rec.budget_version_id and
2808: bv.resource_list_id = rl.resource_list_id;
2809: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := ci_rec.budget_version_id;
2810: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;

Line 2872: pa_resource_lists_all_bg rl

2868: l_compl_resource_list_id,
2869: l_compl_rv_number,
2870: l_compl_uncategorized_flag
2871: from pa_budget_versions bv,
2872: pa_resource_lists_all_bg rl
2873: where bv.budget_version_id = ci_rec.budget_version_id and
2874: bv.resource_list_id = rl.resource_list_id;
2875: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2876: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := ci_rec.budget_version_id;