APPS.BEN_SS_DTCT_PTNL_LER SQL Statements

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

Line: 46

		select ptn.ptnl_ler_for_per_id,
                    ptn.ptnl_ler_for_per_stat_cd
                    from ben_ptnl_ler_for_per ptn
                    where ptn.person_id = p_person_id
                    and ptn.business_group_id =  p_business_group_id
                    and ptn.lf_evt_ocrd_dt <=  p_effective_date ;