APPS.BEN_BMN_SHD SQL Statements

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

Line: 69

    select
	reporting_id,
	benefit_action_id,
	thread_id,
	sequence,
	text,
        rep_typ_cd,
        error_message_code,
        national_identifier,
        related_person_ler_id,
        temporal_ler_id,
        ler_id,
        person_id,
        pgm_id,
        pl_id,
        related_person_id,
        oipl_id,
        pl_typ_id,
        actl_prem_id                      ,
        val                               ,
        mo_num                            ,
        yr_num                            ,
	object_version_number
    from	ben_reporting
    where	reporting_id = p_reporting_id;

Line: 161

    select 	reporting_id,
	benefit_action_id,
	thread_id,
	sequence,
	text,
        rep_typ_cd,
        error_message_code,
        national_identifier,
        related_person_ler_id,
        temporal_ler_id,
        ler_id,
        person_id,
        pgm_id,
        pl_id,
        related_person_id,
        oipl_id,
        pl_typ_id,
        actl_prem_id                      ,
        val                               ,
        mo_num                            ,
        yr_num                            ,
	object_version_number
    from	ben_reporting
    where	reporting_id = p_reporting_id
    for	update nowait;