APPS.PAY_NL_XDO_REPORT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 379

	Select file_data Into p_pdf_blob
	From fnd_lobs
	Where file_id = (select file_id from per_gb_xdo_templates
			 where file_id=p_template_id and
			 fnd_date.canonical_to_date(p_year) between EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE);

Line: 420

                SELECT value
                INTO l_audit_log_dir
                FROM v$parameter
                WHERE LOWER(name) = 'utl_file_dir';

Line: 514

                SELECT value
                INTO l_audit_log_dir
                FROM v$parameter
                WHERE LOWER(name) = 'utl_file_dir';