APPS.AMW_PROC_ORG_APPROVAL_PKG dependencies on AMW_RISK_ASSOCIATIONS

Line 482: update amw_risk_associations

478:
479: procedure approve_associations(p_process_id in number, p_org_id in number) is
480:
481: begin
482: update amw_risk_associations
483: set approval_date = APPROV_TXN_DATE
484: where pk2 = p_process_id
485: and pk1 = p_org_id
486: and object_type = 'PROCESS_ORG'

Line 489: update amw_risk_associations

485: and pk1 = p_org_id
486: and object_type = 'PROCESS_ORG'
487: and approval_date is null;
488:
489: update amw_risk_associations
490: set deletion_approval_date = APPROV_TXN_DATE
491: where pk2 = p_process_id
492: and pk1 = p_org_id
493: and object_type = 'PROCESS_ORG'

Line 780: select risk_id from amw_risk_associations where pk2 = pid and pk1 = poid and object_type = 'PROCESS_ORG';

776: select pid from dual;
777: */
778:
779: cursor ass_risks (pid number, poid number) is
780: select risk_id from amw_risk_associations where pk2 = pid and pk1 = poid and object_type = 'PROCESS_ORG';
781:
782: cursor ass_controls (pid number, poid number) is
783: select control_id from amw_control_associations where pk2 = pid and pk1 = poid and object_type = 'RISK_ORG';
784: