APPS.AMW_PROC_APPROVAL_PKG dependencies on AMW_RISK_ASSOCIATIONS

Line 304: update amw_risk_associations

300:
301: procedure approve_associations(p_process_id in number) is
302:
303: begin
304: update amw_risk_associations
305: set approval_date = APPROV_TXN_DATE
306: where pk1 = p_process_id
307: and object_type = 'PROCESS'
308: and approval_date is null;

Line 310: update amw_risk_associations

306: where pk1 = p_process_id
307: and object_type = 'PROCESS'
308: and approval_date is null;
309:
310: update amw_risk_associations
311: set deletion_approval_date = APPROV_TXN_DATE
312: where pk1 = p_process_id
313: and object_type = 'PROCESS'
314: and deletion_date is not null

Line 572: select risk_id from amw_risk_associations where pk1 = pid and object_type = 'PROCESS';

568: union
569: select pid from dual;
570:
571: cursor ass_risks (pid number) is
572: select risk_id from amw_risk_associations where pk1 = pid and object_type = 'PROCESS';
573:
574: cursor ass_controls (pid number) is
575: select control_id from amw_control_associations where pk1 = pid and object_type = 'RISK';
576: