DBA Data[Home] [Help]

APPS.BEN_CRD_SHD SQL Statements

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

Line: 74

    select
		crt_ordr_cvrd_per_id,
	crt_ordr_id,
	person_id,
	business_group_id,
	crd_attribute_category,
	crd_attribute1,
	crd_attribute2,
	crd_attribute3,
	crd_attribute4,
	crd_attribute5,
	crd_attribute6,
	crd_attribute7,
	crd_attribute8,
	crd_attribute9,
	crd_attribute10,
	crd_attribute11,
	crd_attribute12,
	crd_attribute13,
	crd_attribute14,
	crd_attribute15,
	crd_attribute16,
	crd_attribute17,
	crd_attribute18,
	crd_attribute19,
	crd_attribute20,
	crd_attribute21,
	crd_attribute22,
	crd_attribute23,
	crd_attribute24,
	crd_attribute25,
	crd_attribute26,
	crd_attribute27,
	crd_attribute28,
	crd_attribute29,
	crd_attribute30,
	object_version_number
    from	ben_crt_ordr_cvrd_per
    where	crt_ordr_cvrd_per_id = p_crt_ordr_cvrd_per_id;
Line: 180

    select 	crt_ordr_cvrd_per_id,
	crt_ordr_id,
	person_id,
	business_group_id,
	crd_attribute_category,
	crd_attribute1,
	crd_attribute2,
	crd_attribute3,
	crd_attribute4,
	crd_attribute5,
	crd_attribute6,
	crd_attribute7,
	crd_attribute8,
	crd_attribute9,
	crd_attribute10,
	crd_attribute11,
	crd_attribute12,
	crd_attribute13,
	crd_attribute14,
	crd_attribute15,
	crd_attribute16,
	crd_attribute17,
	crd_attribute18,
	crd_attribute19,
	crd_attribute20,
	crd_attribute21,
	crd_attribute22,
	crd_attribute23,
	crd_attribute24,
	crd_attribute25,
	crd_attribute26,
	crd_attribute27,
	crd_attribute28,
	crd_attribute29,
	crd_attribute30,
	object_version_number
    from	ben_crt_ordr_cvrd_per
    where	crt_ordr_cvrd_per_id = p_crt_ordr_cvrd_per_id
    for	update nowait;