APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 136: from pa_proj_element_versions pe

132: CURSOR C_Task_Elem_Version_Id(p_structure_version_id IN NUMBER,
133: p_task_id in NUMBER,
134: p_project_id IN NUMBER) IS
135: SELECT pe.element_version_id
136: from pa_proj_element_versions pe
137: where parent_structure_version_id = p_structure_version_id
138: and pe.proj_element_id = p_task_id
139: and pe.project_id = p_project_id;
140:

Line 143: from pa_proj_element_versions pe

139: and pe.project_id = p_project_id;
140:
141: CURSOR C_task_version(p_task_element_version_id IN NUMBER) IS
142: SELECT pe.element_version_id, pe.proj_element_id
143: from pa_proj_element_versions pe
144: where pe.element_version_id = p_task_element_version_id;
145:
146: -- Bug# 6432606 Start
147: /*

Line 159: pa_proj_element_versions ppv,

155: /*
156: CURSOR C_Prog_Date(p_resource_assignment_id IN NUMBER) IS
157: select ppr.as_of_date
158: from pa_progress_rollup ppr,
159: pa_proj_element_versions ppv,
160: pa_resource_assignments pra
161: where ppv.parent_structure_version_id=p_pa_structure_version_id
162: and ppv.project_id=p_pa_project_id
163: and pra.resource_assignment_id=p_resource_assignment_id

Line 1739: ,p_task_version_id IN PA_PROJ_ELEMENT_VERSIONS.element_version_id%TYPE

1735: **********************************************************************/
1736: PROCEDURE Derive_Task_Assignments
1737: ( p_project_id IN PA_PROJECTS_ALL.project_id%TYPE
1738: ,p_extraction_type IN VARCHAR2 DEFAULT NULL -- Added for bug 13419867
1739: ,p_task_version_id IN PA_PROJ_ELEMENT_VERSIONS.element_version_id%TYPE
1740: ,p_scheduled_start IN DATE
1741: ,p_scheduled_end IN DATE
1742: ,p_resource_class_code IN PA_RESOURCE_LIST_MEMBERS.resource_class_code%TYPE
1743: ,p_resource_list_member_id IN PA_RESOURCE_LIST_MEMBERS.resource_list_member_id%TYPE

Line 1796: pa_proj_element_versions ev,

1792:
1793: CURSOR get_budget_version_id IS
1794: SELECT bv.budget_version_id
1795: FROM pa_budget_versions bv,
1796: pa_proj_element_versions ev,
1797: pa_proj_elem_ver_structure evs
1798: WHERE bv.project_id = p_project_id
1799: AND bv.wp_version_flag = 'Y'
1800: AND bv.project_structure_version_id = evs.element_version_id

Line 1808: FROM pa_proj_element_versions ev

1804: AND ev.parent_structure_version_id = evs.element_version_id;
1805:
1806: CURSOR get_struct_version_id IS
1807: SELECT ev.parent_structure_version_id
1808: FROM pa_proj_element_versions ev
1809: WHERE ev.project_id = p_project_id
1810: AND ev.element_version_id = p_task_version_id;
1811:
1812: CURSOR get_txn_cur_code(c_resource_assignment_id NUMBER) IS

Line 2138: pa_proj_element_versions pev,

2134: ra_old.ta_display_flag,
2135: ra_old.cbs_element_id -- Added for 16200605
2136: FROM
2137: pa_resource_assignments ra_old,
2138: pa_proj_element_versions pev,
2139: pa_proj_elem_ver_schedule pevs
2140: WHERE
2141: ra_old.budget_version_id = old_budget_version_id AND
2142: PA_PROGRESS_UTILS.Check_Prog_Exists_And_Delete