DBA Data[Home] [Help]

APPS.PAY_KW_ANNUAL_REPORTS dependencies on V$PARAMETER

Line 2600: FROM v$parameter

2596: -- Getting the Util file directory name.mostly it'll be /sqlcom/outbound )
2597: BEGIN
2598: SELECT value
2599: INTO l_audit_log_dir
2600: FROM v$parameter
2601: WHERE LOWER(name) = 'utl_file_dir';
2602: -- Check whether more than one util file directory is found
2603: IF INSTR(l_audit_log_dir,',') > 0 THEN
2604: l_audit_log_dir := substr(l_audit_log_dir,1,instr(l_audit_log_dir,',')-1);