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_PROJ_TASK_STRUC_PUB dependencies on PA_STRUCTURE_TYPES

Line 309: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b

305:
306: CURSOR cur_pa_proj_elem_vers2( c_strcu_ver_id NUMBER )
307: IS
308: SELECT 'x'
309: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
310: WHERE c.project_id = p_project_id
311: AND a.structure_type_id = b.structure_type_id
312: AND b.proj_element_id = c.proj_element_id
313: AND a.structure_type = 'WORKPLAN'

Line 331: pa_structure_types c

327: CURSOR get_structure(c_project_id NUMBER, c_struc_type VARCHAR2) IS
328: select a.proj_element_id
329: from pa_proj_elements a,
330: pa_proj_structure_types b,
331: pa_structure_types c
332: where a.project_id = c_project_id
333: and c.structure_type_class_code = c_struc_type
334: and c.structure_type_id = b.structure_type_id
335: and b.proj_element_id = a.proj_element_id;

Line 364: pa_structure_types pst

360: IS
361: SELECT ppev.element_version_id
362: FROM pa_proj_element_versions ppev,
363: pa_proj_structure_types ppst,
364: pa_structure_types pst
365: WHERE ppev.project_id = p_project_id
366: AND ppev.object_type = 'PA_STRUCTURES'
367: AND ppev.proj_element_id = ppst.proj_element_id
368: AND pst.structure_type_id = ppst.structure_type_id

Line 829: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b

825:
826: CURSOR cur_pa_proj_elem_vers2( c_task_version_id NUMBER )
827: IS
828: SELECT 'x'
829: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
830: WHERE c.project_id = p_project_id
831: AND a.structure_type_id = b.structure_type_id
832: AND b.proj_element_id = c.proj_element_id
833: AND a.structure_type = 'WORKPLAN'

Line 883: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b

879:
880: CURSOR cur_struc_ver_fin
881: IS
882: SELECT c.element_version_id
883: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
884: ,pa_proj_elem_ver_structure d
885: WHERE c.project_id = p_project_id
886: AND a.structure_type_id = b.structure_type_id
887: AND b.proj_element_id = c.proj_element_id

Line 901: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b

897:
898: CURSOR cur_struc_ver_wp
899: IS
900: SELECT c.element_version_id
901: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
902: ,pa_proj_elem_ver_structure d
903: WHERE c.project_id = p_project_id
904: AND a.structure_type_id = b.structure_type_id
905: AND b.proj_element_id = c.proj_element_id

Line 917: pa_structure_types c

913: CURSOR get_structure(c_project_id NUMBER, c_struc_type VARCHAR2) IS
914: select a.proj_element_id
915: from pa_proj_elements a,
916: pa_proj_structure_types b,
917: pa_structure_types c
918: where a.project_id = c_project_id
919: and c.structure_type_class_code = c_struc_type
920: and c.structure_type_id = b.structure_type_id
921: and b.proj_element_id = a.proj_element_id;

Line 972: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b

968: /* Bug 2736392 Begin */
969: CURSOR cur_struc_ver_wp2
970: IS
971: SELECT c.element_version_id
972: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
973: ,pa_proj_elem_ver_structure d
974: WHERE c.project_id = p_project_id
975: AND a.structure_type_id = b.structure_type_id
976: AND b.proj_element_id = c.proj_element_id

Line 1124: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b

1120: join in the following cursor*/
1121:
1122: CURSOR c1 is
1123: SELECT c.element_version_id
1124: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
1125: ,pa_proj_elem_ver_structure d
1126: WHERE c.project_id = p_project_id
1127: AND a.structure_type_id = b.structure_type_id
1128: AND b.proj_element_id = c.proj_element_id

Line 2276: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b

2272:
2273: CURSOR cur_struc_ver_fin
2274: IS
2275: SELECT c.element_version_id
2276: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
2277: ,pa_proj_elem_ver_structure d
2278: WHERE c.project_id = p_project_id
2279: AND a.structure_type_id = b.structure_type_id
2280: AND b.proj_element_id = c.proj_element_id

Line 2295: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b

2291:
2292: CURSOR cur_struc_ver_wp
2293: IS
2294: SELECT c.element_version_id
2295: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
2296: ,pa_proj_elem_ver_structure d
2297: WHERE c.project_id = p_project_id
2298: AND a.structure_type_id = b.structure_type_id
2299: AND b.proj_element_id = c.proj_element_id

Line 2363: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b

2359:
2360: CURSOR cur_pa_proj_elem_vers2( c_task_version_id NUMBER )
2361: IS
2362: SELECT 'x'
2363: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
2364: WHERE c.project_id = p_project_id
2365: AND a.structure_type_id = b.structure_type_id
2366: AND b.proj_element_id = c.proj_element_id
2367: AND a.structure_type = 'WORKPLAN'

Line 2401: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b

2397: /* Bug 2736392 Begin */
2398: CURSOR cur_struc_ver_wp2
2399: IS
2400: SELECT c.element_version_id
2401: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
2402: ,pa_proj_elem_ver_structure d
2403: WHERE c.project_id = p_project_id
2404: AND a.structure_type_id = b.structure_type_id
2405: AND b.proj_element_id = c.proj_element_id

Line 3822: pa_structure_types pst

3818: CURSOR cur_pub_versions is
3819: select 'Y'
3820: from pa_proj_elem_ver_structure ppevs,
3821: pa_proj_structure_types ppst,
3822: pa_structure_types pst
3823: where ppevs.project_id = p_project_id
3824: and ppevs.STATUS_CODE = 'STRUCTURE_PUBLISHED'
3825: and ppevs.proj_element_id = ppst.proj_element_id
3826: and ppst.structure_type_id = pst.structure_type_id

Line 3995: from pa_structure_types

3991:
3992: CURSOR cur_struc_type_id
3993: IS
3994: select structure_type_id
3995: from pa_structure_types
3996: where structure_type_class_code = 'WORKPLAN';
3997:
3998: CURSOR cur_pa_proj_elem_vers2
3999: IS

Line 4001: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b

3997:
3998: CURSOR cur_pa_proj_elem_vers2
3999: IS
4000: SELECT element_version_id
4001: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
4002: WHERE c.project_id = p_project_id
4003: AND a.structure_type_id = b.structure_type_id
4004: AND b.proj_element_id = c.proj_element_id
4005: AND a.structure_type = 'WORKPLAN';

Line 4409: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b

4405:
4406: CURSOR cur_pa_proj_elem_vers
4407: IS
4408: SELECT element_version_id
4409: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
4410: WHERE c.project_id = p_project_id
4411: AND a.structure_type_id = b.structure_type_id
4412: AND b.proj_element_id = c.proj_element_id
4413: AND a.structure_type = 'FINANCIAL';

Line 4990: pa_structure_types c

4986:
4987: cursor c2 is
4988: select b.proj_element_id
4989: from pa_proj_elements a, pa_proj_structure_types b,
4990: pa_structure_types c
4991: where a.project_id = p_project_id
4992: and a.object_type = 'PA_STRUCTURES'
4993: and a.proj_element_id = b.proj_element_id
4994: and b.structure_type_id = c.structure_type_id

Line 5869: from pa_proj_structure_types pstype, pa_structure_types types

5865: FROM pa_proj_elements pelem
5866: WHERE project_id = c_project_id
5867: AND pm_source_reference = c_pm_source_reference
5868: AND exists(select 1
5869: from pa_proj_structure_types pstype, pa_structure_types types
5870: where pstype.proj_element_id = pelem.parent_structure_id
5871: and pstype.structure_type_id = types.structure_type_id
5872: and types.structure_type = p_structure_type);
5873: --End Added by rtarway for BUG 3990873

Line 6345: ,pa_structure_types pst

6341: CURSOR cur_get_wp_attr IS
6342: SELECT ppwa.WP_ENABLE_VERSION_FLAG
6343: FROM pa_proj_workplan_attr ppwa
6344: ,pa_proj_structure_types ppst
6345: ,pa_structure_types pst
6346: WHERE ppwa.project_id = p_src_project_id
6347: AND ppwa.proj_element_id = ppst.proj_element_id
6348: AND ppst.structure_type_id = pst.structure_type_id
6349: AND pst.structure_type = 'WORKPLAN' ;

Line 6378: pa_structure_types pst

6374: CURSOR cur_get_split_fin_ver IS
6375: SELECT ppev.element_version_id
6376: FROM pa_proj_element_versions ppev,
6377: pa_proj_structure_types ppst,
6378: pa_structure_types pst
6379: WHERE ppev.project_id = p_src_project_id
6380: AND ppev.object_type = 'PA_STRUCTURES'
6381: AND ppev.proj_element_id = ppst.proj_element_id
6382: AND ppst.structure_type_id = pst.structure_type_id

Line 6794: pa_structure_types pst

6790: CURSOR cur_get_split_fin_ver IS
6791: SELECT ppev.element_version_id
6792: FROM pa_proj_element_versions ppev,
6793: pa_proj_structure_types ppst,
6794: pa_structure_types pst
6795: WHERE ppev.project_id = p_src_project_id
6796: AND ppev.object_type = 'PA_STRUCTURES'
6797: AND ppev.proj_element_id = ppst.proj_element_id
6798: AND ppst.structure_type_id = pst.structure_type_id

Line 7609: ,pa_structure_types pst

7605: CURSOR cur_get_wp_attr IS
7606: SELECT ppwa.WP_ENABLE_VERSION_FLAG
7607: FROM pa_proj_workplan_attr ppwa
7608: ,pa_proj_structure_types ppst
7609: ,pa_structure_types pst
7610: WHERE ppwa.project_id = p_src_project_id
7611: AND ppwa.proj_element_id = ppst.proj_element_id
7612: AND ppst.structure_type_id = pst.structure_type_id
7613: AND pst.structure_type = 'WORKPLAN';

Line 7636: pa_structure_types pst

7632: SELECT ppe.proj_element_id,
7633: ppe.attribute15
7634: FROM pa_proj_elements ppe,
7635: pa_proj_structure_types ppst,
7636: pa_structure_types pst
7637: WHERE ppe.project_id = p_dest_project_id
7638: AND ppe.object_type = 'PA_STRUCTURES'
7639: AND ppe.proj_element_id = ppst.proj_element_id
7640: AND ppst.structure_type_id = pst.structure_type_id

Line 7722: pa_structure_types pst

7718: CURSOR c_only_wp_ver_id(l_proj_id IN NUMBER) IS
7719: SELECT ppv.element_version_id
7720: FROM pa_proj_element_versions ppv ,
7721: pa_proj_structure_types pps,
7722: pa_structure_types pst
7723: WHERE ppv.proj_element_id = pps.proj_element_id
7724: AND ppv.object_type = 'PA_STRUCTURES'
7725: AND pps.structure_type_id = pst.structure_type_id
7726: AND pst.structure_type = 'WORKPLAN'

Line 7821: , PA_STRUCTURE_TYPES pst

7817: CURSOR c_get_approval_options IS
7818: SELECT wp_approval_reqd_flag, wp_auto_publish_flag, wp_approver_source_id
7819: FROM PA_PROJ_WORKPLAN_ATTR ppwa
7820: , PA_PROJ_STRUCTURE_TYPES ppst
7821: , PA_STRUCTURE_TYPES pst
7822: WHERE ppwa.PROJECT_ID = p_src_project_id
7823: AND ppwa.PROJ_ELEMENT_ID = ppst.PROJ_ELEMENT_ID
7824: AND ppst.structure_type_id = pst.structure_type_id
7825: and pst.structure_type = 'WORKPLAN';

Line 8212: ,pa_structure_types pst

8208: AND ppe.proj_element_id IN
8209: ( SELECT ppe2.proj_element_id
8210: FROM pa_proj_elements ppe2
8211: ,pa_proj_structure_types ppst
8212: ,pa_structure_types pst
8213: WHERE ppe2.project_id = p_src_project_id
8214: AND ppe2.object_type = 'PA_STRUCTURES'
8215: AND ppe2.proj_element_id = ppst.proj_element_id
8216: AND ppst.structure_type_id = pst.structure_type_id

Line 8267: ,pa_structure_types pst

8263: AND ppe.attribute15 IN --DoNot use PA_PROJ_ELEMENTS_UTILS.check_fin_or_wp_structure( ppe.attribute15 ) = 'Y'
8264: ( SELECT ppe2.proj_element_id
8265: FROM pa_proj_elements ppe2
8266: ,pa_proj_structure_types ppst
8267: ,pa_structure_types pst
8268: WHERE ppe2.project_id = p_src_project_id
8269: AND ppe2.object_type = 'PA_STRUCTURES'
8270: AND ppe2.proj_element_id = ppst.proj_element_id
8271: AND ppst.structure_type_id = pst.structure_type_id

Line 10021: pa_structure_types stype

10017: AND ppev.parent_structure_version_id =
10018: ( SELECT ppevst.element_version_id --Changed the inner query for bug 4215666.
10019: FROM pa_proj_elem_ver_structure ppevst,
10020: pa_proj_structure_types struc,
10021: pa_structure_types stype
10022: WHERE ppevst.project_id = p_dest_project_id
10023: AND ppevst.current_flag = 'Y'
10024: AND ppevst.status_code = 'STRUCTURE_PUBLISHED'
10025: AND ppevst.proj_element_id = struc.proj_element_id

Line 10600: and exists (select null from pa_proj_structure_types pst, pa_structure_types ps

10596:
10597: /* Code Addition starts for bug 3737444 */
10598: CURSOR get_wp_attr IS
10599: select * from pa_proj_workplan_attr pppa where pppa.project_id=p_src_project_id
10600: and exists (select null from pa_proj_structure_types pst, pa_structure_types ps
10601: where pst.structure_type_id=ps.structure_type_id
10602: and ps. STRUCTURE_TYPE ='WORKPLAN'
10603: and pst.proj_element_id=pppa.proj_element_id);
10604:

Line 10618: from pa_structure_types pst,

10614: /* SELECT *
10615: FROM PA_PROJ_ELEM_ver_structure ppevs
10616: WHERE project_id = p_src_project_id;*//*Commented below query and following criteria by SMUKKA */
10617: select ppevs.*
10618: from pa_structure_types pst,
10619: pa_proj_structure_types ppst,
10620: pa_proj_elem_ver_structure ppevs
10621: where ppevs.project_id = p_src_project_id
10622: and ppevs.proj_element_id= ppst.proj_element_id

Line 10636: pa_structure_types pst

10632: WHERE project_id = p_src_project_id
10633: AND ppst.proj_element_id(+) = ppevs.proj_element_id;*//*Commented below query and following criteria by SMUKKA */
10634: from pa_proj_elem_ver_structure ppevs,
10635: pa_proj_structure_types ppst,
10636: pa_structure_types pst
10637: where project_id = p_src_project_id
10638: and ppst.proj_element_id(+) = ppevs.proj_element_id
10639: and ppst.structure_type_id = pst.structure_type_id
10640: and pst.structure_type in ('WORKPLAN','FINANCIAL');

Line 10750: pa_structure_types pst

10746: AND ppe.project_id = p_dest_project_id
10747: AND ppe.object_type = 'PA_STRUCTURES';*//*Commented below query and following criteria by SMUKKA */
10748: from pa_proj_elements ppe,
10749: pa_proj_structure_types ppst,
10750: pa_structure_types pst
10751: where ppe.proj_element_id =ppst.proj_element_id
10752: and ppe.project_id = p_dest_project_id
10753: and ppe.object_type = 'PA_STRUCTURES'
10754: and ppst.structure_type_id = pst.structure_type_id

Line 10794: pa_structure_types pst

10790: where project_id = p_dest_project_id
10791: and object_type = 'PA_STRUCTURES';*//*Commented below query and following criteria by SMUKKA */
10792: from pa_proj_elements ppe,
10793: pa_proj_structure_types ppst,
10794: pa_structure_types pst
10795: where project_id = p_dest_project_id
10796: and object_type = 'PA_STRUCTURES'
10797: and ppe.proj_element_id =ppst.proj_element_id
10798: and ppst.structure_type_id = pst.structure_type_id

Line 11028: pa_structure_types pst

11024: and ppe.object_type = 'PA_STRUCTURES'
11025: and ppe.proj_element_id IN (select ppe2.proj_element_id
11026: from pa_proj_elements ppe2,
11027: pa_proj_structure_types ppst,
11028: pa_structure_types pst
11029: where ppe2.project_id = p_src_project_id
11030: and ppe2.object_type = 'PA_STRUCTURES'
11031: and ppe2.proj_element_id = ppst.proj_element_id
11032: and ppst.structure_type_id = pst.structure_type_id

Line 11072: pa_structure_types pst

11068: and ppe.attribute15 = ppst.proj_element_id ---join with copy_from_proj_element_id to get the structure types
11069: and ppe.object_type = 'PA_STRUCTURES';*//*Commented below query and following criteria by SMUKKA */
11070: from pa_proj_elements ppe,
11071: pa_proj_structure_types ppst,
11072: pa_structure_types pst
11073: where ppe.project_id = p_dest_project_id
11074: and ppe.attribute15 = ppst.proj_element_id
11075: and ppe.object_type = 'PA_STRUCTURES'
11076: and ppst.structure_type_id = pst.structure_type_id

Line 11403: pa_structure_types pst

11399: and ppe.proj_element_id IN
11400: (select ppe2.proj_element_id
11401: from pa_proj_elements ppe2,
11402: pa_proj_structure_types ppst,
11403: pa_structure_types pst
11404: -- where ppe2.project_id = p_src_project_id
11405: where ppe2.project_id = p_dest_project_id --Bug 3585699 SMukka Replaced p_src_project_id by p_dest_project_id
11406: and ppe2.object_type = 'PA_STRUCTURES'
11407: and ppe2.proj_element_id = ppst.proj_element_id

Line 11423: pa_structure_types pst

11419: AND object_type = 'PA_STRUCTURES'
11420: and proj_element_id IN (select ppe2.proj_element_id
11421: from pa_proj_elements ppe2,
11422: pa_proj_structure_types ppst,
11423: pa_structure_types pst
11424: where ppe2.project_id = p_src_project_id
11425: and ppe2.object_type = 'PA_STRUCTURES'
11426: and ppe2.proj_element_id = ppst.proj_element_id
11427: and ppst.structure_type_id = pst.structure_type_id

Line 11519: pa_structure_types pst

11515: AND ppe.object_type = 'PA_STRUCTURES'
11516: and ppe.proj_element_id IN (SELECT ppe2.proj_element_id
11517: FROM pa_proj_elements ppe2,
11518: pa_proj_structure_types ppst,
11519: pa_structure_types pst
11520: WHERE ppe2.project_id = p_dest_project_id
11521: AND ppe2.object_type = 'PA_STRUCTURES'
11522: AND ppe2.proj_element_id = ppst.proj_element_id
11523: AND ppst.structure_type_id = pst.structure_type_id

Line 13271: ,p_structure_type IN pa_structure_types.structure_type_class_code%TYPE

13267: ,p_calling_module IN VARCHAR2
13268: ,p_project_id IN pa_projects_all.project_id%TYPE
13269: ,p_source_project_id IN pa_projects_all.project_id%TYPE
13270: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE
13271: ,p_structure_type IN pa_structure_types.structure_type_class_code%TYPE
13272: ,p_tasks_in_tbl IN pa_project_pub.task_in_tbl_type
13273: ,p_create_task_version_only IN VARCHAR2
13274: ,p_wp_str_exists IN VARCHAR2
13275: ,p_is_wp_separate_from_fn IN VARCHAR2

Line 13300: CURSOR get_structure(c_project_id pa_projects_all.project_id%TYPE, c_struc_type pa_structure_types.structure_type_class_code%TYPE) IS

13296: FROM pa_proj_workplan_attr
13297: WHERE project_id = c_project_id;
13298: */
13299: -- This cursor is used to get the structure id given the structure type and project_id
13300: CURSOR get_structure(c_project_id pa_projects_all.project_id%TYPE, c_struc_type pa_structure_types.structure_type_class_code%TYPE) IS
13301: select pelem.proj_element_id
13302: from pa_proj_elements pelem,
13303: pa_proj_structure_types ppstr,
13304: pa_structure_types pstr

Line 13304: pa_structure_types pstr

13300: CURSOR get_structure(c_project_id pa_projects_all.project_id%TYPE, c_struc_type pa_structure_types.structure_type_class_code%TYPE) IS
13301: select pelem.proj_element_id
13302: from pa_proj_elements pelem,
13303: pa_proj_structure_types ppstr,
13304: pa_structure_types pstr
13305: where pelem.project_id = c_project_id
13306: and pstr.structure_type_class_code = c_struc_type
13307: and pstr.structure_type_id = ppstr.structure_type_id
13308: and ppstr.proj_element_id = pelem.proj_element_id;

Line 13577: from pa_proj_structure_types pstype, pa_structure_types types

13573: FROM pa_proj_elements pelem
13574: WHERE project_id = c_project_id
13575: AND pm_source_reference = c_pm_source_reference
13576: AND exists(select 1
13577: from pa_proj_structure_types pstype, pa_structure_types types
13578: where pstype.proj_element_id = pelem.parent_structure_id
13579: and pstype.structure_type_id = types.structure_type_id
13580: and types.structure_type = p_structure_type);
13581: -- Amit Bug 3964548 End

Line 13655: CURSOR cur_struc_ver_wp(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)

13651: l_prev_percent_comp Number;
13652: l_update_task_det_flag varchar2(1);
13653:
13654: -- Bug 6717386
13655: CURSOR cur_struc_ver_wp(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)
13656: IS
13657: SELECT c.element_version_id
13658: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
13659: ,pa_proj_elem_ver_structure d

Line 13658: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b

13654: -- Bug 6717386
13655: CURSOR cur_struc_ver_wp(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)
13656: IS
13657: SELECT c.element_version_id
13658: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
13659: ,pa_proj_elem_ver_structure d
13660: WHERE c.project_id = c_project_id
13661: AND a.structure_type_id = b.structure_type_id
13662: AND b.proj_element_id = c.proj_element_id

Line 14229: from pa_proj_structure_types pstype, pa_structure_types types

14225: FROM pa_proj_elements pelem
14226: WHERE project_id = c_project_id
14227: AND pm_source_reference = c_pm_source_reference
14228: AND exists(select 1
14229: from pa_proj_structure_types pstype, pa_structure_types types
14230: where pstype.proj_element_id = pelem.parent_structure_id
14231: and pstype.structure_type_id = types.structure_type_id
14232: and types.structure_type = p_structure_type);
14233: BEGIN

Line 17762: c_structure_type pa_structure_types.structure_type%TYPE)

17758: -- Structure type. Depending on this the plannable tasks api and the task weightage calculation
17759: -- api will be called.
17760: Cursor cur_structure_type(c_project_id pa_projects_all.project_id%TYPE,
17761: c_structure_version_id pa_proj_element_versions.element_version_id%TYPE,
17762: c_structure_type pa_structure_types.structure_type%TYPE)
17763: IS
17764: select 'Y'
17765: from pa_proj_element_versions ver,
17766: pa_proj_structure_types pst,

Line 17767: pa_structure_types st

17763: IS
17764: select 'Y'
17765: from pa_proj_element_versions ver,
17766: pa_proj_structure_types pst,
17767: pa_structure_types st
17768: where ver.element_version_id = c_structure_version_id
17769: and ver.project_id = c_project_id
17770: and pst.proj_element_id = ver.proj_element_id
17771: and pst.structure_type_id = st.structure_type_id

Line 18457: c_structure_type pa_structure_types.structure_type%TYPE)

18453: -- Structure type. Depending on this the plannable tasks api and the task weightage calculation
18454: -- api will be called.
18455: CURSOR cur_structure_type(c_project_id pa_projects_all.project_id%TYPE,
18456: c_structure_version_id pa_proj_element_versions.element_version_id%TYPE,
18457: c_structure_type pa_structure_types.structure_type%TYPE)
18458: IS
18459: SELECT 'Y'
18460: FROM pa_proj_element_versions ver,
18461: pa_proj_structure_types pst,

Line 18462: pa_structure_types st

18458: IS
18459: SELECT 'Y'
18460: FROM pa_proj_element_versions ver,
18461: pa_proj_structure_types pst,
18462: pa_structure_types st
18463: WHERE ver.element_version_id = c_structure_version_id
18464: AND ver.project_id = c_project_id
18465: AND pst.proj_element_id = ver.proj_element_id
18466: AND pst.structure_type_id = st.structure_type_id

Line 21120: FROM pa_proj_elements ppe, pa_proj_structure_types ppst, pa_structure_types pst

21116:
21117: CURSOR cur_strs_n_types
21118: IS
21119: SELECT ppe.proj_element_id, ppst.structure_type_id
21120: FROM pa_proj_elements ppe, pa_proj_structure_types ppst, pa_structure_types pst
21121: WHERE ppe.project_id = p_dest_project_id
21122: AND ppe.object_type = 'PA_STRUCTURES'
21123: AND ppe.proj_element_id = ppst.proj_element_id
21124: and ppst.structure_type_id = pst.structure_type_id