DBA Data[Home] [Help]

APPS.PAY_KW_MONTHLY_REPORTS dependencies on V$PARAMETER

Line 2904: FROM v$parameter

2900: -- Getting the Util file directory name.mostly it'll be /sqlcom/outbound )
2901: BEGIN
2902: SELECT value
2903: INTO l_audit_log_dir
2904: FROM v$parameter
2905: WHERE LOWER(name) = 'utl_file_dir';
2906: -- Check whether more than one util file directory is found
2907: IF INSTR(l_audit_log_dir,',') > 0 THEN
2908: l_audit_log_dir := substr(l_audit_log_dir,1,instr(l_audit_log_dir,',')-1);