APPS.BEN_XRE_SHD SQL Statements

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

Line: 69

    select
		ext_rslt_err_id,
	err_num,
        err_txt,
	typ_cd,
	person_id,
	business_group_id,
	object_version_number,
	request_id,
	program_application_id,
	program_id,
	program_update_date,
        ext_rslt_id
    from	ben_ext_rslt_err
    where	ext_rslt_err_id = p_ext_rslt_err_id;

Line: 151

    select 	ext_rslt_err_id,
	err_num,
        err_txt,
	typ_cd,
	person_id,
	business_group_id,
	object_version_number,
	request_id,
	program_application_id,
	program_id,
	program_update_date,
        ext_rslt_id
    from	ben_ext_rslt_err
    where	ext_rslt_err_id = p_ext_rslt_err_id
    for	update nowait;

Line: 225

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

Line: 249

  l_rec.program_update_date              := p_program_update_date;