DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_LIST_VAL_PVT dependencies on AP_LOOKUP_CODES

Line 361: from ap_lookup_codes lu

357: | Cursor to verify that the given audit reason is valid and active. |
358: *===================================================================*/
359: CURSOR reason_cur(p_lookup_code VARCHAR2) IS
360: select lookup_code
361: from ap_lookup_codes lu
362: where lu.lookup_type = 'OIE_AUTO_AUDIT_REASONS'
363: and lu.lookup_code = p_lookup_code
364: and NVL(lu.enabled_flag,'Y') = 'Y'
365: AND TRUNC(SYSDATE)