DBA Data[Home] [Help]

APPS.AMW_LOAD_AP_DATA dependencies on AMW_AUDIT_PROCEDURES_VL

Line 438: FROM AMW_AUDIT_PROCEDURES_VL

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'