eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_FIN_COSO_VIEWS_PVT dependencies on AMW_CONTROL_ASSOCIATIONS

Line 84: amw_control_associations ctrlAsso

80: from
81: amw_fin_item_acc_ctrl ctrl,
82: amw_opinions_log_v opinion,
83: amw_assessment_components comp,
84: amw_control_associations ctrlAsso
85: where
86: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID and
87: ctrl.OBJECT_TYPE = 'FINANCIAL ITEM' and
88: ctrl.FINANCIAL_ITEM_ID= P_FINANCIAL_ITEM_ID and

Line 139: amw_control_associations ctrlAsso

135: from
136: amw_fin_item_acc_ctrl ctrl,
137: amw_opinions_v opinion,
138: amw_assessment_components comp,
139: amw_control_associations ctrlAsso
140: where
141: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID
142: and
143: ctrl.OBJECT_TYPE = 'FINANCIAL ITEM' and

Line 176: amw_control_associations ctrlAsso

172: from
173: amw_fin_item_acc_ctrl ctrl,
174: amw_opinions_log_v opinion,
175: amw_assessment_components comp,
176: amw_control_associations ctrlAsso
177: where
178: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID and
179: ctrl.OBJECT_TYPE = 'ACCOUNT' and
180: --ctrl.FINANCIAL_ITEM_ID= P_FINANCIAL_ITEM_ID and

Line 218: (SELECT 1 FROM AMW_CONTROL_ASSOCIATIONS CTRLASSO

214: AND OPINION.AUDIT_RESULT_CODE <> 'EFFECTIVE'
215: AND OPINION.OPINION_TYPE_CODE = 'EVALUATION'
216: AND OPINION.OBJECT_NAME = 'AMW_ORG_CONTROL'
217: AND EXISTS
218: (SELECT 1 FROM AMW_CONTROL_ASSOCIATIONS CTRLASSO
219: WHERE
220: CTRLASSO.OBJECT_TYPE='RISK_FINCERT'
221: AND OPINION.OPINION_LOG_ID = CTRLASSO.PK5
222: AND CTRLASSO.PK1 = P_CERTIFICATION_ID

Line 258: amw_control_associations ctrlAsso

254: from
255: amw_fin_item_acc_ctrl ctrl,
256: amw_opinions_log_v opinion,
257: amw_assessment_components comp,
258: amw_control_associations ctrlAsso
259: where
260: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID
261: and
262: ctrl.OBJECT_TYPE = 'ACCOUNT' and

Line 797: amw_control_associations ctrlAsso

793: from
794: amw.amw_fin_item_acc_ctrl ctrl,
795: amw_opinions_log_v opinion,
796: amw_control_objectives comp,
797: amw_control_associations ctrlAsso
798: where
799: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID and
800: ctrl.OBJECT_TYPE = 'FINANCIAL ITEM' and
801: ctrl.FINANCIAL_ITEM_ID= P_FINANCIAL_ITEM_ID and

Line 850: amw_control_associations ctrlAsso

846: from
847: amw.amw_fin_item_acc_ctrl ctrl,
848: amw_opinions_log_v opinion,
849: amw_control_objectives comp,
850: amw_control_associations ctrlAsso
851: where
852: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID
853: and
854: ctrl.OBJECT_TYPE = 'FINANCIAL ITEM' and

Line 885: amw_control_associations ctrlAsso

881: from
882: amw.amw_fin_item_acc_ctrl ctrl,
883: amw_opinions_log_v opinion,
884: amw_control_objectives comp,
885: amw_control_associations ctrlAsso
886: where
887: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID and
888: ctrl.OBJECT_TYPE = 'ACCOUNT' and
889: --ctrl.FINANCIAL_ITEM_ID= P_FINANCIAL_ITEM_ID and

Line 919: AMW_CONTROL_ASSOCIATIONS CTRLASSO

915: AND NATURAL_ACCOUNT_ID = P_ACCOUNT_ID
916: AND CTRL.CONTROL_REV_ID =COMP.CONTROL_REV_ID
917: AND EXISTS
918: (SELECT 1 FROM
919: AMW_CONTROL_ASSOCIATIONS CTRLASSO
920: WHERE
921: CTRLASSO.OBJECT_TYPE='RISK_FINCERT'
922: AND CTRLASSO.PK1 = P_CERTIFICATION_ID
923: AND CTRLASSO.PK2 = CTRL.ORGANIZATION_ID

Line 949: amw_control_associations ctrlAsso

945: from
946: amw.amw_fin_item_acc_ctrl ctrl,
947: amw_opinions_log_v opinion,
948: amw_control_objectives comp,
949: amw_control_associations ctrlAsso
950: where
951: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID
952: and
953: ctrl.OBJECT_TYPE = 'ACCOUNT' and

Line 1516: amw_control_associations ctrlAsso

1512: from
1513: amw.amw_fin_item_acc_ctrl ctrl,
1514: amw_opinions_log_v opinion,
1515: amw_control_assertions comp,
1516: amw_control_associations ctrlAsso
1517: where
1518: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID and
1519: ctrl.OBJECT_TYPE = 'FINANCIAL ITEM' and
1520: ctrl.FINANCIAL_ITEM_ID= P_FINANCIAL_ITEM_ID and

Line 1551: amw_control_associations ctrlAsso

1547: from
1548: amw.amw_fin_item_acc_ctrl ctrl,
1549: amw_opinions_v opinion,
1550: amw_control_assertions comp,
1551: amw_control_associations ctrlAsso
1552: where
1553: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID
1554: and
1555: ctrl.OBJECT_TYPE = 'FINANCIAL ITEM' and

Line 1608: amw_control_associations ctrlAsso

1604: from
1605: amw.amw_fin_item_acc_ctrl ctrl,
1606: amw_opinions_log_v opinion,
1607: amw_control_assertions comp,
1608: amw_control_associations ctrlAsso
1609: where
1610: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID and
1611: ctrl.OBJECT_TYPE = 'ACCOUNT' and
1612: --ctrl.FINANCIAL_ITEM_ID= P_FINANCIAL_ITEM_ID and

Line 1647: (SELECT 1 FROM AMW_CONTROL_ASSOCIATIONS CTRLASSO

1643: AND OPINION.AUDIT_RESULT_CODE <> 'EFFECTIVE'
1644: AND OPINION.OPINION_TYPE_CODE = 'EVALUATION'
1645: AND OPINION.OBJECT_NAME = 'AMW_ORG_CONTROL'
1646: AND EXISTS
1647: (SELECT 1 FROM AMW_CONTROL_ASSOCIATIONS CTRLASSO
1648: WHERE CTRLASSO.OBJECT_TYPE='RISK_FINCERT'
1649: AND OPINION.OPINION_LOG_ID = CTRLASSO.PK5
1650: AND CTRLASSO.PK1 = P_CERTIFICATION_ID
1651: AND CTRLASSO.PK2 = OPINION.PK3_VALUE

Line 1688: amw_control_associations ctrlAsso

1684: from
1685: amw.amw_fin_item_acc_ctrl ctrl,
1686: amw_opinions_log_v opinion,
1687: amw_control_assertions comp,
1688: amw_control_associations ctrlAsso
1689: where
1690: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID and
1691: ctrl.OBJECT_TYPE = 'ACCOUNT' and
1692: ctrl.ACCOUNT_GROUP_ID = P_ACCOUNT_GROUP_ID and