756: l_resource_list_id := FND_PROFILE.VALUE('PA_FORECAST_RESOURCE_LIST');
757:
758: SELECT rlm.resource_list_member_id
759: INTO l_resource_list_member_id
760: FROM pa_resource_list_members rlm
761: WHERE rlm.resource_list_id = l_resource_list_id
762: AND rlm.resource_type_code = 'UNCATEGORIZED';
763: EXCEPTION
764: WHEN OTHERS THEN
4361: ,target_rlm.resource_list_member_id -- bug 3615617 TARGET_RLM_ID
4362: FROM pa_resource_assignments pra
4363: ,pa_tasks source_tasks
4364: ,pa_tasks target_tasks
4365: ,pa_resource_list_members source_rlm -- bug 3615617
4366: ,pa_resource_list_members target_rlm -- bug 3615617
4367: WHERE pra.budget_version_id = p_source_plan_version_id
4368: AND pra.project_id = p_source_project_id --bug#2708524
4369: AND source_tasks.task_id = pra.task_id
4362: FROM pa_resource_assignments pra
4363: ,pa_tasks source_tasks
4364: ,pa_tasks target_tasks
4365: ,pa_resource_list_members source_rlm -- bug 3615617
4366: ,pa_resource_list_members target_rlm -- bug 3615617
4367: WHERE pra.budget_version_id = p_source_plan_version_id
4368: AND pra.project_id = p_source_project_id --bug#2708524
4369: AND source_tasks.task_id = pra.task_id
4370: AND source_tasks.task_number = target_tasks.task_number
4402: ,planning_end_date + l_shift_days -- SCHEDULE_END_DATE
4403: --End of Changes for bug 3354518
4404: ,target_rlm.resource_list_member_id -- bug 3615617 TARGET_RLM_ID
4405: FROM pa_resource_assignments pra
4406: ,pa_resource_list_members source_rlm -- bug 3615617
4407: ,pa_resource_list_members target_rlm -- bug 3615617
4408: WHERE pra.budget_version_id = p_source_plan_version_id
4409: AND pra.task_id = 0
4410: AND source_rlm.resource_list_member_id = pra.resource_list_member_id -- bug 3615617
4403: --End of Changes for bug 3354518
4404: ,target_rlm.resource_list_member_id -- bug 3615617 TARGET_RLM_ID
4405: FROM pa_resource_assignments pra
4406: ,pa_resource_list_members source_rlm -- bug 3615617
4407: ,pa_resource_list_members target_rlm -- bug 3615617
4408: WHERE pra.budget_version_id = p_source_plan_version_id
4409: AND pra.task_id = 0
4410: AND source_rlm.resource_list_member_id = pra.resource_list_member_id -- bug 3615617
4411: AND target_rlm.resource_list_id = source_rlm.resource_list_id -- bug 3615617