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_TASK_PUB1 dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 3626: FROM pa_proj_elem_ver_structure

3622:
3623: CURSOR cur_struc_id( x_structure_version_id NUMBER, x_project_id NUMBER )
3624: IS
3625: SELECT proj_element_id
3626: FROM pa_proj_elem_ver_structure
3627: WHERE element_version_id = x_structure_version_id
3628: AND project_id = x_project_id;
3629:
3630:

Line 3654: from pa_proj_elem_ver_structure

3650: We should check a structure version is and not structure id to
3651: find out a structure version is publised or not */
3652: /* CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
3653: select 'Y'
3654: from pa_proj_elem_ver_structure
3655: where proj_element_id = c_structure_id
3656: AND project_id = c_project_id
3657: and STATUS_CODE = 'STRUCTURE_PUBLISHED';
3658: */

Line 3664: from pa_proj_elem_ver_structure

3660: --bug 3074706
3661: --added project_id
3662: CURSOR cur_pub_versions( c_structure_version_id NUMBER, c_project_id NUMBER ) is
3663: select 'Y'
3664: from pa_proj_elem_ver_structure
3665: where element_version_id = c_structure_version_id
3666: and project_id = c_project_id
3667: and STATUS_CODE = 'STRUCTURE_PUBLISHED';
3668: --end bug 3074706

Line 5702: from pa_proj_elem_ver_structure

5698: AND pst.structure_type_class_code IN( 'FINANCIAL' );
5699:
5700: CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
5701: select 'Y'
5702: from pa_proj_elem_ver_structure
5703: where proj_element_id = c_structure_id
5704: AND project_id = c_project_id
5705: and STATUS_CODE = 'STRUCTURE_PUBLISHED';
5706:

Line 6314: pa_proj_elem_ver_structure ppa,

6310: --hsiu Fixed parent_structure_version_id condition
6311: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
6312: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
6313: FROM PA_TASKS pt,
6314: pa_proj_elem_ver_structure ppa,
6315: PA_PROJ_ELEMENT_VERSIONS ppev
6316: WHERE ppev.element_version_id = p_task_version_id
6317: AND ppev.project_id = ppa.project_id
6318: AND ppev.parent_structure_version_id = ppa.element_version_id

Line 6893: from pa_proj_elem_ver_structure

6889: AND pst.structure_type_class_code IN( 'FINANCIAL' );
6890:
6891: CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
6892: select 'Y'
6893: from pa_proj_elem_ver_structure
6894: where proj_element_id = c_structure_id
6895: AND project_id = c_project_id
6896: and STATUS_CODE = 'STRUCTURE_PUBLISHED';
6897:

Line 7226: pa_proj_elem_ver_structure ppa,

7222:
7223: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
7224: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
7225: FROM PA_TASKS pt,
7226: pa_proj_elem_ver_structure ppa,
7227: PA_PROJ_ELEMENT_VERSIONS ppev
7228: WHERE ppev.element_version_id = p_task_version_id
7229: AND ppev.parent_structure_version_id = ppa.element_version_id
7230: AND ppev.project_id = ppa.project_id

Line 7454: from pa_proj_elem_ver_structure

7450: AND pst.structure_type_class_code IN( 'FINANCIAL' );
7451:
7452: CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
7453: select 'Y'
7454: from pa_proj_elem_ver_structure
7455: where proj_element_id = c_structure_id
7456: AND project_id = c_project_id
7457: and STATUS_CODE = 'STRUCTURE_PUBLISHED';
7458:

Line 7707: pa_proj_elem_ver_structure ppa,

7703:
7704: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
7705: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
7706: FROM PA_TASKS pt,
7707: pa_proj_elem_ver_structure ppa,
7708: PA_PROJ_ELEMENT_VERSIONS ppev
7709: WHERE ppev.element_version_id = p_task_version_id
7710: AND ppev.parent_structure_version_id = ppa.element_version_id
7711: AND ppev.project_id = ppa.project_id

Line 9472: FROM pa_proj_elem_ver_structure

9468: SELECT 'Y'
9469: FROM dual
9470: WHERE EXISTS(
9471: SELECT 'xyz'
9472: FROM pa_proj_elem_ver_structure
9473: WHERE proj_element_id = c_structure_id
9474: AND project_id = c_project_id
9475: AND STATUS_CODE = 'STRUCTURE_PUBLISHED'
9476: );

Line 10499: pa_proj_elem_ver_structure ppa,

10495:
10496: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
10497: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
10498: FROM PA_TASKS pt,
10499: pa_proj_elem_ver_structure ppa,
10500: PA_PROJ_ELEMENT_VERSIONS ppev
10501: WHERE ppev.element_version_id = p_task_version_id
10502: AND ppev.parent_structure_version_id = ppa.element_version_id
10503: AND ppev.project_id = ppa.project_id

Line 10957: FROM pa_proj_elem_ver_structure

10953: SELECT 'Y'
10954: FROM dual
10955: WHERE EXISTS(
10956: SELECT 'xyz'
10957: FROM pa_proj_elem_ver_structure
10958: WHERE proj_element_id = c_structure_id
10959: AND project_id = c_project_id
10960: AND STATUS_CODE = 'STRUCTURE_PUBLISHED'
10961: );

Line 12116: pa_proj_elem_ver_structure ppa,

12112:
12113: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
12114: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
12115: FROM PA_TASKS pt,
12116: pa_proj_elem_ver_structure ppa,
12117: PA_PROJ_ELEMENT_VERSIONS ppev
12118: WHERE ppev.element_version_id = p_task_version_id
12119: AND ppev.parent_structure_version_id = ppa.element_version_id
12120: AND ppev.project_id = ppa.project_id

Line 12666: FROM pa_proj_elem_ver_structure

12662:
12663: -- below cursors are the same as those used currently in the flow
12664: CURSOR get_project_id(c_structure_version_id IN NUMBER) IS
12665: SELECT project_id
12666: FROM pa_proj_elem_ver_structure
12667: WHERE element_version_id = c_structure_version_id;
12668:
12669: CURSOR planned_effort_exists(c_element_version_id IN NUMBER) IS
12670: SELECT 'Y'

Line 15257: FROM pa_proj_elem_ver_structure

15253:
15254: CURSOR cur_struc_id( x_structure_version_id NUMBER, x_project_id NUMBER )
15255: IS
15256: SELECT proj_element_id
15257: FROM pa_proj_elem_ver_structure
15258: WHERE element_version_id = x_structure_version_id
15259: AND project_id = x_project_id;
15260:
15261: CURSOR get_product_code ( c_project_id NUMBER ) IS

Line 15722: from pa_proj_elem_ver_structure

15718: AND pst.structure_type_class_code = 'FINANCIAL' ;
15719:
15720: CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
15721: select 'Y'
15722: from pa_proj_elem_ver_structure
15723: where proj_element_id = c_structure_id
15724: AND project_id = c_project_id
15725: and STATUS_CODE = 'STRUCTURE_PUBLISHED';
15726:

Line 16376: -- 4533534 : Included join of pa_proj_elem_ver_structure too

16372: l_debug_mode VARCHAR2(1);
16373: l_module_name VARCHAR2(100):= 'PA_TASK_PUB1.CANCEL_TASK';
16374: l_error_message_code VARCHAR2(32);
16375:
16376: -- 4533534 : Included join of pa_proj_elem_ver_structure too
16377: CURSOR c_get_all_task_versions(c_task_id NUMBER, c_project_id NUMBER) IS
16378: SELECT ver.element_version_id, str.status_code
16379: FROM pa_proj_element_versions ver
16380: , pa_proj_elem_ver_structure str

Line 16380: , pa_proj_elem_ver_structure str

16376: -- 4533534 : Included join of pa_proj_elem_ver_structure too
16377: CURSOR c_get_all_task_versions(c_task_id NUMBER, c_project_id NUMBER) IS
16378: SELECT ver.element_version_id, str.status_code
16379: FROM pa_proj_element_versions ver
16380: , pa_proj_elem_ver_structure str
16381: WHERE ver.project_id = c_project_id
16382: AND ver.proj_element_id = c_task_id
16383: AND ver.project_id = str.project_id
16384: and ver.parent_structure_version_id = str.element_version_id