988: apb.AUDIT_PROCEDURE_REV_ID
989: FROM
990: AMW_AP_ASSOCIATIONS ap,
991: AMW_CONTROL_ASSOCIATIONS controls,
992: AMW_AUDIT_PROCEDURES_B apb
993: WHERE
994: ap.object_type='CTRL_ORG'
995: and apb.CURR_APPROVED_FLAG = 'Y'
996: and ap.audit_procedure_id = apb.audit_procedure_id
1012: apb.AUDIT_PROCEDURE_REV_ID
1013: FROM
1014: AMW_AP_ASSOCIATIONS ap,
1015: AMW_CONTROL_ASSOCIATIONS controls,
1016: AMW_AUDIT_PROCEDURES_B apb
1017: WHERE
1018: ap.object_type='ENTITY_CTRL_AP'
1019: and apb.CURR_APPROVED_FLAG = 'Y'
1020: and ap.audit_procedure_id = apb.audit_procedure_id