eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROGRESS_PVT dependencies on PA_RESOURCE_ASSIGNMENTS

Line 888: from pa_resource_assignments a

884: , a.resource_assignment_id
885: , a.total_plan_quantity planned_quantity
886: , a.total_project_burdened_cost planned_bur_cost_proj_cur
887: , a.resource_list_member_id
888: from pa_resource_assignments a
889: WHERE a.wbs_element_version_id = c_task_ver_id
890: AND a.project_id = p_project_id
891: AND a.task_id = c_task_id
892: -- AND a.ta_display_flag = 'Y' --Bug 4323537

Line 9783: FROM pa_resource_assignments source,

9779: ,bl.start_date START_DATE
9780: ,bl.end_date END_DATE
9781: ,source.resource_list_member_id RESOURCE_LIST_MEMBER_ID
9782: ,source.cbs_element_id CBS_ELEMENT_ID
9783: FROM pa_resource_assignments source,
9784: pa_resource_assignments target,
9785: pa_budget_lines bl
9786: WHERE bl.resource_assignment_id = source.resource_assignment_id
9787: and source.budget_version_id = c_budget_version_id

Line 9784: pa_resource_assignments target,

9780: ,bl.end_date END_DATE
9781: ,source.resource_list_member_id RESOURCE_LIST_MEMBER_ID
9782: ,source.cbs_element_id CBS_ELEMENT_ID
9783: FROM pa_resource_assignments source,
9784: pa_resource_assignments target,
9785: pa_budget_lines bl
9786: WHERE bl.resource_assignment_id = source.resource_assignment_id
9787: and source.budget_version_id = c_budget_version_id
9788: and target.budget_version_id = t_budget_version_id

Line 10068: FROM pa_resource_assignments source,

10064: ,NULL ATTRIBUTE3
10065: ,NULL ATTRIBUTE4
10066: ,NULL ATTRIBUTE5
10067: ,NULL ATTRIBUTE6
10068: FROM pa_resource_assignments source,
10069: pa_budget_lines bl,
10070: pa_resource_assignments target
10071: WHERE bl.budget_version_id = l_source_str_ver_info_rec.budget_version_id
10072: and bl.resource_assignment_id = source.resource_assignment_id

Line 10070: pa_resource_assignments target

10066: ,NULL ATTRIBUTE5
10067: ,NULL ATTRIBUTE6
10068: FROM pa_resource_assignments source,
10069: pa_budget_lines bl,
10070: pa_resource_assignments target
10071: WHERE bl.budget_version_id = l_source_str_ver_info_rec.budget_version_id
10072: and bl.resource_assignment_id = source.resource_assignment_id
10073: AND target.budget_version_id = l_target_str_ver_info_rec.budget_version_id
10074: AND target.task_id = source.task_id

Line 11399: from pa_resource_assignments a

11395: , a.resource_assignment_id
11396: , a.total_plan_quantity planned_quantity
11397: , a.total_project_burdened_cost planned_bur_cost_proj_cur
11398: , a.resource_list_member_id
11399: from pa_resource_assignments a
11400: WHERE a.wbs_element_version_id = c_task_ver_id
11401: AND a.project_id = p_project_id
11402: AND a.task_id = c_task_id
11403: -- AND a.ta_display_flag = 'Y' --Bug 4323537

Line 14959: from pa_resource_assignments a

14955: , a.resource_assignment_id
14956: , a.total_plan_quantity planned_quantity
14957: , a.total_project_burdened_cost planned_bur_cost_proj_cur
14958: , a.resource_list_member_id
14959: from pa_resource_assignments a
14960: WHERE a.wbs_element_version_id = c_task_ver_id
14961: AND 1 = 2 -- sridhar_rollup
14962: AND a.project_id = p_project_id
14963: AND a.task_id = c_task_id