APPS.BEN_COLLAPSE_LIFE_EVENT SQL Statements

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

Line: 30

    select ptn.ptnl_ler_for_per_id,
           ptn.ler_id,
           ptn.ptnl_ler_for_per_stat_cd,
           ptn.lf_evt_ocrd_dt,
           ptn.ntfn_dt,
           ptn.object_version_number
    from   ben_ptnl_ler_for_per ptn,
           ben_ler_f      ler
    where  ptn.business_group_id  = p_business_group_id
    and    ptn.person_id = p_person_id
    and    ptn.ler_id = ler.ler_id
    and    p_effective_date
           between ler.effective_start_date
           and     ler.effective_end_date
    -- ABSENCES : Do not consider absence life events
    and    ler.typ_cd not in  ('COMP', 'ABS','GSP', 'IREC')
    and    ptn.ptnl_ler_for_per_stat_cd not in ('VOIDD','MNL')
    and    ptn.lf_evt_ocrd_dt <= decode(ler.typ_cd,  --Bug 5703825
                                        'SCHEDDO',
                                        ptn.lf_evt_ocrd_dt,
					'SCHEDDA',
                                        ptn.lf_evt_ocrd_dt,
                                        p_effective_date)
     order  by ptn.lf_evt_ocrd_dt asc;

Line: 74

  g_events.delete;

Line: 250

    select pil.per_in_ler_id, pil.lf_evt_ocrd_dt
    from   ben_per_in_ler pil
    where  pil.ptnl_ler_for_per_id = p_ptnl_ler_for_per_id
    and    pil.business_group_id = p_business_group_id
    and    pil.per_in_ler_stat_cd in ('STRTD','PROCD');

Line: 258

    select pil.per_in_ler_id, pil.lf_evt_ocrd_dt, pil.ntfn_dt, ler.name
    from   ben_per_in_ler pil,
           ben_ler_f ler
    where  pil.person_id = p_person_id
    and    pil.per_in_ler_stat_cd in ('STRTD','PROCD')
    and    pil.lf_evt_ocrd_dt > p_lf_evt_ocrd_dt
    and    pil.per_in_ler_id <> p_curr_per_in_ler_id
    and    pil.ler_id = ler.ler_id
    and    p_effective_date between ler.effective_start_date and ler.effective_end_date
    and    ler.typ_cd not in ( 'COMP', 'ABS', 'GSP', 'IREC', 'SCHEDDU')
    order by lf_evt_ocrd_dt desc;

Line: 279

  select ptnl_ler_for_per_id from ben_ptnl_ler_for_per
	where person_id=p_person_id
	and business_group_id=p_events.business_group_id
	and ler_id=p_events.eval_ler_id
	and ptnl_ler_for_per_stat_cd in ('PROCD','STRTD')
	and lf_evt_ocrd_dt=l_lf_evt_ocrd_dt;

Line: 288

	select per_in_ler_id from ben_per_in_ler
	where ptnl_ler_for_per_id=l_win_ptnl_ler_for_per_id
	and person_id=p_person_id
	and business_group_id=p_events.business_group_id
	and ler_id=p_events.eval_ler_id;

Line: 299

select 'Y' from ben_ptnl_ler_for_per
     where ptnl_ler_for_per_id=c_ptnl_id
     and ptnl_ler_for_per_stat_cd in ('DTCTD','UNPROCD');

Line: 306

SELECT  object_version_number
FROM    ben_ptnl_ler_for_per
WHERE   ptnl_ler_for_per_id = c_ptnl_ler_for_per_id;

Line: 557

		     ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
			   (p_ptnl_ler_for_per_id      => g_included_events(l_count).
							  ptnl_ler_for_per_id,
			    p_effective_date           => p_effective_date,
			    p_lf_evt_ocrd_dt           => l_lf_evt_ocrd_dt,
			    p_object_version_number    => l_new_object_version_number);

Line: 601

		ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
		 (p_ptnl_ler_for_per_id      => g_included_events(l_count).
						ptnl_ler_for_per_id,
		  p_ptnl_ler_for_per_stat_cd => 'VOIDD',
		  p_voidd_dt                 => p_effective_date,
		  p_effective_date           => p_effective_date,
		  p_object_version_number    => g_included_events(l_count).
						object_version_number);

Line: 626

                   /*Bug 9372154: If Winner LE is not processed then update the LE occured with the
		   date determined from the LE occured date determination code */
                   open c_ler_status(g_included_events(l_count).ptnl_ler_for_per_id);

Line: 632

			   ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
				 (p_ptnl_ler_for_per_id      => g_included_events(l_count).
								ptnl_ler_for_per_id,
				  p_effective_date           => p_effective_date,
				  p_lf_evt_ocrd_dt           => l_lf_evt_ocrd_dt,
				  p_object_version_number    => g_included_events(l_count).
								object_version_number);

Line: 646

        ben_ptnl_ler_for_per_api.delete_ptnl_ler_for_per
         (p_ptnl_ler_for_per_id      => g_included_events(l_count).
                                        ptnl_ler_for_per_id,
          p_effective_date           => p_effective_date,
          p_object_version_number    => g_included_events(l_count).
                                        object_version_number);

Line: 653

        fnd_message.set_name('BEN','BEN_92435_PTNL_LER_DELETED');

Line: 686

	             p_program_update_date      => sysdate);

Line: 721

			     p_program_update_date      => sysdate);

Line: 913

  l_dynamic_sql := 'select 1 from sys.dual where '||p_expression;

Line: 951

  g_included_events.delete;

Line: 1019

    select *
    from   ben_clpse_lf_evt_f clp
    where  clp.business_group_id  = p_business_group_id
    and    p_effective_date
           between clp.effective_start_date
           and     clp.effective_end_date
    order  by seq;