APPS.BEN_XRS_SHD SQL Statements

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

Line: 74

    select
        ext_rslt_id,
	run_strt_dt,
	run_end_dt,
	ext_stat_cd,
	tot_rec_num,
	tot_per_num,
	tot_err_num,
	eff_dt,
	ext_strt_dt,
	ext_end_dt,
	output_name,
	drctry_name,
	ext_dfn_id,
	business_group_id,
	program_application_id,
	program_id,
	program_update_date,
	request_id,
        output_type,
        xdo_template_id,
	object_version_number
    from	ben_ext_rslt
    where	ext_rslt_id = p_ext_rslt_id;

Line: 165

    select 	ext_rslt_id,
	run_strt_dt,
	run_end_dt,
	ext_stat_cd,
	tot_rec_num,
	tot_per_num,
	tot_err_num,
	eff_dt,
	ext_strt_dt,
	ext_end_dt,
	output_name,
	drctry_name,
	ext_dfn_id,
	business_group_id,
	program_application_id,
	program_id,
	program_update_date,
	request_id,
        output_type,
        xdo_template_id,
	object_version_number
    from	ben_ext_rslt
    where	ext_rslt_id = p_ext_rslt_id
    for	update nowait;

Line: 254

	p_program_update_date           in date,
	p_request_id                    in number,
        p_output_type                   in varchar2,
        p_xdo_template_id               in number,
	p_object_version_number         in number
	)
	Return g_rec_type is
--
  l_rec	  g_rec_type;

Line: 287

  l_rec.program_update_date              := p_program_update_date;