[Home] [Help]
39: SELECT control_association_id ,control_id from amw_control_associations
40: where object_type='RISK_ORG'
41: and pk1 In (
42: select risk_association_id
43: from amw_risk_associations
44: where object_type='PROCESS_ORG' and pk1= p_process_organization_id
45: and risk_id = p_risk_id );
46:
47: delete_ctrl_org cc5 %ROWTYPE;
81: -- abb added
82: IF (p_association_mode = 'ASSOCIATE') THEN
83: IF (p_object = 'RISK_ORG') THEN
84:
85: select risk_association_id into l_risk_assoc_id from amw_risk_associations where risk_id = p_risk_id and pk1 = p_process_organization_id and object_type = 'PROCESS_ORG';
86:
87: insert into amw_control_associations
88: (CONTROL_ASSOCIATION_ID,
89: LAST_UPDATE_DATE,
318: and pk2 = ( SELECT process_id from amw_process_organization
319: where process_organization_id = p_process_organization_id )
320: AND pk3 = delete_ctrl_org.control_id
321: and
322: not exists ( select control_id from amw_control_associations aca, amw_risk_associations ara
323: where aca.pk1= ara.risk_association_id
324: and ara.object_type = 'PROCESS_ORG'
325: and aca.object_type = 'RISK_ORG'
326: and control_id = delete_ctrl_org.control_id ) ;
339: and pk2 = ( SELECT process_id from amw_process_organization
340: where process_organization_id = p_process_organization_id )
341: AND pk3 = p_control_id
342: and
343: not exists ( select control_id from amw_control_associations aca, amw_risk_associations ara
344: where aca.pk1= ara.risk_association_id
345: and ara.object_type = 'PROCESS_ORG'
346: and aca.object_type = 'RISK_ORG'
347: and control_id = p_control_id );