DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_RESOURCE_LIST_MEMBERS

Line 760: FROM pa_resource_list_members rlm

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

Line 4365: ,pa_resource_list_members source_rlm -- bug 3615617

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

Line 4366: ,pa_resource_list_members target_rlm -- bug 3615617

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

Line 4406: ,pa_resource_list_members source_rlm -- bug 3615617

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

Line 4407: ,pa_resource_list_members target_rlm -- 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