APPS.AMW_FINSTMT_CERT_MIG_PKG dependencies on AMW_RISK_ASSOCIATIONS

Line 577: AMW_RISK_ASSOCIATIONS risks,

573: risks.DELETION_DATE,
574: risks.DELETION_APPROVAL_DATE,
575: risk.RISK_REV_ID
576: FROM
577: AMW_RISK_ASSOCIATIONS risks,
578: AMW_FIN_PROCESS_EVAL_SUM eval,
579: AMW_RISKS_B risk
580: WHERE
581: eval.fin_certification_id = p_certification_id

Line 601: AMW_RISK_ASSOCIATIONS risks,

597: risks.DELETION_DATE,
598: risks.DELETION_APPROVAL_DATE,
599: risk.RISK_REV_ID
600: FROM
601: AMW_RISK_ASSOCIATIONS risks,
602: AMW_FIN_PROCESS_EVAL_SUM eval,
603: AMW_RISKS_B risk
604: WHERE
605: eval.fin_certification_id = p_certification_id

Line 671: SELECT COUNT(1) INTO l_count FROM AMW_RISK_ASSOCIATIONS

667: -- Initialize API return status to SUCCESS
668: x_return_status := FND_API.G_RET_STS_SUCCESS;
669:
670:
671: SELECT COUNT(1) INTO l_count FROM AMW_RISK_ASSOCIATIONS
672: WHERE object_type = 'PROCESS_FINCERT'
673: AND pk1 = p_certification_id;
674:
675: IF (l_count = 0) THEN

Line 686: INSERT INTO AMW_RISK_ASSOCIATIONS(

682: CLOSE last_evaluation;
683:
684:
685:
686: INSERT INTO AMW_RISK_ASSOCIATIONS(
687: RISK_ASSOCIATION_ID,
688: RISK_ID,
689: PK1,
690: PK2,

Line 705: VALUES ( amw_risk_associations_s.nextval,

701: APPROVAL_DATE,
702: DELETION_DATE,
703: DELETION_APPROVAL_DATE,
704: RISK_REV_ID)
705: VALUES ( amw_risk_associations_s.nextval,
706: risk_rec.risk_id,
707: p_certification_id,
708: risk_rec.PK1,
709: risk_rec.PK2,

Line 784: AMW_RISK_ASSOCIATIONS risks,

780: controls.DELETION_DATE,
781: controls.DELETION_APPROVAL_DATE,
782: control.CONTROL_REV_ID
783: FROM
784: AMW_RISK_ASSOCIATIONS risks,
785: AMW_CONTROL_ASSOCIATIONS controls,
786: AMW_CONTROLS_B control
787: WHERE
788: controls.object_type='RISK_ORG'

Line 808: AMW_RISK_ASSOCIATIONS risks,

804: controls.DELETION_DATE,
805: controls.DELETION_APPROVAL_DATE,
806: control.CONTROL_REV_ID
807: FROM
808: AMW_RISK_ASSOCIATIONS risks,
809: AMW_CONTROL_ASSOCIATIONS controls,
810: AMW_CONTROLS_B control
811: WHERE
812: controls.object_type='ENTITY_CONTROL'

Line 1507: amw_risk_associations risk

1503: OBJECT_VERSION_NUMBER )
1504: SELECT distinct 'ACCOUNT' OBJECT_TYPE , fin_certification_id, statement_group_id, financial_statement_id, null financial_item_id,
1505: account_group_id, natural_account_id, organization_id, process_id, risk_id, risk_rev_id, pk4 opinion_log_id, 1, sysdate, 1, sysdate, 1, null, 1
1506: from amw_fin_cert_scope scp,
1507: amw_risk_associations risk
1508: where risk.pk1 = scp.fin_certification_id
1509: and risk.object_type = 'PROCESS_FINCERT'
1510: and scp.natural_account_id is not null
1511: and scp.organization_id = risk.pk2

Line 1518: amw_risk_associations risk

1514: union all
1515: select distinct 'FINANCIAL ITEM' OBJECT_TYPE, fin_certification_id, statement_group_id, financial_statement_id, financial_item_id,
1516: null account_group_id, null natural_account_id, organization_id, process_id, risk_id, risk_rev_id, pk4 opinion_log_id, 1, sysdate, 1, sysdate, 1, null, 1
1517: from amw_fin_cert_scope scp,
1518: amw_risk_associations risk
1519: where risk.pk1 = scp.fin_certification_id
1520: and risk.object_type = 'PROCESS_FINCERT'
1521: and scp.organization_id = risk.pk2
1522: and scp.process_id = risk.pk3

Line 1528: amw_risk_associations risk

1524: union all
1525: select distinct 'FINANCIAL STATEMENT' OBJECT_TYPE, fin_certification_id, statement_group_id, financial_statement_id, null financial_item_id,
1526: null account_group_id, null natural_account_id, organization_id, process_id, risk_id, risk_rev_id, pk4 opinion_log_id, 1, sysdate, 1, sysdate, 1, null, 1
1527: from amw_fin_cert_scope scp,
1528: amw_risk_associations risk
1529: where risk.pk1 = scp.fin_certification_id
1530: and risk.object_type = 'PROCESS_FINCERT'
1531: and scp.organization_id = risk.pk2
1532: and scp.process_id = risk.pk3