[Home] [Help]
301: FROM amw_execution_scope processorg
302: WHERE processorg.process_id = p_process_id
303: AND processorg.organization_id IN
304: (SELECT object_id
305: FROM amw_entity_hierarchies
306: START WITH parent_object_id = p_org_id
307: AND object_type = 'ORG'
308: AND entity_id = p_certification_id
309: AND entity_type='BUSIPROC_CERTIFICATION'
326: from amw_process
327: where process_id = p_process_id)
328: AND scp.organization_id IN
329: (SELECT object_id
330: FROM amw_entity_hierarchies
331: START WITH parent_object_id = p_org_id
332: AND object_type = 'ORG'
333: AND entity_id = p_certification_id
334: AND entity_type='BUSIPROC_CERTIFICATION'
349: AND opinion.opinion_type_code = 'CERTIFICATION'
350: AND opinion.object_name = 'AMW_ORG_PROCESS'
351: AND opinion.pk3_value IN
352: (SELECT object_id
353: FROM amw_entity_hierarchies
354: START WITH parent_object_id = p_org_id
355: AND object_type = 'ORG'
356: AND entity_id = p_certification_id
357: AND entity_type='BUSIPROC_CERTIFICATION'
383: from amw_process
384: where process_id = p_process_id)
385: AND scp.organization_id IN
386: (SELECT object_id
387: FROM amw_entity_hierarchies
388: START WITH parent_object_id = p_org_id
389: AND object_type = 'ORG'
390: AND entity_id = p_certification_id
391: AND entity_type='BUSIPROC_CERTIFICATION'
470: AND opinion.object_name = 'AMW_ORG_PROCESS'
471: AND opinion.audit_result_code <> 'EFFECTIVE'
472: AND opinion.pk3_value IN
473: (SELECT object_id
474: FROM amw_entity_hierarchies
475: START WITH parent_object_id = p_org_id
476: AND object_type = 'ORG'
477: AND entity_id = p_certification_id
478: AND entity_type='BUSIPROC_CERTIFICATION'
504: from amw_process
505: where process_id = p_process_id)
506: AND scp.organization_id IN
507: (SELECT object_id
508: FROM amw_entity_hierarchies
509: START WITH parent_object_id = p_org_id
510: AND object_type = 'ORG'
511: AND entity_id = p_certification_id
512: AND entity_type='BUSIPROC_CERTIFICATION'