APPS.BEN_EXT_ACTN SQL Statements

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

Line: 52

    select
	     type.actn_typ_id     	action_id
	    ,type.name			action_name
	    ,type.description		action_desc
	    ,type.type_cd		action_type
          ,actn.due_dt		action_due_dt
	    ,actn.rqd_flag		action_rqd_flag
          ,actn.cmpltd_dt             action_cmpltd_dt
          ,actn.prtt_enrt_actn_id
	from ben_actn_typ    		type,
             ben_prtt_enrt_actn_f 	actn,
	     ben_prtt_enrt_rslt_f	rslt
       where
            actn.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
        and p_effective_date between actn.effective_start_date
                                 and actn.effective_end_date
        and actn.actn_typ_id = type.actn_typ_id
        and actn.prtt_enrt_rslt_id = rslt.prtt_enrt_rslt_id
        and rslt.person_id = p_person_id
      ;