[Home] [Help]
28: sum(nvl(ecr1.val,ecr2.val)
29: from ben_elig_per_elctbl_chc ele,
30: ben_enrt_rt ecr1,
31: ben_enrt_rt ecr2,
32: ben_enrt_bnft enb
33: where
34: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and
35: ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id(+)
36: and ele.elig_per_elctbl_chc_id = ecr1.elig_per_elctbl_chc_id(+)
56: select
57: sum(ecr2.val)
58: from ben_elig_per_elctbl_chc ele,
59: ben_enrt_rt ecr2,
60: ben_enrt_bnft enb
61: where
62: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id
63: and ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id
64: and enb.enrt_bnft_id = ecr2.enrt_bnft_id
74: sum(nvl(ecr1.val,ecr2.val))
75: from ben_elig_per_elctbl_chc ele,
76: ben_enrt_rt ecr1,
77: ben_enrt_rt ecr2,
78: ben_enrt_bnft enb
79: where
80: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and
81: ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id(+)
82: and ele.elig_per_elctbl_chc_id = ecr1.elig_per_elctbl_chc_id(+)
103: select
104: sum(ecr2.val)
105: from ben_elig_per_elctbl_chc ele,
106: ben_enrt_rt ecr2,
107: ben_enrt_bnft enb
108: where
109: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and
110: ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id
111: and enb.enrt_bnft_id = ecr2.enrt_bnft_id
121: sum(nvl(ecr1.val,ecr2.val))
122: from ben_elig_per_elctbl_chc ele,
123: ben_enrt_rt ecr1,
124: ben_enrt_rt ecr2,
125: ben_enrt_bnft enb
126: where
127: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and
128: ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id(+)
129: and ele.elig_per_elctbl_chc_id = ecr1.elig_per_elctbl_chc_id(+)
148: select
149: sum(ecr2.val)
150: from ben_elig_per_elctbl_chc ele,
151: ben_enrt_rt ecr2,
152: ben_enrt_bnft enb
153: where
154: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and
155: ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id
156: and enb.enrt_bnft_id = ecr2.enrt_bnft_id
164: sum(nvl(ecr1.val,ecr2.val))
165: from ben_elig_per_elctbl_chc ele,
166: ben_enrt_rt ecr1,
167: ben_enrt_rt ecr2,
168: ben_enrt_bnft enb
169: where
170: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and
171: ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id(+)
172: and ele.elig_per_elctbl_chc_id = ecr1.elig_per_elctbl_chc_id(+)
191: select
192: sum(ecr2.val)
193: from ben_elig_per_elctbl_chc ele,
194: ben_enrt_rt ecr2,
195: ben_enrt_bnft enb
196: where
197: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and
198: ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id
199: and enb.enrt_bnft_id = ecr2.enrt_bnft_id
208: sum(nvl(ecr1.val,ecr2.val))
209: from ben_elig_per_elctbl_chc ele,
210: ben_enrt_rt ecr1,
211: ben_enrt_rt ecr2,
212: ben_enrt_bnft enb
213: where
214: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and
215: ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id(+)
216: and ele.elig_per_elctbl_chc_id = ecr1.elig_per_elctbl_chc_id(+)
235: select
236: sum(ecr2.val)
237: from ben_elig_per_elctbl_chc ele,
238: ben_enrt_rt ecr2,
239: ben_enrt_bnft enb
240: where
241: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and
242: ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id
243: and enb.enrt_bnft_id = ecr2.enrt_bnft_id
252: sum(nvl(ecr1.val,ecr2.val))
253: from ben_elig_per_elctbl_chc ele,
254: ben_enrt_rt ecr1,
255: ben_enrt_rt ecr2,
256: ben_enrt_bnft enb
257: where
258: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and
259: ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id(+)
260: and ele.elig_per_elctbl_chc_id = ecr1.elig_per_elctbl_chc_id(+)
279: select
280: sum(ecr2.val)
281: from ben_elig_per_elctbl_chc ele,
282: ben_enrt_rt ecr2,
283: ben_enrt_bnft enb
284: where
285: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and
286: ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id
287: and enb.enrt_bnft_id = ecr2.enrt_bnft_id
296: sum(nvl(ecr1.val,ecr2.val))
297: from ben_elig_per_elctbl_chc ele,
298: ben_enrt_rt ecr1,
299: ben_enrt_rt ecr2,
300: ben_enrt_bnft enb
301: where
302: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and
303: ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id(+)
304: and ele.elig_per_elctbl_chc_id = ecr1.elig_per_elctbl_chc_id(+)
328: select
329: sum(ecr2.val)
330: from ben_elig_per_elctbl_chc ele,
331: ben_enrt_rt ecr2,
332: ben_enrt_bnft enb
333: where
334: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and
335: ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id
336: and enb.enrt_bnft_id = ecr2.enrt_bnft_id
356: enr.mx_elcn_val,
357: enr.incrmt_elcn_val,
358: enr.dflt_val
359: from ben_enrt_rt enr,
360: ben_enrt_bnft bnf
361: where bnf.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
362: and bnf.enrt_bnft_id = enr.enrt_bnft_id;
363:
364:
368: sum(nvl(ecr1.val,ecr2.val))
369: from ben_elig_per_elctbl_chc ele,
370: ben_enrt_rt ecr1,
371: ben_enrt_rt ecr2,
372: ben_enrt_bnft enb
373: where
374: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and
375: ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id(+)
376: and ele.elig_per_elctbl_chc_id = ecr1.elig_per_elctbl_chc_id(+)
945: pl.cobra_pymt_due_dy_num
946: from ben_per_in_ler pler,
947: ben_elig_per_elctbl_chc echc,
948: ben_pil_elctbl_chc_popl ppopl,
949: ben_enrt_bnft enb,
950: ben_opt_f opt,
951: ben_pl_f pl,
952: ben_plip_f plip,
953: ben_oipl_f oipl,
1100: enb.ordr_num ordr_num
1101: from ben_per_in_ler pler,
1102: ben_elig_per_elctbl_chc echc,
1103: ben_pil_elctbl_chc_popl ppopl,
1104: ben_enrt_bnft enb
1105: where pler.person_id = p_person_id
1106: and pler.per_in_ler_id = echc.per_in_ler_id
1107: and echc.pil_elctbl_chc_popl_id = ppopl.pil_elctbl_chc_popl_id
1108: and echc.elctbl_flag = 'Y'