APPS.BEN_ERC_SHD SQL Statements

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

Line: 74

    select
		enrt_rt_ctfn_id,
	enrt_ctfn_typ_cd,
	rqd_flag,
	enrt_rt_id,
	business_group_id,
	erc_attribute_category,
	erc_attribute1,
	erc_attribute2,
	erc_attribute3,
	erc_attribute4,
	erc_attribute5,
	erc_attribute6,
	erc_attribute7,
	erc_attribute8,
	erc_attribute9,
	erc_attribute10,
	erc_attribute11,
	erc_attribute12,
	erc_attribute13,
	erc_attribute14,
	erc_attribute15,
	erc_attribute16,
	erc_attribute17,
	erc_attribute18,
	erc_attribute19,
	erc_attribute20,
	erc_attribute21,
	erc_attribute22,
	erc_attribute23,
	erc_attribute24,
	erc_attribute25,
	erc_attribute26,
	erc_attribute27,
	erc_attribute28,
	erc_attribute29,
	erc_attribute30,
	request_id,
	program_application_id,
	program_id,
	program_update_date,
	object_version_number
    from	ben_enrt_rt_ctfn
    where	enrt_rt_ctfn_id = p_enrt_rt_ctfn_id;

Line: 185

    select 	enrt_rt_ctfn_id,
	enrt_ctfn_typ_cd,
	rqd_flag,
	enrt_rt_id,
	business_group_id,
	erc_attribute_category,
	erc_attribute1,
	erc_attribute2,
	erc_attribute3,
	erc_attribute4,
	erc_attribute5,
	erc_attribute6,
	erc_attribute7,
	erc_attribute8,
	erc_attribute9,
	erc_attribute10,
	erc_attribute11,
	erc_attribute12,
	erc_attribute13,
	erc_attribute14,
	erc_attribute15,
	erc_attribute16,
	erc_attribute17,
	erc_attribute18,
	erc_attribute19,
	erc_attribute20,
	erc_attribute21,
	erc_attribute22,
	erc_attribute23,
	erc_attribute24,
	erc_attribute25,
	erc_attribute26,
	erc_attribute27,
	erc_attribute28,
	erc_attribute29,
	erc_attribute30,
	request_id,
	program_application_id,
	program_id,
	program_update_date,
	object_version_number
    from	ben_enrt_rt_ctfn
    where	enrt_rt_ctfn_id = p_enrt_rt_ctfn_id
    for	update nowait;

Line: 317

	p_program_update_date           in date,
	p_object_version_number         in number
	)
	Return g_rec_type is
--
  l_rec	  g_rec_type;

Line: 370

  l_rec.program_update_date              := p_program_update_date;