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_DELIVERABLE_UTILS dependencies on PA_TASKS

Line 246: --'DELIVERABLE' task of object_type 'PA_TASKS'

242: --The cursor c_dlv_based_task_exists returns 'X' at the first hit
243: --If there exists a deliverable of object_type 'PA_DELIVERABLES'
244: --of type p_deliverable_id
245: --and which has a relationship 'TASK_TO_DELIVERABLE' with a
246: --'DELIVERABLE' task of object_type 'PA_TASKS'
247:
248: --Note : The relationship is defined by the relationship_type 'A'
249:
250: CURSOR c_dlv_based_task_exists IS

Line 261: and ppe2.object_type = 'PA_TASKS'

257: where ppe1.type_id = p_deliverable_type_id
258: and ppe1.object_type= 'PA_DELIVERABLES'
259: and ppe1.proj_element_id = obj.object_id_to2
260: and ppe2. proj_element_id = obj.object_id_from2
261: and ppe2.object_type = 'PA_TASKS'
262: and ppe2.project_id = ppe1.project_id
263: and ppe2.base_percent_comp_deriv_code = 'DELIVERABLE'
264: and obj.object_type_from = 'PA_TASKS'
265: and obj.object_type_to = 'PA_DELIVERABLES' -- 3570283 removed extra spaces

Line 264: and obj.object_type_from = 'PA_TASKS'

260: and ppe2. proj_element_id = obj.object_id_from2
261: and ppe2.object_type = 'PA_TASKS'
262: and ppe2.project_id = ppe1.project_id
263: and ppe2.base_percent_comp_deriv_code = 'DELIVERABLE'
264: and obj.object_type_from = 'PA_TASKS'
265: and obj.object_type_to = 'PA_DELIVERABLES' -- 3570283 removed extra spaces
266: and obj.relationship_subtype = 'TASK_TO_DELIVERABLE'
267: and obj.relationship_type = 'A');
268:

Line 342: WHERE ppe.object_type='PA_TASKS'

338: CURSOR c_associated_tasks IS
339: SELECT ppe. name||'('|| ppe.element_number||')' name_number
340: FROM PA_PROJ_ELEMENTS ppe ,
341: PA_OBJECT_RELATIONSHIPS obj
342: WHERE ppe.object_type='PA_TASKS'
343: AND ppe.proj_element_id = OBJ.object_id_from2
344: AND OBJ.object_id_to2 =p_deliverable_id
345: AND OBJ.object_type_to = 'PA_DELIVERABLES'
346: AND OBJ.object_type_from = 'PA_TASKS'

Line 346: AND OBJ.object_type_from = 'PA_TASKS'

342: WHERE ppe.object_type='PA_TASKS'
343: AND ppe.proj_element_id = OBJ.object_id_from2
344: AND OBJ.object_id_to2 =p_deliverable_id
345: AND OBJ.object_type_to = 'PA_DELIVERABLES'
346: AND OBJ.object_type_from = 'PA_TASKS'
347: AND OBJ.relationship_type = 'A'
348: AND OBJ.relationship_subtype = 'TASK_TO_DELIVERABLE'
349: ORDER BY ppe.base_percent_comp_deriv_code;
350:

Line 1128: AND ppe.object_type = 'PA_TASKS'

1124: FROM
1125: PA_PROJ_ELEMENTS ppe
1126: WHERE
1127: ppe.proj_element_id = p_task_id
1128: AND ppe.object_type = 'PA_TASKS'
1129: AND ppe.project_id = p_project_id;
1130: END IF;
1131:
1132: return x_organization_id;

Line 1174: AND ppe.object_type = 'PA_TASKS';

1170: SELECT ppe.base_percent_comp_deriv_code
1171: INTO x_base_percent_comp_deriv_code
1172: FROM PA_PROJ_ELEMENTS ppe
1173: WHERE ppe.proj_element_id = p_task_id
1174: AND ppe.object_type = 'PA_TASKS';
1175:
1176: -- 3625019 when task type is changed from update task detail page
1177: -- base_percent_comp_deriv_code attribute is set to null and task type id
1178: -- is set to null value

Line 1760: AND PPE.OBJECT_TYPE = 'PA_TASKS';

1756: PPE. NAME||'('|| PPE.ELEMENT_NUMBER||')' NAME_NUMBER
1757: FROM
1758: PA_PROJ_ELEMENTS PPE
1759: WHERE PPE.PROJ_ELEMENT_ID = p_task_id
1760: AND PPE.OBJECT_TYPE = 'PA_TASKS';
1761:
1762: BEGIN
1763:
1764: OPEN l_task_info_csr;

Line 1821: AND PEV.OBJECT_TYPE = 'PA_TASKS'

1817: PER_ALL_PEOPLE_F PPF,
1818: PA_PROJ_ELEMENT_VERSIONS PEV
1819: WHERE
1820: PEV.ELEMENT_VERSION_ID = p_task_ver_id
1821: AND PEV.OBJECT_TYPE = 'PA_TASKS'
1822: AND PEV.PROJ_ELEMENT_ID = PPE.PROJ_ELEMENT_ID
1823: AND PPE.OBJECT_TYPE = 'PA_TASKS'
1824: AND PPE.MANAGER_PERSON_ID = PPF.PERSON_ID
1825: AND PPE.PROJECT_ID = p_project_id

Line 1823: AND PPE.OBJECT_TYPE = 'PA_TASKS'

1819: WHERE
1820: PEV.ELEMENT_VERSION_ID = p_task_ver_id
1821: AND PEV.OBJECT_TYPE = 'PA_TASKS'
1822: AND PEV.PROJ_ELEMENT_ID = PPE.PROJ_ELEMENT_ID
1823: AND PPE.OBJECT_TYPE = 'PA_TASKS'
1824: AND PPE.MANAGER_PERSON_ID = PPF.PERSON_ID
1825: AND PPE.PROJECT_ID = p_project_id
1826: AND PEV.PROJECT_ID = p_project_id
1827: AND SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE AND PPF.EFFECTIVE_END_DATE;

Line 1914: /* AND PEV.OBJECT_TYPE = 'PA_TASKS'

1910: WHERE
1911: PEV.ELEMENT_VERSION_ID = p_task_ver_id
1912: AND PEV.ELEMENT_VERSION_ID = PES.ELEMENT_VERSION_ID ;
1913:
1914: /* AND PEV.OBJECT_TYPE = 'PA_TASKS'
1915: AND PES.PROJECT_ID = p_project_id;Commented Unnecessary joins -
1916: This Query was flagged by xpl utility because of missing index PA_PROJ_ELEM_VER_SCHEDULE_U2 in ch2m 3614361 */
1917:
1918: BEGIN

Line 2096: /* AND PEV.OBJECT_TYPE = 'PA_TASKS'

2092: WHERE
2093: PEV.ELEMENT_VERSION_ID = p_task_ver_id
2094: AND PEV.ELEMENT_VERSION_ID = PES.ELEMENT_VERSION_ID ;
2095:
2096: /* AND PEV.OBJECT_TYPE = 'PA_TASKS'
2097: AND PEV.PROJECT_ID = PES.PROJECT_ID;
2098: Commented Unwanted Joins - This query was flagged by xpl utility because of missing index
2099: PA_PROJ_ELEM_VER_SCHEDULE_U2 in ch2m database Bug 3614361 */
2100: BEGIN

Line 2194: and obj.object_type_from = 'PA_TASKS'

2190: PA_PROJ_ELEMENTS ppe
2191: where ppe.proj_element_id = p_dlv_element_id
2192: and ppe.object_type= 'PA_DELIVERABLES'
2193: and obj.object_id_to2 = ppe.proj_element_id
2194: and obj.object_type_from = 'PA_TASKS'
2195: and obj.object_type_to = 'PA_DELIVERABLES' -- 3570283 removed extra spaces
2196: and obj.relationship_subtype = 'TASK_TO_DELIVERABLE'
2197: and obj.relationship_type = 'A'
2198: and nvl(PA_DELIVERABLE_UTILS.GET_PROGRESS_ROLLUP_METHOD(obj.object_id_from2),'X') = 'DELIVERABLE'

Line 2209: and obj.object_type_from = 'PA_TASKS'

2205: FROM PA_OBJECT_RELATIONSHIPS obj,
2206: pa_proj_elements ppe,
2207: pa_task_types ptt
2208: where obj.object_id_to2 = p_dlv_element_id
2209: and obj.object_type_from = 'PA_TASKS'
2210: and obj.object_type_to = 'PA_DELIVERABLES'
2211: and obj.relationship_subtype = 'TASK_TO_DELIVERABLE'
2212: and obj.relationship_type = 'A'
2213: and ppe.proj_element_id = obj.object_id_from2

Line 2318: AND obj.object_type_from = 'PA_TASKS'

2314: ,pa_proj_elements ppe
2315: ,pa_task_types ptt
2316: WHERE obj.object_id_from2 = p_proj_element_id
2317: AND obj.object_type_to = 'PA_DELIVERABLES'
2318: AND obj.object_type_from = 'PA_TASKS'
2319: AND obj.relationship_type = 'A'
2320: AND obj.relationship_subtype = 'TASK_TO_DELIVERABLE'
2321: AND obj.object_id_to2 = ppe.proj_element_id
2322: AND ppe.object_type = 'PA_DELIVERABLES'

Line 2590: AND PEV.OBJECT_TYPE = 'PA_TASKS'

2586: ,PA_PROJ_ELEM_VER_SCHEDULE PES
2587: WHERE
2588: PEV.ELEMENT_VERSION_ID = p_task_ver_id
2589: AND PEV.ELEMENT_VERSION_ID = PES.ELEMENT_VERSION_ID
2590: AND PEV.OBJECT_TYPE = 'PA_TASKS'
2591: AND PEV.PROJECT_ID = PES.PROJECT_ID;/* Including this additional clause for Performance Fix : Bug 3614361 */
2592:
2593: BEGIN
2594:

Line 2881: AND ppe.object_type='PA_TASKS'

2877: pa_proj_element_versions ppv,
2878: pa_object_relationships obj1,
2879: pa_object_relationships obj2
2880: WHERE ppe.proj_element_id=p_task_id
2881: AND ppe.object_type='PA_TASKS'
2882: AND obj1.relationship_type='A'
2883: AND obj1.relationship_subtype='TASK_TO_DELIVERABLE'
2884: AND obj1.object_id_from2=p_task_id
2885: AND obj1.object_type_from='PA_TASKS'

Line 2885: AND obj1.object_type_from='PA_TASKS'

2881: AND ppe.object_type='PA_TASKS'
2882: AND obj1.relationship_type='A'
2883: AND obj1.relationship_subtype='TASK_TO_DELIVERABLE'
2884: AND obj1.object_id_from2=p_task_id
2885: AND obj1.object_type_from='PA_TASKS'
2886: AND obj1.object_type_to='PA_DELIVERABLES'
2887: AND obj2.relationship_type='A'
2888: AND obj2.relationship_subtype='DELIVERABLE_TO_ACTION'
2889: AND obj2.object_id_from2=obj1.object_id_to2

Line 2905: AND obj.object_type_from='PA_TASKS'

2901: pa_object_relationships obj
2902: WHERE obj.relationship_type='A'
2903: AND obj.relationship_subtype='TASK_TO_DELIVERABLE'
2904: AND obj.object_id_from2=p_task_id
2905: AND obj.object_type_from='PA_TASKS'
2906: AND obj.object_type_to='PA_DELIVERABLES'
2907: AND ppe.proj_element_id = obj.object_id_to2
2908: AND ppe.object_type = 'PA_DELIVERABLES';
2909:

Line 3015: AND ppe.object_type='PA_TASKS'

3011: pa_proj_element_versions ppv,
3012: pa_object_relationships obj1,
3013: pa_object_relationships obj2
3014: WHERE ppe.proj_element_id=p_wp_task_version_id
3015: AND ppe.object_type='PA_TASKS'
3016: AND obj1.relationship_type='A'
3017: AND obj1.relationship_subtype='TASK_TO_DELIVERABLE'
3018: AND obj1.object_id_from2=ppe.proj_element_id
3019: AND obj1.object_type_from='PA_TASKS'

Line 3019: AND obj1.object_type_from='PA_TASKS'

3015: AND ppe.object_type='PA_TASKS'
3016: AND obj1.relationship_type='A'
3017: AND obj1.relationship_subtype='TASK_TO_DELIVERABLE'
3018: AND obj1.object_id_from2=ppe.proj_element_id
3019: AND obj1.object_type_from='PA_TASKS'
3020: AND obj1.object_type_to='PA_DELIVERABLES'
3021: AND obj2.relationship_type='A'
3022: AND obj2.relationship_subtype='DELIVERABLE_TO_ACTION'
3023: AND obj2.object_id_from2=obj1.object_id_to2

Line 3121: AND obj.object_type_from='PA_TASKS'

3117: pa_object_relationships obj
3118: WHERE obj.relationship_type='A'
3119: AND obj.relationship_subtype='TASK_TO_DELIVERABLE'
3120: AND obj.object_id_from2=p_task_id
3121: AND obj.object_type_from='PA_TASKS'
3122: AND obj.object_type_to='PA_DELIVERABLES'
3123: AND ppe.proj_element_id = obj.object_id_to2
3124: AND 'Y' = PA_DELIVERABLE_UTILS.IS_DELIVERABLE_HAS_PROGRESS(ppe.project_id,ppe.proj_element_id)
3125: );

Line 3136: AND ppe.object_type='PA_TASKS'

3132: FROM pa_proj_elements ppe,
3133: pa_object_relationships obj,
3134: pa_proj_element_versions ppev
3135: WHERE ppe.proj_element_id=p_task_id
3136: AND ppe.object_type='PA_TASKS'
3137: AND obj.relationship_type='A'
3138: AND obj.relationship_subtype='TASK_TO_DELIVERABLE'
3139: AND obj.object_id_from2=ppe.proj_element_id
3140: AND obj.object_type_from='PA_TASKS'

Line 3140: AND obj.object_type_from='PA_TASKS'

3136: AND ppe.object_type='PA_TASKS'
3137: AND obj.relationship_type='A'
3138: AND obj.relationship_subtype='TASK_TO_DELIVERABLE'
3139: AND obj.object_id_from2=ppe.proj_element_id
3140: AND obj.object_type_from='PA_TASKS'
3141: AND obj.object_type_to='PA_DELIVERABLES'
3142: AND ppev.proj_element_id = obj.object_id_to2
3143: AND ppev.project_id = ppe.project_id
3144: /*This AND Clause is Wrong as the 1st param passed is the Task ID whereas IS_DLV_BASED_ASSCN_EXISTS API

Line 3252: AND obj2.object_type_from = 'PA_TASKS'

3248: AND obj1.object_type_to = 'PA_ACTIONS'
3249: AND obj2.object_id_to2 = obj1.object_id_from2
3250: AND obj2.relationship_type ='A'
3251: AND obj2.relationship_subtype='TASK_TO_DELIVERABLE'
3252: AND obj2.object_type_from = 'PA_TASKS'
3253: AND obj2.object_type_to = 'PA_DELIVERABLES'
3254: AND ppe2.proj_element_id=obj2.object_id_from1
3255: AND ppe2.object_type='PA_TASKS'
3256: AND ( nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ppev.element_version_id),'N') = 'Y'

Line 3255: AND ppe2.object_type='PA_TASKS'

3251: AND obj2.relationship_subtype='TASK_TO_DELIVERABLE'
3252: AND obj2.object_type_from = 'PA_TASKS'
3253: AND obj2.object_type_to = 'PA_DELIVERABLES'
3254: AND ppe2.proj_element_id=obj2.object_id_from1
3255: AND ppe2.object_type='PA_TASKS'
3256: AND ( nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ppev.element_version_id),'N') = 'Y'
3257: OR nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ppev.element_version_id),'N') = 'Y'
3258: OR nvl(OKE_DELIVERABLE_UTILS_PUB.MDS_Initiated_Yn(ppev.element_version_id),'N') = 'Y'
3259: OR PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(ppe.proj_element_id) = 'BILLING' )

Line 3343: AND OBJ.object_type_from = 'PA_TASKS'

3339: WHERE ppe.object_type='PA_DELIVERABLES'
3340: AND ppe.proj_element_id = OBJ.object_id_to2
3341: AND OBJ.object_id_from2 =p_task_id
3342: AND OBJ.object_type_to = 'PA_DELIVERABLES'
3343: AND OBJ.object_type_from = 'PA_TASKS'
3344: AND OBJ.relationship_type = 'A'
3345: AND OBJ.relationship_subtype = 'TASK_TO_DELIVERABLE';
3346:
3347: CURSOR c_lookup_meaning IS

Line 3992: Pa_Tasks_Maint_Utils.CHECK_TASK_MGR_NAME_OR_ID (

3988: END IF;
3989:
3990: -- Validating Deliverable Owner Id - valid value
3991: IF (l_dlvr_owner_id IS NOT NULL ) THEN
3992: Pa_Tasks_Maint_Utils.CHECK_TASK_MGR_NAME_OR_ID (
3993: p_task_mgr_name => p_dlvr_owner_name
3994: ,p_task_mgr_id => l_dlvr_owner_id
3995: ,p_project_id => p_project_id
3996: ,p_check_id_flag => 'Y'

Line 4247: AND OBJ.object_type_from = 'PA_TASKS'

4243: FROM PA_OBJECT_RELATIONSHIPS obj
4244: WHERE OBJ.object_id_from2 = p_task_id
4245: AND OBJ.object_id_to2 =p_deliverable_id
4246: AND OBJ.object_type_to = 'PA_DELIVERABLES'
4247: AND OBJ.object_type_from = 'PA_TASKS'
4248: AND OBJ.relationship_type = 'A'
4249: AND OBJ.relationship_subtype = 'TASK_TO_DELIVERABLE';
4250:
4251: BEGIN

Line 5366: -- AND POR.OBJECT_TYPE_TO = 'PA_TASKS'

5362: -- POR.OBJECT_ID_FROM1 = l_struct_ver_id
5363: -- AND PEV.PROJ_ELEMENT_ID = p_task_id
5364: -- AND POR.OBJECT_ID_TO1 = PEV.ELEMENT_VERSION_ID
5365: -- AND POR.OBJECT_TYPE_FROM = 'PA_STRUCTURES'
5366: -- AND POR.OBJECT_TYPE_TO = 'PA_TASKS'
5367: -- AND POR.RELATIONSHIP_SUBTYPE = 'STRUCTURE_TO_TASK';
5368:
5369: -- 3578694 cursor will return task element version id for the
5370: -- passed structure version id

Line 5505: AND object_type = 'PA_TASKS'

5501: FROM dual
5502: WHERE EXISTS ( SELECT 'Y'
5503: FROM pa_proj_elements
5504: WHERE base_percent_comp_deriv_code = 'DELIVERABLE'
5505: AND object_type = 'PA_TASKS'
5506: AND project_id = p_project_id);
5507: l_dummy VARCHAR2(1) := 'N' ;
5508: BEGIN
5509: OPEN dlv_based_task ;

Line 5580: FROM pa_tasks pt

5576: CURSOR split_mapping(c_parent_struct_ver_id IN NUMBER) IS
5577: SELECT distinct pt.task_id
5578: ,pt.task_name
5579: ,pt.task_number
5580: FROM pa_tasks pt
5581: ,pa_proj_element_versions pev1
5582: ,pa_proj_element_versions pev2
5583: ,pa_object_relationships obj1
5584: ,pa_object_relationships obj2

Line 5588: AND obj1.object_type_from = 'PA_TASKS'

5584: ,pa_object_relationships obj2
5585: WHERE obj1.object_id_to2 = p_dlv_element_id
5586: AND obj1.relationship_type = 'A'
5587: AND obj1.relationship_subtype = 'TASK_TO_DELIVERABLE'
5588: AND obj1.object_type_from = 'PA_TASKS'
5589: AND obj1.object_type_to = 'PA_DELIVERABLES'
5590: AND pev1.proj_element_id = obj1.object_id_from2
5591: AND pev1.parent_structure_version_id = c_parent_struct_ver_id
5592: AND pev1.project_id = p_project_id

Line 5606: FROM pa_tasks pt

5602: CURSOR share_partial_or_full(c_parent_struct_ver_id IN NUMBER) IS
5603: SELECT distinct pt.task_id
5604: ,pt.task_name
5605: ,pt.task_number
5606: FROM pa_tasks pt
5607: ,pa_proj_element_versions pev
5608: ,pa_object_relationships obj
5609: WHERE obj.object_id_to2 = p_dlv_element_id
5610: AND obj.relationship_type = 'A'

Line 5612: AND obj.object_type_from = 'PA_TASKS'

5608: ,pa_object_relationships obj
5609: WHERE obj.object_id_to2 = p_dlv_element_id
5610: AND obj.relationship_type = 'A'
5611: AND obj.relationship_subtype = 'TASK_TO_DELIVERABLE'
5612: AND obj.object_type_from = 'PA_TASKS'
5613: AND obj.object_type_to = 'PA_DELIVERABLES'
5614: AND pev.proj_element_id = obj.object_id_from2
5615: AND pev.parent_structure_version_id = c_parent_struct_ver_id
5616: AND pev.project_id = p_project_id

Line 5629: FROM pa_tasks pt

5625: CURSOR split_mapping_bill(c_parent_struct_ver_id IN NUMBER) IS
5626: SELECT distinct pt.top_task_id
5627: ,pt1.task_name
5628: ,pt1.task_number
5629: FROM pa_tasks pt
5630: ,pa_proj_element_versions pev1
5631: ,pa_proj_element_versions pev2
5632: ,pa_object_relationships obj1
5633: ,pa_object_relationships obj2

Line 5634: ,pa_tasks pt1

5630: ,pa_proj_element_versions pev1
5631: ,pa_proj_element_versions pev2
5632: ,pa_object_relationships obj1
5633: ,pa_object_relationships obj2
5634: ,pa_tasks pt1
5635: WHERE obj1.object_id_to2 = p_dlv_element_id
5636: AND obj1.relationship_type = 'A'
5637: AND obj1.relationship_subtype = 'TASK_TO_DELIVERABLE'
5638: AND obj1.object_type_from = 'PA_TASKS'

Line 5638: AND obj1.object_type_from = 'PA_TASKS'

5634: ,pa_tasks pt1
5635: WHERE obj1.object_id_to2 = p_dlv_element_id
5636: AND obj1.relationship_type = 'A'
5637: AND obj1.relationship_subtype = 'TASK_TO_DELIVERABLE'
5638: AND obj1.object_type_from = 'PA_TASKS'
5639: AND obj1.object_type_to = 'PA_DELIVERABLES'
5640: AND pev1.proj_element_id = obj1.object_id_from2
5641: AND pev1.parent_structure_version_id = c_parent_struct_ver_id
5642: AND pev1.project_id = p_project_id

Line 5657: FROM pa_tasks pt

5653: CURSOR share_partial_or_full_bill(c_parent_struct_ver_id IN NUMBER) IS
5654: SELECT distinct pt.top_task_id
5655: ,pt1.task_name
5656: ,pt1.task_number
5657: FROM pa_tasks pt
5658: ,pa_proj_element_versions pev
5659: ,pa_object_relationships obj
5660: ,pa_tasks pt1
5661: WHERE obj.object_id_to2 = p_dlv_element_id

Line 5660: ,pa_tasks pt1

5656: ,pt1.task_number
5657: FROM pa_tasks pt
5658: ,pa_proj_element_versions pev
5659: ,pa_object_relationships obj
5660: ,pa_tasks pt1
5661: WHERE obj.object_id_to2 = p_dlv_element_id
5662: AND obj.relationship_type = 'A'
5663: AND obj.relationship_subtype = 'TASK_TO_DELIVERABLE'
5664: AND obj.object_type_from = 'PA_TASKS'

Line 5664: AND obj.object_type_from = 'PA_TASKS'

5660: ,pa_tasks pt1
5661: WHERE obj.object_id_to2 = p_dlv_element_id
5662: AND obj.relationship_type = 'A'
5663: AND obj.relationship_subtype = 'TASK_TO_DELIVERABLE'
5664: AND obj.object_type_from = 'PA_TASKS'
5665: AND obj.object_type_to = 'PA_DELIVERABLES'
5666: AND pev.proj_element_id = obj.object_id_from2
5667: AND pev.parent_structure_version_id = c_parent_struct_ver_id
5668: AND pev.project_id = p_project_id