APPS.GHR_TSP_PLAN_DESIGN dependencies on BEN_PTNL_LER_FOR_PER

Line 569: from ben_ptnl_ler_for_per

565:
566: -- Cursor to get potential records
567: Cursor c_get_ptnl_emps is
568: select person_id,business_group_id,ler_id,lf_evt_ocrd_dt
569: from ben_ptnl_ler_for_per
570: where ler_id in (select ler_id from ben_ler_f where name = 'TSP Continuation of Coverage'
571: and sysdate between effective_start_date and effective_end_date)
572: and ptnl_ler_for_per_stat_cd = 'UNPROCD'
573: and lf_evt_ocrd_dt <= sysdate;