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

Line 3613: FROM pa_tasks pt, pa_proj_element_versions ppev

3609: AND wbs_level = p_wbs_level
3610: AND display_sequence < p_display_sequence );*/
3611: --Project Structure changes
3612: SELECT task_id, top_task_id
3613: FROM pa_tasks pt, pa_proj_element_versions ppev
3614: WHERE pt.wbs_level = p_wbs_level
3615: AND top_task_id = p_top_task_id_above
3616: AND pt.task_id = ppev.proj_element_id
3617: AND ppev.display_sequence = ( SELECT max( ppev.display_sequence )

Line 3618: FROM pa_tasks pt, pa_proj_element_versions ppev

3614: WHERE pt.wbs_level = p_wbs_level
3615: AND top_task_id = p_top_task_id_above
3616: AND pt.task_id = ppev.proj_element_id
3617: AND ppev.display_sequence = ( SELECT max( ppev.display_sequence )
3618: FROM pa_tasks pt, pa_proj_element_versions ppev
3619: WHERE top_task_id = p_top_task_id_above
3620: AND pt.wbs_level = p_wbs_level
3621: AND ppev.proj_element_id = pt.task_id
3622: AND ppev.display_sequence < p_display_sequence );

Line 4001: FROM pa_tasks pt, pa_proj_element_versions ppev

3997: AND display_sequence > p_display_sequence;*/
3998:
3999: --Project Structure changes
4000: SELECT pt.task_id, pt.record_version_number
4001: FROM pa_tasks pt, pa_proj_element_versions ppev
4002: WHERE top_task_id = p_top_task_id
4003: AND pt.task_id = ppev.proj_element_id
4004: AND ppev.display_sequence >= p_display_sequence; --bug 2968468
4005:

Line 4019: FROM pa_tasks pt, pa_proj_element_versions ppev

4015: AND project_id = p_project_id
4016: AND display_sequence > p_display_sequence;*/
4017:
4018: SELECT pt.task_id, pt.record_version_number
4019: FROM pa_tasks pt, pa_proj_element_versions ppev
4020: WHERE pt.wbs_level = p_wbs_level
4021: AND parent_task_id = l_parent_task_id
4022: AND pt.project_id = p_project_id
4023: AND pt.task_id = ppev.proj_element_id

Line 4648: FROM pa_tasks pt, pa_proj_element_versions ppev

4644: pt.work_type_id, pt.service_type_code,
4645: pt.chargeable_flag, pt.billable_flag, pt.receive_project_invoice_flag,
4646: pt.scheduled_start_date, pt.scheduled_finish_date, pt.start_date,
4647: pt.wbs_level, pt.task_id, ppev.display_sequence
4648: FROM pa_tasks pt, pa_proj_element_versions ppev
4649: WHERE pt.project_id = p_project_id
4650: AND pt.task_id = ppev.proj_element_id
4651: ORDER BY ppev.display_sequence;
4652:

Line 5306: pa_proj_element_versions ppev

5302: FROM pa_tasks
5303: WHERE project_id = p_project_id
5304: START WITH task_id = p_task_id
5305: CONNECT BY PRIOR task_id = parent_task_id ) pt,
5306: pa_proj_element_versions ppev
5307: WHERE pt.task_id = ppev.proj_element_id
5308: ORDER BY ppev.display_sequence;
5309:
5310: CURSOR cur_ref_info

Line 5678: CONNECT BY PRIOR task_id = parent_task_id ) pt, pa_proj_element_versions ppev

5674: ( SELECT task_id, top_task_id, parent_task_id, wbs_level, record_version_number
5675: FROM pa_tasks
5676: WHERE project_id = p_project_id
5677: START WITH task_id = p_task_id
5678: CONNECT BY PRIOR task_id = parent_task_id ) pt, pa_proj_element_versions ppev
5679: WHERE pt.task_id = ppev.proj_element_id
5680: ORDER BY ppev.display_sequence;
5681:
5682: CURSOR cur_ref_info

Line 5697: CONNECT BY PRIOR task_id = parent_task_id ) pt, pa_proj_element_versions ppev

5693: ( SELECT task_id, top_task_id, parent_task_id, wbs_level
5694: FROM pa_tasks
5695: WHERE project_id = p_reference_project_id
5696: START WITH task_id = p_reference_task_id
5697: CONNECT BY PRIOR task_id = parent_task_id ) pt, pa_proj_element_versions ppev
5698: WHERE pt.task_id = ppev.proj_element_id
5699: ORDER BY ppev.display_sequence;
5700:
5701:

Line 6042: -- : This Api is to set unset the financial_task_flag in pa_proj_element_versions table.

6038: --Begin add by rtarway for FP.M development
6039: -- Procedure : SET_UNSET_FINANCIAL_TASK
6040: -- Type : Public Procedure
6041: -- Purpose : This API will be called from set financial tasks page in financial tab
6042: -- : This Api is to set unset the financial_task_flag in pa_proj_element_versions table.
6043:
6044: -- Note :
6045: -- :
6046: -- :

Line 6092: pa_proj_element_versions

6088: IS
6089: SELECT
6090: proj_element_id
6091: FROM
6092: pa_proj_element_versions
6093: WHERE
6094: project_id = l_project_id
6095: AND
6096: element_version_id = l_task_version_id;

Line 6216: PA_PROJ_ELEMENT_VERSIONS

6212: --Not using table handler as only one field needs to be updated.
6213:
6214:
6215: UPDATE
6216: PA_PROJ_ELEMENT_VERSIONS
6217: SET
6218: financial_task_flag = p_checked_flag
6219: WHERE
6220: element_version_id = p_task_version_id

Line 6394: pa_proj_element_versions

6390: IS
6391: SELECT
6392: proj_element_id
6393: FROM
6394: pa_proj_element_versions
6395: WHERE
6396: element_version_id = l_element_version_id
6397: AND
6398: project_id = l_project_id;

Line 6417: pa_proj_element_versions elever

6413: IS
6414: SELECT
6415: elever.proj_element_id
6416: FROM
6417: pa_proj_element_versions elever
6418: , pa_object_relationships obRel
6419: WHERE
6420: obRel.relationship_type ='S'
6421: AND

Line 6439: , pa_proj_element_versions elever

6435: , elements.element_number
6436:
6437: FROM
6438: pa_proj_elements elements
6439: , pa_proj_element_versions elever
6440: WHERE
6441: elever.element_version_id = l_element_version_id
6442: AND
6443: elever.project_id = l_project_id

Line 6467: pa_proj_element_versions

6463: SELECT
6464: element_version_id
6465: ,financial_task_flag
6466: FROM
6467: pa_proj_element_versions
6468: WHERE
6469: parent_structure_version_id = l_structure_version_id
6470: AND
6471: object_type='PA_TASKS'