APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 122: from pa_proj_element_versions pe

118: CURSOR C_Task_Elem_Version_Id(p_structure_version_id IN NUMBER,
119: p_task_id in NUMBER,
120: p_project_id IN NUMBER) IS
121: SELECT pe.element_version_id
122: from pa_proj_element_versions pe
123: where parent_structure_version_id = p_structure_version_id
124: and pe.proj_element_id = p_task_id
125: and pe.project_id = p_project_id;
126:

Line 129: from pa_proj_element_versions pe

125: and pe.project_id = p_project_id;
126:
127: CURSOR C_task_version(p_task_element_version_id IN NUMBER) IS
128: SELECT pe.element_version_id, pe.proj_element_id
129: from pa_proj_element_versions pe
130: where pe.element_version_id = p_task_element_version_id;
131:
132: -- Bug# 6432606 Start
133: /*

Line 144: pa_proj_element_versions ppv,

140: -- Commented above and added below for Bug 6432606
141: CURSOR C_Prog_Date(p_resource_assignment_id IN NUMBER) IS
142: select ppr.as_of_date
143: from pa_progress_rollup ppr,
144: pa_proj_element_versions ppv,
145: pa_resource_assignments pra
146: where ppv.parent_structure_version_id=p_pa_structure_version_id
147: and ppv.project_id=p_pa_project_id
148: and pra.resource_assignment_id=p_resource_assignment_id

Line 1525: ,p_task_version_id IN PA_PROJ_ELEMENT_VERSIONS.element_version_id%TYPE

1521: * rlm is not passed into the API.
1522: **********************************************************************/
1523: PROCEDURE Derive_Task_Assignments
1524: ( p_project_id IN PA_PROJECTS_ALL.project_id%TYPE
1525: ,p_task_version_id IN PA_PROJ_ELEMENT_VERSIONS.element_version_id%TYPE
1526: ,p_scheduled_start IN DATE
1527: ,p_scheduled_end IN DATE
1528: ,p_resource_class_code IN PA_RESOURCE_LIST_MEMBERS.resource_class_code%TYPE
1529: ,p_resource_list_member_id IN PA_RESOURCE_LIST_MEMBERS.resource_list_member_id%TYPE

Line 1572: pa_proj_element_versions ev,

1568:
1569: CURSOR get_budget_version_id IS
1570: SELECT bv.budget_version_id
1571: FROM pa_budget_versions bv,
1572: pa_proj_element_versions ev,
1573: pa_proj_elem_ver_structure evs
1574: WHERE bv.project_id = p_project_id
1575: AND bv.wp_version_flag = 'Y'
1576: AND bv.project_structure_version_id = evs.element_version_id

Line 1584: FROM pa_proj_element_versions ev

1580: AND ev.parent_structure_version_id = evs.element_version_id;
1581:
1582: CURSOR get_struct_version_id IS
1583: SELECT ev.parent_structure_version_id
1584: FROM pa_proj_element_versions ev
1585: WHERE ev.project_id = p_project_id
1586: AND ev.element_version_id = p_task_version_id;
1587:
1588: CURSOR get_txn_cur_code(c_resource_assignment_id NUMBER) IS

Line 1901: pa_proj_element_versions pev,

1897: 'Y',
1898: ra_old.ta_display_flag
1899: FROM
1900: pa_resource_assignments ra_old,
1901: pa_proj_element_versions pev,
1902: pa_proj_elem_ver_schedule pevs
1903: WHERE
1904: ra_old.budget_version_id = old_budget_version_id AND
1905: PA_PROGRESS_UTILS.Check_Prog_Exists_And_Delete