DBA Data[Home] [Help]

APPS.PAY_KW_MONTHLY_REPORTS dependencies on V$PARAMETER

Line 2376: FROM v$parameter

2372: -- Getting the Util file directory name.mostly it'll be /sqlcom/outbound )
2373: BEGIN
2374: SELECT value
2375: INTO l_audit_log_dir
2376: FROM v$parameter
2377: WHERE LOWER(name) = 'utl_file_dir';
2378: -- Check whether more than one util file directory is found
2379: IF INSTR(l_audit_log_dir,',') > 0 THEN
2380: l_audit_log_dir := substr(l_audit_log_dir,1,instr(l_audit_log_dir,',')-1);