DBA Data[Home] [Help]

APPS.PER_GRA_SHD SQL Statements

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

Line: 67

    select
		cagr_grade_id,
	cagr_grade_structure_id,
	cagr_grade_def_id,
	sequence,
	object_version_number
    from	per_cagr_grades
    where	cagr_grade_id = p_cagr_grade_id;
Line: 142

    select cagr_grade_id,
	cagr_grade_structure_id,
	cagr_grade_def_id,
	sequence,
	object_version_number
    from	per_cagr_grades
    where	cagr_grade_id = p_cagr_grade_id
    for	update nowait;