APPS.PER_ZA_EQT_SHD SQL Statements

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

Line: 65

    select
	a.qualification_type_id,
	b.nqf_qualification_type,
	a.name,
	a.category,
	a.rank,
	a.attribute_category,
	a.attribute1,
	a.attribute2,
	a.attribute3,
	a.attribute4,
	a.attribute5,
	a.attribute6,
	a.attribute7,
	a.attribute8,
	a.attribute9,
	a.attribute10,
	a.attribute11,
	a.attribute12,
	a.attribute13,
	a.attribute14,
	a.attribute15,
	a.attribute16,
	a.attribute17,
	a.attribute18,
	a.attribute19,
	a.attribute20,
	a.object_version_number
    from	per_qualification_types a,
			per_za_qualification_types b
    where	a.qualification_type_id = p_qualification_type_id and
			a.qualification_type_id = b.qualification_type_id(+);

Line: 164

    select
	a.qualification_type_id,
	b.nqf_qualification_type,
	a.name,
	a.category,
	a.rank,
	a.attribute_category,
	a.attribute1,
	a.attribute2,
	a.attribute3,
	a.attribute4,
	a.attribute5,
	a.attribute6,
	a.attribute7,
	a.attribute8,
	a.attribute9,
	a.attribute10,
	a.attribute11,
	a.attribute12,
	a.attribute13,
	a.attribute14,
	a.attribute15,
	a.attribute16,
	a.attribute17,
	a.attribute18,
	a.attribute19,
	a.attribute20,
	a.object_version_number
    from	per_qualification_types a,
			per_za_qualification_types b
    where	a.qualification_type_id = p_qualification_type_id and
			a.qualification_type_id = b.qualification_type_id(+)
    for	update nowait;