APPS.BEN_BAI_SHD SQL Statements

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

Line: 64

    select
		batch_actn_item_id,
	benefit_action_id,
	person_id,
	actn_typ_id,
	cmpltd_dt,
	due_dt,
	rqd_flag,
	actn_cd,
	business_group_id,
	object_version_number
    from	ben_batch_actn_item_info
    where	batch_actn_item_id = p_batch_actn_item_id;

Line: 144

    select 	batch_actn_item_id,
	benefit_action_id,
	person_id,
	actn_typ_id,
	cmpltd_dt,
	due_dt,
	rqd_flag,
	actn_cd,
	business_group_id,
	object_version_number
    from	ben_batch_actn_item_info
    where	batch_actn_item_id = p_batch_actn_item_id
    for	update nowait;