APPS.OKL_AM_QA_DATA_INTEGRITY_PVT SQL Statements

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

Line: 91

		SELECT  khr.khr_id	prog_khr_id
		FROM    okl_k_headers	khr
		WHERE	khr.id		= cp_chr_id;

Line: 1393

		SELECT	pr.id			cpl_id
		FROM	okc_k_party_roles_b	pr
		WHERE	pr.rle_code		= 'OKL_VENDOR'
		AND	pr.cle_id		IS NULL
		AND	pr.chr_id		= cp_chr_id
		AND	pr.dnz_chr_id		= cp_chr_id;

Line: 1700

		SELECT	SYS_CONTEXT ('USERENV','NLS_DATE_FORMAT')
		FROM	dual;

Line: 1705

		SELECT	end_date
		FROM	okc_k_headers_b
		WHERE	id = cp_chr_id;