APPS.BEN_ON_LINE_LF_EVT dependencies on BEN_PTNL_LER_FOR_PER

Line 244: from ben_ptnl_ler_for_per ptn

240: l_package varchar2(80) := g_package||'.p_cnt_ple';
241: --
242: cursor c_ptnl_ler is
243: select count(*)
244: from ben_ptnl_ler_for_per ptn
245: where ptn.person_id = to_number(l_person_id)
246: and ptn.business_group_id+0 = to_number(l_business_group_id)
247: /* and ptn.lf_evt_ocrd_dt = p_effective_date */
248: and ptn.ptnl_ler_for_per_stat_cd in ('DTCTD','UNPROCD');

Line 513: from ben_ptnl_ler_for_per ptn

509: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;
510: --
511: cursor c_ptnl_ler is
512: select count(*)
513: from ben_ptnl_ler_for_per ptn
514: where ptn.person_id = l_person_id
515: and ptn.business_group_id+0 = l_business_group_id
516: /* and ptn.lf_evt_ocrd_dt = p_effective_date */
517: and ptn.ptnl_ler_for_per_stat_cd in ('DTCTD','UNPROCD');

Line 2794: from ben_ptnl_ler_for_per pel,

2790: --
2791: cursor c_open(p_lf_evt_ocrd_dt date,
2792: p_person_id number ) is
2793: select ler.typ_cd
2794: from ben_ptnl_ler_for_per pel,
2795: ben_ler_f ler
2796: where p_effective_date between ler.effective_start_date
2797: and ler.effective_end_date
2798: and ler.typ_cd in ( 'SCHEDDO','SCHEDDA')