APPS.BEN_COBRA_REQUIREMENTS dependencies on BEN_PTNL_LER_FOR_PER

Line 2330: from ben_ptnl_ler_for_per ppl

2326: -- 14332963
2327: --
2328: cursor c_get_ptnl_evt(p_person_id in number) is
2329: select null
2330: from ben_ptnl_ler_for_per ppl
2331: where ppl.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
2332: and ppl.person_id = p_person_id
2333: and ppl.ptnl_ler_for_per_stat_cd in ('DTCTD', 'PROCD', 'UNPROCD')
2334: and ppl.business_group_id = p_business_group_id;