APPS.BEN_BLI_SHD SQL Statements

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

Line: 94

    select
	batch_ler_id,
	benefit_action_id,
	person_id,
	ler_id,
	lf_evt_ocrd_dt,
	replcd_flag,
	crtd_flag,
	tmprl_flag,
	dltd_flag,
        open_and_clsd_flag,
        clsd_flag,
        not_crtd_flag,
        stl_actv_flag,
        clpsd_flag,
        clsn_flag,
        no_effect_flag,
        cvrge_rt_prem_flag,
	per_in_ler_id,
	business_group_id,
	object_version_number
    from	ben_batch_ler_info
    where	batch_ler_id = p_batch_ler_id;

Line: 184

    select 	batch_ler_id,
	benefit_action_id,
	person_id,
	ler_id,
	lf_evt_ocrd_dt,
	replcd_flag,
	crtd_flag,
	tmprl_flag,
	dltd_flag,
        open_and_clsd_flag,
        clsd_flag,
        not_crtd_flag,
        stl_actv_flag,
        clpsd_flag,
        clsn_flag,
        no_effect_flag,
        cvrge_rt_prem_flag,
	per_in_ler_id,
	business_group_id,
	object_version_number
    from	ben_batch_ler_info
    where	batch_ler_id = p_batch_ler_id
    for	update nowait;