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_TASKS_MAINT_UTILS dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 1547: FROM pa_tasks pt, pa_proj_element_versions ppev

1543: --WITH THE CHANGE IN THE DATA MODEL p_task_id will from now act as p_task_version_id
1544: CURSOR cur_wbs_above
1545: IS
1546: SELECT pt.wbs_level, pt.task_id, pt.top_task_id, pt.parent_task_id, ppev.display_sequence
1547: FROM pa_tasks pt, pa_proj_element_versions ppev
1548: WHERE pt.project_id = p_project_id
1549: AND ppev.proj_element_id = pt.task_id
1550: AND ppev.display_sequence = ( SELECT max( display_sequence )
1551: FROM pa_proj_element_versions

Line 1551: FROM pa_proj_element_versions

1547: FROM pa_tasks pt, pa_proj_element_versions ppev
1548: WHERE pt.project_id = p_project_id
1549: AND ppev.proj_element_id = pt.task_id
1550: AND ppev.display_sequence = ( SELECT max( display_sequence )
1551: FROM pa_proj_element_versions
1552: WHERE project_id = p_project_id
1553: AND display_sequence < ( SELECT display_sequence
1554: FROM pa_proj_element_versions
1555: WHERE project_id = p_project_id

Line 1554: FROM pa_proj_element_versions

1550: AND ppev.display_sequence = ( SELECT max( display_sequence )
1551: FROM pa_proj_element_versions
1552: WHERE project_id = p_project_id
1553: AND display_sequence < ( SELECT display_sequence
1554: FROM pa_proj_element_versions
1555: WHERE project_id = p_project_id
1556: AND proj_element_id = p_task_id ) );
1557: ---Get the wbs of the task being indented.
1558: /* CURSOR cur_wbs

Line 1568: FROM pa_tasks pt, pa_proj_element_versions ppev

1564:
1565: CURSOR cur_wbs
1566: IS
1567: SELECT pt.wbs_level, pt.top_task_id, pt.parent_task_id, ppev.display_sequence
1568: FROM pa_tasks pt, pa_proj_element_versions ppev
1569: WHERE pt.project_id = p_project_id
1570: AND ppev.proj_element_id = p_task_id
1571: AND ppev.proj_element_id = pt.task_id;
1572:

Line 2183: FROM PA_PROJ_ELEMENT_VERSIONS plv

2179:
2180: CURSOR c_get_fin_task_flag (l_task_version_id NUMBER )
2181: IS
2182: SELECT FINANCIAL_TASK_FLAG
2183: FROM PA_PROJ_ELEMENT_VERSIONS plv
2184: WHERE plv.ELEMENT_VERSION_ID = l_task_version_id;
2185:
2186: BEGIN
2187:

Line 2296: l_task_id pa_proj_element_versions.element_version_id%TYPE;

2292: l_msg_data VARCHAR2(2000);
2293: l_msg_index_out NUMBER;
2294: l_debug_mode VARCHAR2(1);
2295: l_counter NUMBER := 1;
2296: l_task_id pa_proj_element_versions.element_version_id%TYPE;
2297: l_fin_flag VARCHAR2(1);
2298:
2299: l_debug_level2 CONSTANT NUMBER := 2;
2300: l_debug_level3 CONSTANT NUMBER := 3;

Line 2317: FROM PA_PROJ_ELEMENT_VERSIONS plv

2313: (
2314: SELECT proj_element_id
2315: , element_version_id
2316: , financial_task_flag
2317: FROM PA_PROJ_ELEMENT_VERSIONS plv
2318: WHERE element_version_id
2319: IN
2320: ( -- This select statement tries to select childs task version ids
2321: SELECT object_id_to1