DBA Data[Home] [Help]

APPS.PA_PROGRESS_PVT dependencies on PA_RESOURCE_ASSIGNMENTS

Line 883: from pa_resource_assignments a

879: , a.resource_assignment_id
880: , a.total_plan_quantity planned_quantity
881: , a.total_project_burdened_cost planned_bur_cost_proj_cur
882: , a.resource_list_member_id
883: from pa_resource_assignments a
884: WHERE a.wbs_element_version_id = c_task_ver_id
885: AND a.project_id = p_project_id
886: AND a.task_id = c_task_id
887: -- AND a.ta_display_flag = 'Y' --Bug 4323537

Line 9716: FROM pa_resource_assignments source,

9712: ,bl.init_raw_cost ACTUAL_RAWCOST_FC
9713: ,bl.start_date START_DATE
9714: ,bl.end_date END_DATE
9715: ,source.resource_list_member_id RESOURCE_LIST_MEMBER_ID
9716: FROM pa_resource_assignments source,
9717: pa_resource_assignments target,
9718: pa_budget_lines bl
9719: WHERE bl.resource_assignment_id = source.resource_assignment_id
9720: and source.budget_version_id = c_budget_version_id

Line 9717: pa_resource_assignments target,

9713: ,bl.start_date START_DATE
9714: ,bl.end_date END_DATE
9715: ,source.resource_list_member_id RESOURCE_LIST_MEMBER_ID
9716: FROM pa_resource_assignments source,
9717: pa_resource_assignments target,
9718: pa_budget_lines bl
9719: WHERE bl.resource_assignment_id = source.resource_assignment_id
9720: and source.budget_version_id = c_budget_version_id
9721: and target.budget_version_id = t_budget_version_id

Line 10000: FROM pa_resource_assignments source,

9996: ,NULL ATTRIBUTE3
9997: ,NULL ATTRIBUTE4
9998: ,NULL ATTRIBUTE5
9999: ,NULL ATTRIBUTE6
10000: FROM pa_resource_assignments source,
10001: pa_budget_lines bl,
10002: pa_resource_assignments target
10003: WHERE bl.budget_version_id = l_source_str_ver_info_rec.budget_version_id
10004: and bl.resource_assignment_id = source.resource_assignment_id

Line 10002: pa_resource_assignments target

9998: ,NULL ATTRIBUTE5
9999: ,NULL ATTRIBUTE6
10000: FROM pa_resource_assignments source,
10001: pa_budget_lines bl,
10002: pa_resource_assignments target
10003: WHERE bl.budget_version_id = l_source_str_ver_info_rec.budget_version_id
10004: and bl.resource_assignment_id = source.resource_assignment_id
10005: AND target.budget_version_id = l_target_str_ver_info_rec.budget_version_id
10006: AND target.task_id = source.task_id