DBA Data[Home] [Help]

APPS.PAY_KW_ANNUAL_REPORTS dependencies on V$PARAMETER

Line 2776: FROM v$parameter

2772: -- Getting the Util file directory name.mostly it'll be /sqlcom/outbound )
2773: BEGIN
2774: SELECT value
2775: INTO l_audit_log_dir
2776: FROM v$parameter
2777: WHERE LOWER(name) = 'utl_file_dir';
2778: -- Check whether more than one util file directory is found
2779: IF INSTR(l_audit_log_dir,',') > 0 THEN
2780: l_audit_log_dir := substr(l_audit_log_dir,1,instr(l_audit_log_dir,',')-1);