DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_RESOURCE_LIST_MEMBERS

Line 759: FROM pa_resource_list_members rlm

755: l_resource_list_id := FND_PROFILE.VALUE('PA_FORECAST_RESOURCE_LIST');
756:
757: SELECT rlm.resource_list_member_id
758: INTO l_resource_list_member_id
759: FROM pa_resource_list_members rlm
760: WHERE rlm.resource_list_id = l_resource_list_id
761: AND rlm.resource_type_code = 'UNCATEGORIZED';
762: EXCEPTION
763: WHEN OTHERS THEN

Line 4364: ,pa_resource_list_members source_rlm -- bug 3615617

4360: ,target_rlm.resource_list_member_id -- bug 3615617 TARGET_RLM_ID
4361: FROM pa_resource_assignments pra
4362: ,pa_tasks source_tasks
4363: ,pa_tasks target_tasks
4364: ,pa_resource_list_members source_rlm -- bug 3615617
4365: ,pa_resource_list_members target_rlm -- bug 3615617
4366: WHERE pra.budget_version_id = p_source_plan_version_id
4367: AND pra.project_id = p_source_project_id --bug#2708524
4368: AND source_tasks.task_id = pra.task_id

Line 4365: ,pa_resource_list_members target_rlm -- bug 3615617

4361: FROM pa_resource_assignments pra
4362: ,pa_tasks source_tasks
4363: ,pa_tasks target_tasks
4364: ,pa_resource_list_members source_rlm -- bug 3615617
4365: ,pa_resource_list_members target_rlm -- bug 3615617
4366: WHERE pra.budget_version_id = p_source_plan_version_id
4367: AND pra.project_id = p_source_project_id --bug#2708524
4368: AND source_tasks.task_id = pra.task_id
4369: AND source_tasks.task_number = target_tasks.task_number

Line 4405: ,pa_resource_list_members source_rlm -- bug 3615617

4401: ,planning_end_date + l_shift_days -- SCHEDULE_END_DATE
4402: --End of Changes for bug 3354518
4403: ,target_rlm.resource_list_member_id -- bug 3615617 TARGET_RLM_ID
4404: FROM pa_resource_assignments pra
4405: ,pa_resource_list_members source_rlm -- bug 3615617
4406: ,pa_resource_list_members target_rlm -- bug 3615617
4407: WHERE pra.budget_version_id = p_source_plan_version_id
4408: AND pra.task_id = 0
4409: AND source_rlm.resource_list_member_id = pra.resource_list_member_id -- bug 3615617

Line 4406: ,pa_resource_list_members target_rlm -- bug 3615617

4402: --End of Changes for bug 3354518
4403: ,target_rlm.resource_list_member_id -- bug 3615617 TARGET_RLM_ID
4404: FROM pa_resource_assignments pra
4405: ,pa_resource_list_members source_rlm -- bug 3615617
4406: ,pa_resource_list_members target_rlm -- bug 3615617
4407: WHERE pra.budget_version_id = p_source_plan_version_id
4408: AND pra.task_id = 0
4409: AND source_rlm.resource_list_member_id = pra.resource_list_member_id -- bug 3615617
4410: AND target_rlm.resource_list_id = source_rlm.resource_list_id -- bug 3615617