281: is
282: select
283: LOOKUP_CODE
284: from
285: amw_lookups
286: where lookup_type = 'AMW_ASSESSMENT_COMPONENTS';
287:
288: --********************* Get Inefftive Control *************************************************--
289:
992: is
993: select
994: LOOKUP_CODE
995: from
996: amw_lookups
997: where lookup_type = 'AMW_CONTROL_OBJECTIVES';
998:
999: --********************* Get Inefftive Control *************************************************--
1000:
1710: is
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: /*