APPS.AMW_PROJECT_EVENT_PVT dependencies on AMW_CONTROL_ASSOCIATIONS

Line 290: FROM amw_control_associations

286: AND organization_id = l_pk3
287: AND process_id IN (SELECT process_id
288: FROM amw_execution_scope
289: START WITH process_id IN ( SELECT pk3
290: FROM amw_control_associations
291: WHERE object_type = 'PROJECT'
292: AND control_id = l_pk1
293: AND pk1 = l_pk2 --audit_project_id
294: AND pk2 = l_pk3 --organization_id

Line 451: FROM amw_control_associations

447: AND opin.audit_result_code <> 'EFFECTIVE';
448:
449: CURSOR get_total_controls IS
450: SELECT count(distinct control_id)
451: FROM amw_control_associations
452: WHERE object_type = 'PROJECT'
453: AND pk1 = p_audit_project_id
454: AND pk2 = p_org_id;
455:

Line 463: AND exists (select 'Y' FROM amw_control_associations

459: WHERE opinion_type_code = 'EVALUATION'
460: AND object_name = 'AMW_ORG_CONTROL'
461: AND pk2_value = p_audit_project_id
462: AND pk3_value = p_org_id
463: AND exists (select 'Y' FROM amw_control_associations
464: WHERE object_type = 'PROJECT'
465: AND pk1 = p_audit_project_id
466: AND pk2 = p_org_id
467: AND control_id = pk1_value);

Line 477: AND exists (select 'Y' FROM amw_control_associations

473: AND object_name = 'AMW_ORG_CONTROL'
474: AND audit_result_code <> 'EFFECTIVE'
475: AND pk2_value = p_audit_project_id
476: AND pk3_value = p_org_id
477: AND exists (select 'Y' FROM amw_control_associations
478: WHERE object_type = 'PROJECT'
479: AND pk1 = p_audit_project_id
480: AND pk2 = p_org_id
481: AND control_id = pk1_value);

Line 721: FROM amw_control_associations

717: AND risk_id = pk1_value);
718:
719: CURSOR get_total_controls IS
720: SELECT count(distinct control_id)
721: FROM amw_control_associations
722: WHERE object_type = 'PROJECT'
723: AND pk1 = p_audit_project_id
724: AND pk2 = p_org_id
725: AND pk3 IN (SELECT process_id

Line 738: FROM amw_control_associations assoc, amw_opinions_v opin

734: AND entity_type = PRIOR entity_type);
735:
736: CURSOR get_controls_evaluated IS
737: SELECT count(distinct opin.pk1_value)
738: FROM amw_control_associations assoc, amw_opinions_v opin
739: WHERE assoc.object_type = 'PROJECT'
740: AND assoc.pk1 = p_audit_project_id
741: AND assoc.pk2 = p_org_id
742: AND assoc.pk3 IN (SELECT process_id

Line 760: FROM amw_control_associations assoc, amw_opinions_v opin

756: AND opin.pk3_value = p_org_id;
757:
758: CURSOR get_ineff_controls IS
759: SELECT count(distinct opin.pk1_value)
760: FROM amw_control_associations assoc, amw_opinions_v opin
761: WHERE assoc.object_type = 'PROJECT'
762: AND assoc.pk1 = p_audit_project_id
763: AND assoc.pk2 = p_org_id
764: AND assoc.pk3 IN (SELECT process_id