APPS.BEN_BDI_SHD SQL Statements

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

Line: 74

    select
		batch_dpnt_id,
	benefit_action_id,
	person_id,
	pgm_id,
	pl_id,
	oipl_id,
	contact_typ_cd,
	dpnt_person_id,
	business_group_id,
	object_version_number,
	enrt_cvg_strt_dt,
	enrt_cvg_thru_dt,
	actn_cd
    from	ben_batch_dpnt_info
    where	batch_dpnt_id = p_batch_dpnt_id;

Line: 157

    select 	batch_dpnt_id,
	benefit_action_id,
	person_id,
	pgm_id,
	pl_id,
	oipl_id,
	contact_typ_cd,
	dpnt_person_id,
	business_group_id,
	object_version_number,
	enrt_cvg_strt_dt,
	enrt_cvg_thru_dt,
	actn_cd
    from	ben_batch_dpnt_info
    where	batch_dpnt_id = p_batch_dpnt_id
    for	update nowait;