[Home] [Help]
1110: --
1111: cursor other_dpnt_c is
1112: select null
1113: from ben_elig_cvrd_dpnt_f a,
1114: ben_per_in_ler pil
1115: where a.dpnt_person_id = l_dpnt_person_id
1116: and a.elig_cvrd_dpnt_id <> p_elig_cvrd_dpnt_id
1117: and a.cvg_strt_dt is not null
1118: and a.cvg_thru_dt = hr_api.g_eot
2562: --
2563: cursor other_dpnt_c is
2564: select null
2565: from ben_elig_cvrd_dpnt_f a,
2566: ben_per_in_ler pil
2567: where a.dpnt_person_id = l_dpnt_person_id
2568: and a.elig_cvrd_dpnt_id <> p_elig_cvrd_dpnt_id
2569: and a.cvg_strt_dt is not null
2570: and a.cvg_thru_dt = hr_api.g_eot
2718: ,egd.cvg_thru_dt
2719: from ben_prtt_enrt_rslt_f r,
2720: ben_elig_cvrd_dpnt_f egd,
2721: ben_oipl_f o ,
2722: ben_per_in_ler pil
2723: where r.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2724: and r.prtt_enrt_rslt_id = egd.prtt_enrt_rslt_id
2725: and r.business_group_id + 0 = p_business_group_id
2726: and r.per_in_ler_id = egd.per_in_ler_id
2833: cursor total_num_dpnt_c(cv_cvg_strt_dt date,
2834: cv_cvg_thru_dt date) is
2835: select count(elig_cvrd_dpnt_id)
2836: from ben_elig_cvrd_dpnt_f ecd ,
2837: ben_per_in_ler pil
2838: where ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2839: and ecd.cvg_strt_dt is not null
2840: and ecd.cvg_thru_dt = hr_api.g_eot
2841: -- and cvrd_flag = 'Y'
2857: cv_cvg_thru_dt date) is
2858: select count(*)
2859: from per_contact_relationships c
2860: , ben_elig_cvrd_dpnt_f d
2861: , ben_per_in_ler pil
2862: where
2863: c.person_id = cv_person_id
2864: and c.contact_person_id = d.dpnt_person_id
2865: and d.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id