[Home] [Help]
1436: epe.prtt_enrt_rslt_id,
1437: egd.object_version_number
1438: from ben_elig_dpnt egd,
1439: ben_elig_per_elctbl_chc epe,
1440: ben_per_in_ler pil
1441: where egd.elig_dpnt_id = p_elig_dpnt_id
1442: and egd.business_group_id = p_business_group_id
1443: and egd.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
1444: and egd.per_in_ler_id = pil.per_in_ler_id
2065: AND p_effective_date between typ.effective_start_date
2066: and typ.effective_end_date
2067: AND EXISTS(SELECT null
2068: FROM ben_crt_ordr crt,
2069: ben_per_in_ler pil
2070: WHERE crt.crt_ordr_typ_cd IN ('QMCSO','QDRO')
2071: AND crt.person_id = pen.person_id
2072: AND (crt.pl_id = pln.pl_id or crt.pl_typ_id = typ.pl_typ_id)
2073: AND crt.business_group_id = p_business_group_id
2167: cursor c_pdp is
2168: select egd.*
2169: from ben_elig_dpnt egd,
2170: ben_elig_cvrd_dpnt_f pdp,
2171: ben_per_in_ler pil
2172: where pdp.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
2173: and pdp.per_in_ler_id = egd.per_in_ler_id
2174: and pdp.elig_cvrd_dpnt_id = egd.elig_cvrd_dpnt_id
2175: and pdp.dpnt_person_id = egd.dpnt_person_id
2217: select egd.*
2218: from ben_elig_dpnt egd,
2219: ben_elig_cvrd_dpnt_f pdp,
2220: ben_prtt_enrt_rslt_f pen,
2221: ben_per_in_ler pil
2222: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2223: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
2224: and pdp.dpnt_person_id = p_dpnt_person_id
2225: and pdp.per_in_ler_id = egd.per_in_ler_id
2295: select egd.elig_dpnt_id
2296: from ben_elig_dpnt egd,
2297: ben_elig_per_opt_f epo,
2298: ben_elig_per_f pep,
2299: ben_per_in_ler pil,
2300: ben_oipl_f oipl
2301: where egd.dpnt_person_id = c_dpnt_person_id
2302: and egd.elig_per_opt_id = epo.elig_per_opt_id
2303: and egd.elig_per_id = epo.elig_per_id
2324: )
2325: is
2326: select egd.elig_dpnt_id
2327: from ben_elig_dpnt egd,
2328: ben_per_in_ler pil,
2329: ben_elig_per_f pep
2330: where egd.dpnt_person_id = c_dpnt_person_id
2331: and egd.elig_per_opt_id is null
2332: and egd.elig_per_id = pep.elig_per_id