APPS.PA_FP_COPY_FROM_PKG dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 2269: l_control_flag pa_resource_lists_all_bg.control_flag%TYPE;

2265:
2266: l_tmp NUMBER;
2267: l_source_project_id pa_projects_all.project_id%TYPE;
2268: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2269: l_control_flag pa_resource_lists_all_bg.control_flag%TYPE;
2270: l_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
2271:
2272: l_project_org pa_projects_all.carrying_out_organization_id%TYPE; -- bug 6161031
2273:

Line 2351: pa_resource_lists_all_bg rl

2347: ,l_resource_list_id
2348: ,l_control_flag
2349: FROM pa_proj_fp_options pfot,--target
2350: pa_proj_fp_options pfos,--source
2351: pa_resource_lists_all_bg rl
2352: WHERE pfot.fin_plan_version_id=p_target_plan_version_id
2353: AND pfos.fin_plan_version_id=p_source_plan_version_id
2354: AND rl.resource_list_id=nvl(pfot.cost_resource_list_id, nvl(pfot.revenue_resource_list_id,pfot.all_resource_list_id));
2355:

Line 8740: --l_src_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE; //Commented out for Bug 4200168.

8736: --End of variables used for debugging
8737: l_module_name VARCHAR2(200) := g_module_name || '.copy_wp_budget_versions';
8738: i NUMBER;
8739: l_src_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8740: --l_src_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE; //Commented out for Bug 4200168.
8741: --l_targ_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE; //Commented out for Bug 4200168.
8742: l_adj_percentage NUMBER;
8743: l_copy_mode VARCHAR2(1) := p_copy_mode;
8744: l_shift_days NUMBER :=0;--SHOULD BE REMOVED LATER

Line 8741: --l_targ_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE; //Commented out for Bug 4200168.

8737: l_module_name VARCHAR2(200) := g_module_name || '.copy_wp_budget_versions';
8738: i NUMBER;
8739: l_src_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8740: --l_src_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE; //Commented out for Bug 4200168.
8741: --l_targ_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE; //Commented out for Bug 4200168.
8742: l_adj_percentage NUMBER;
8743: l_copy_mode VARCHAR2(1) := p_copy_mode;
8744: l_shift_days NUMBER :=0;--SHOULD BE REMOVED LATER
8745: l_targ_budget_version_id pa_budget_versions.budget_version_id%TYPE;