APPS.BEN_QUA_LER SQL Statements

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

Line: 12

select effective_date
from   fnd_sessions
where  session_id = userenv('SESSIONID');

Line: 18

 select ler.ler_id
 ,       ler.typ_cd
 ,      ler.ocrd_dt_det_cd
 from   ben_ler_f ler
 where  ler.business_group_id               = p_new.business_group_id
 and    l_session_date between ler.effective_start_date
 		       and    ler.effective_end_date
 and ( l_status = 'I' or ler.typ_cd in ('COMP','GSP','ABS','CHECKLIST') )
 and    ((exists
        (select 1
          from   ben_per_info_chg_cs_ler_f psl
          ,      ben_ler_per_info_cs_ler_f lpl
          where  source_table               = 'PER_QUALIFICATIONS'
          and    psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
          and    lpl.business_group_id    = psl.business_group_id
          and    lpl.business_group_id    = ler.business_group_id
          and    l_session_date between psl.effective_start_date
          and    psl.effective_end_date
 	   and    l_session_date between lpl.effective_start_date
           and    lpl.effective_end_date    -- For Bug 3299709
          and    lpl.ler_id                 = ler.ler_id)
	)
 OR      (exists
          (select 1
           from   ben_rltd_per_chg_cs_ler_f rpc
           ,      ben_ler_rltd_per_cs_ler_f lrp
           where  source_table               = 'PER_QUALIFICATIONS'
           and    lrp.business_group_id    = rpc.business_group_id
           and    lrp.business_group_id    = ler.business_group_id
           and    l_session_date between rpc.effective_start_date
           and    rpc.effective_end_date
   	   and    l_session_date between lrp.effective_start_date
           and    lrp.effective_end_date   -- For Bug 3299709
           and    rpc.rltd_per_chg_cs_ler_id = lrp.rltd_per_chg_cs_ler_id
           and    lrp.ler_id                 = ler.ler_id)
          ))
  order by ler.ler_id;

Line: 58

select psl.source_column
,      psl.new_val
,      psl.old_val
,      'P', psl.per_info_chg_cs_ler_rl, psl.rule_overrides_flag, lpl.chg_mandatory_cd
from   ben_ler_per_info_cs_ler_f lpl
,      ben_per_info_chg_cs_ler_f psl
where  lpl.ler_id                            = p_ler_id
and    lpl.business_group_id                 = p_new.business_group_id
and    lpl.business_group_id               = psl.business_group_id
and    l_session_date between
       psl.effective_start_date
and    psl.effective_end_date
and l_session_date between lpl.effective_start_date
and lpl.effective_end_date  -- For Bug 3299709
and    psl.per_info_chg_cs_ler_id            = lpl.per_info_chg_cs_ler_id
and    source_table                          = 'PER_QUALIFICATIONS'
UNION
select rpc.source_column
,      rpc.new_val
,      rpc.old_val
,      'R', rpc.rltd_per_chg_cs_ler_rl per_info_chg_cs_ler, rpc.rule_overrides_flag, lrp.chg_mandatory_cd
from   ben_ler_rltd_per_cs_ler_f lrp
,      ben_rltd_per_chg_cs_ler_f rpc
where  lrp.ler_id = p_ler_id
and    lrp.business_group_id                 = p_new.business_group_id
and    lrp.business_group_id               = rpc.business_group_id
and    l_session_date between
       rpc.effective_start_date
and    rpc.effective_end_date
and l_session_date between lrp.effective_start_date
and lrp.effective_end_date  -- For Bug 3299709
and    rpc.rltd_per_chg_cs_ler_id            = lrp.rltd_per_chg_cs_ler_id
and    source_table                          = 'PER_QUALIFICATIONS'
order by 1;

Line: 96

select 'Y'
from   ben_ptnl_ler_for_per
where  person_id                             = p_person_id
and    ler_id                                = p_ler_id
and    ptnl_ler_for_per_stat_cd              = 'DTCTD'
and    lf_evt_ocrd_dt                        = p_lf_evt_ocrd_dt;

Line: 104

select person_id
from per_contact_relationships
where contact_person_id = p_person_id
and business_group_id = p_new.business_group_id
and l_session_date between nvl(date_start,l_session_date)
and nvl(date_end,l_session_date)
and personal_flag = 'Y'
order by person_id;

Line: 116

select effective_start_date
from per_all_people_f
where person_id = p_person_id
and business_group_id = p_new.business_group_id
and sysdate between effective_start_date
and effective_end_date;

Line: 124

    select person_id
    from   per_establishment_attendances pea
    where  pea.attendance_id = cv_attendance_id;

Line: 129

    select person_id
    from   per_all_people_f per
    where  per.party_id = cv_party_id ;