APPS.BEN_BPI_SHD SQL Statements

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

Line: 74

    select
	batch_proc_id,
	benefit_action_id,
	strt_dt,
	end_dt,
	strt_tm,
	end_tm,
	elpsd_tm,
	per_slctd,
	per_proc,
	per_unproc,
	per_proc_succ  ,
	per_err,
	business_group_id,
	object_version_number
    from	ben_batch_proc_info
    where	batch_proc_id = p_batch_proc_id;

Line: 158

    select 	batch_proc_id,
	benefit_action_id,
	strt_dt,
	end_dt,
	strt_tm,
	end_tm,
	elpsd_tm,
	per_slctd,
	per_proc,
	per_unproc,
	per_proc_succ  ,
	per_err,
	business_group_id,
	object_version_number
    from	ben_batch_proc_info
    where	batch_proc_id = p_batch_proc_id
    for	update nowait;