APPS.PER_JOB_REQUIREMENTS_PKG SQL Statements

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

Line: 6

cursor c1 is select per_job_requirements_s.nextval
	     from sys.dual;

Line: 33

cursor csr_requirement is select null
		  from   per_job_requirements pjr
		  where  ((p_rowid is not null and
			  rowidtochar(rowid) <> p_rowid    )
		  or      p_rowid is null)
		  and    pjr.job_id = p_job_id
		  and    pjr.analysis_criteria_id = p_analysis_criteria_id;