[Home] [Help]
434: --GET THE AP_ID
435: BEGIN
436: SELECT AUDIT_PROCEDURE_ID,AUDIT_PROCEDURE_REV_ID
437: INTO L_AUDIT_PROCEDURE_ID,L_AUDIT_PROCEDURE_REV_ID
438: FROM AMW_AUDIT_PROCEDURES_VL
439: WHERE NAME=AP_REC.AP_NAME
440: AND LATEST_REVISION_FLAG='Y';
441:
442: ---03.01.2005 npanandi: call for LoadAP reqd. only if this has l_has_access='T'