APPS.AMW_FIN_COSO_VIEWS_PVT dependencies on AMW_CONTROL_OBJECTIVES

Line 796: amw_control_objectives comp,

792: ctrl.ORGANIZATION_ID, ctrl.control_id, comp.OBJECTIVE_CODE
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

Line 826: amw_control_objectives comp

822: count(1) numOfCtrls,
823: comp.OBJECTIVE_CODE
824: from
825: amw.amw_fin_item_acc_ctrl ctrl,
826: amw_control_objectives comp
827: where
828: ctrl.FIN_CERTIFICATION_ID=P_CERTIFICATION_ID and
829: ctrl.OBJECT_TYPE = 'FINANCIAL ITEM' and
830: ctrl.FINANCIAL_ITEM_ID= P_FINANCIAL_ITEM_ID and

Line 849: amw_control_objectives comp,

845: ctrl.ORGANIZATION_ID, ctrl.control_id, comp.OBJECTIVE_CODE
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

Line 884: amw_control_objectives comp,

880: ctrl.ORGANIZATION_ID, ctrl.control_id, comp.OBJECTIVE_CODE
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

Line 910: AMW_CONTROL_OBJECTIVES COMP

906: SELECT COUNT(1) NUMINEFFCTRLS, OBJECTIVE_CODE
907: FROM
908: (SELECT DISTINCT CTRL.ORGANIZATION_ID, CTRL.CONTROL_ID, COMP.OBJECTIVE_CODE
909: FROM AMW.AMW_FIN_ITEM_ACC_CTRL CTRL,
910: AMW_CONTROL_OBJECTIVES COMP
911: WHERE
912: CTRL.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID
913: AND CTRL.OBJECT_TYPE = 'ACCOUNT'
914: AND CTRL.ACCOUNT_GROUP_ID = P_ACCOUNT_GROUP_ID

Line 948: amw_control_objectives comp,

944: ctrl.ORGANIZATION_ID, ctrl.control_id, comp.OBJECTIVE_CODE
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

Line 977: amw_control_objectives comp

973: count(1) numOfCtrls,
974: comp.OBJECTIVE_CODE
975: from
976: amw.amw_fin_item_acc_ctrl ctrl,
977: amw_control_objectives comp
978: where
979: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID and
980: ctrl.OBJECT_TYPE = 'ACCOUNT' and
981: -- ctrl.FINANCIAL_ITEM_ID= P_FINANCIAL_ITEM_ID and

Line 989: -- *************** Currsor to get all Control AMW_CONTROL_OBJECTIVES ********** --

985: group by OBJECTIVE_CODE;
986:
987:
988:
989: -- *************** Currsor to get all Control AMW_CONTROL_OBJECTIVES ********** --
990:
991: cursor CTRL_OBJECTIVES
992: is
993: select

Line 997: where lookup_type = 'AMW_CONTROL_OBJECTIVES';

993: select
994: LOOKUP_CODE
995: from
996: amw_lookups
997: where lookup_type = 'AMW_CONTROL_OBJECTIVES';
998:
999: --********************* Get Inefftive Control *************************************************--
1000:
1001:

Line 1707: -- *************** Currsor to get all Control AMW_CONTROL_OBJECTIVES ********** --

1703: group by ASSERTION_CODE;
1704:
1705:
1706:
1707: -- *************** Currsor to get all Control AMW_CONTROL_OBJECTIVES ********** --
1708:
1709: cursor CTRL_ASSERTIONS
1710: is
1711: select

Line 3745: amw_control_objectives comp

3741: distinct
3742: comp.OBJECTIVE_CODE
3743: from
3744: amw.amw_fin_item_acc_ctrl ctrl,
3745: amw_control_objectives comp
3746: where
3747: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID
3748: and
3749: ctrl.OBJECT_TYPE = 'FINANCIAL ITEM' and

Line 4112: amw_control_objectives comp

4108: distinct
4109: comp.OBJECTIVE_CODE
4110: from
4111: amw.amw_fin_item_acc_ctrl ctrl,
4112: amw_control_objectives comp
4113: where
4114: ctrl.FIN_CERTIFICATION_ID= P_CERTIFICATION_ID
4115: and
4116: ctrl.OBJECT_TYPE = 'ACCOUNT' and