APPS.AMW_FIN_COSO_VIEWS_PVT dependencies on AMW_CONTROL_ASSERTIONS

Line 1515: amw_control_assertions comp,

1511: ctrl.ORGANIZATION_ID, ctrl.control_id, comp.ASSERTION_CODE
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

Line 1550: amw_control_assertions comp,

1546: ctrl.ORGANIZATION_ID, ctrl.control_id, comp.ASSERTION_CODE
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

Line 1579: amw_control_assertions comp

1575: count(1) numOfCtrls,
1576: comp.ASSERTION_CODE
1577: from
1578: amw.amw_fin_item_acc_ctrl ctrl,
1579: amw_control_assertions comp
1580: where
1581: ctrl.FIN_CERTIFICATION_ID=P_CERTIFICATION_ID and
1582: ctrl.OBJECT_TYPE = 'FINANCIAL ITEM' and
1583: ctrl.FINANCIAL_ITEM_ID= P_FINANCIAL_ITEM_ID and

Line 1607: amw_control_assertions comp,

1603: ctrl.ORGANIZATION_ID, ctrl.control_id, comp.ASSERTION_CODE
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

Line 1632: FROM AMW.AMW_FIN_ITEM_ACC_CTRL CTRL, AMW_CONTROL_ASSERTIONS COMP

1628: ***/
1629: SELECT COUNT(1) NUMINEFFCTRLS, ASSERTION_CODE
1630: FROM
1631: (SELECT DISTINCT CTRL.ORGANIZATION_ID, CTRL.CONTROL_ID, COMP.ASSERTION_CODE
1632: FROM AMW.AMW_FIN_ITEM_ACC_CTRL CTRL, AMW_CONTROL_ASSERTIONS COMP
1633: WHERE
1634: CTRL.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID
1635: AND CTRL.OBJECT_TYPE = 'ACCOUNT'
1636: AND CTRL.ACCOUNT_GROUP_ID = P_ACCOUNT_GROUP_ID

Line 1664: amw_control_assertions comp

1660: count(1) numOfCtrls,
1661: comp.ASSERTION_CODE
1662: from
1663: amw.amw_fin_item_acc_ctrl ctrl,
1664: amw_control_assertions comp
1665: where
1666: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID and
1667: ctrl.OBJECT_TYPE = 'ACCOUNT' and
1668: -- ctrl.FINANCIAL_ITEM_ID= P_FINANCIAL_ITEM_ID and

Line 1687: amw_control_assertions comp,

1683: ctrl.ORGANIZATION_ID, ctrl.control_id, comp.ASSERTION_CODE
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

Line 1715: where lookup_type = 'AMW_CONTROL_ASSERTIONS';

1711: select
1712: LOOKUP_CODE
1713: from
1714: amw_lookups
1715: where lookup_type = 'AMW_CONTROL_ASSERTIONS';
1716:
1717: --********************* Get Account Assertion COdes FOR AN ACCOUNT *************************************************--
1718: /*
1719: cursor ACC_ASSERT_CODES

Line 4501: amw_control_assertions comp

4497: distinct
4498: comp.ASSERTION_CODE
4499: from
4500: amw.amw_fin_item_acc_ctrl ctrl,
4501: amw_control_assertions comp
4502: where
4503: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID
4504: and
4505: ctrl.OBJECT_TYPE = 'FINANCIAL ITEM' and

Line 4993: amw_control_assertions comp

4989: distinct
4990: comp.ASSERTION_CODE
4991: from
4992: amw.amw_fin_item_acc_ctrl ctrl,
4993: amw_control_assertions comp
4994: where
4995: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID
4996: and
4997: ctrl.OBJECT_TYPE = 'ACCOUNT' and