APPS.BEN_EXT_ELIG dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 29: from ben_elig_per_elctbl_chc ele,

25: /*
26: cursor ee_pre_tax_c is
27: select
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

Line 45: from ben_elig_per_elctbl_chc ele,

41:
42: cursor ee_pre_tax_c is
43: select
44: sum(ecr1.val)
45: from ben_elig_per_elctbl_chc ele,
46: ben_enrt_rt ecr1
47: where
48: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id
49: and ele.elig_per_elctbl_chc_id = ecr1.elig_per_elctbl_chc_id

Line 58: from ben_elig_per_elctbl_chc ele,

54:
55: cursor ee_pre_tax_enb_c is
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

Line 75: from ben_elig_per_elctbl_chc ele,

71: /*
72: cursor ee_after_tax_c is
73: select
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

Line 91: from ben_elig_per_elctbl_chc ele,

87:
88: cursor ee_after_tax_c is
89: select
90: sum(ecr1.val)
91: from ben_elig_per_elctbl_chc ele,
92: ben_enrt_rt ecr1
93: where
94: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id
95: and ele.elig_per_elctbl_chc_id = ecr1.elig_per_elctbl_chc_id

Line 105: from ben_elig_per_elctbl_chc ele,

101:
102: cursor ee_after_tax_enb_c is
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

Line 122: from ben_elig_per_elctbl_chc ele,

118: /*
119: cursor ee_ttl_c is
120: select
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

Line 137: from ben_elig_per_elctbl_chc ele,

133:
134: cursor ee_ttl_c is
135: select
136: sum(ecr1.val)
137: from ben_elig_per_elctbl_chc ele,
138: ben_enrt_rt ecr1
139: where
140: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id
141: and ele.elig_per_elctbl_chc_id = ecr1.elig_per_elctbl_chc_id

Line 150: from ben_elig_per_elctbl_chc ele,

146:
147: cursor ee_ttl_enb_c is
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

Line 165: from ben_elig_per_elctbl_chc ele,

161: /*
162: cursor er_ttl_c is
163: select
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

Line 180: from ben_elig_per_elctbl_chc ele,

176:
177: cursor er_ttl_c is
178: select
179: sum(ecr1.val)
180: from ben_elig_per_elctbl_chc ele,
181: ben_enrt_rt ecr1
182: where
183: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id
184: and ele.elig_per_elctbl_chc_id = ecr1.elig_per_elctbl_chc_id

Line 193: from ben_elig_per_elctbl_chc ele,

189:
190: cursor er_ttl_enb_c is
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

Line 209: from ben_elig_per_elctbl_chc ele,

205: /*
206: cursor ee_ttl_dist_c is
207: select
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

Line 224: from ben_elig_per_elctbl_chc ele,

220:
221: cursor ee_ttl_dist_c is
222: select
223: sum(ecr1.val)
224: from ben_elig_per_elctbl_chc ele,
225: ben_enrt_rt ecr1
226: where
227: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id
228: and ele.elig_per_elctbl_chc_id = ecr1.elig_per_elctbl_chc_id

Line 237: from ben_elig_per_elctbl_chc ele,

233:
234: cursor ee_ttl_dist_enb_c is
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

Line 253: from ben_elig_per_elctbl_chc ele,

249: /*
250: cursor er_ttl_dist_c is
251: select
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

Line 268: from ben_elig_per_elctbl_chc ele,

264:
265: cursor er_ttl_dist_c is
266: select
267: sum(ecr1.val)
268: from ben_elig_per_elctbl_chc ele,
269: ben_enrt_rt ecr1
270: where
271: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id
272: and ele.elig_per_elctbl_chc_id = ecr1.elig_per_elctbl_chc_id

Line 281: from ben_elig_per_elctbl_chc ele,

277:
278: cursor er_ttl_dist_enb_c is
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

Line 297: from ben_elig_per_elctbl_chc ele,

293: /*
294: cursor ttl_oth_rt_c is
295: select
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

Line 315: from ben_elig_per_elctbl_chc ele,

311:
312: cursor ttl_oth_rt_c is
313: select
314: sum(ecr1.val)
315: from ben_elig_per_elctbl_chc ele,
316: ben_enrt_rt ecr1
317: where
318: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id
319: and ele.elig_per_elctbl_chc_id = ecr1.elig_per_elctbl_chc_id

Line 330: from ben_elig_per_elctbl_chc ele,

326:
327: cursor ttl_oth_rt_enb_c is
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

Line 369: from ben_elig_per_elctbl_chc ele,

365: -----cwb 2832419
366: cursor ttl_type_cd_c(c_typ_cd varchar2) is
367: select
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

Line 947: ben_elig_per_elctbl_chc echc,

943: opt.opt_attribute9 opt_flex_09,
944: opt.opt_attribute10 opt_flex_10,
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,

Line 1102: ben_elig_per_elctbl_chc echc,

1098: enb.entr_val_at_enrt_flag entr_val_at_enrt_flag,
1099: enb.cvg_mlt_cd cvg_mlt_cd,
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

Line 1314: from ben_elig_per_elctbl_chc chc,

1310: --
1311: cursor c_rpt_grp(l_elig_per_elctbl_chc_id number) is
1312: select grp.rptg_grp_id,
1313: grp.name
1314: from ben_elig_per_elctbl_chc chc,
1315: ben_popl_rptg_grp_f prpg,
1316: ben_rptg_grp grp
1317: where chc.elig_per_elctbl_chc_id = l_elig_per_elctbl_chc_id
1318: and chc.pl_id = prpg.pl_id

Line 1324: from ben_elig_per_elctbl_chc chc,

1320: --
1321: cursor c_pl_yr(l_elig_per_elctbl_chc_id number) is
1322: select yrpr.start_date,
1323: yrpr.end_date
1324: from ben_elig_per_elctbl_chc chc,
1325: ben_yr_perd yrpr
1326: where chc.elig_per_elctbl_chc_id = l_elig_per_elctbl_chc_id
1327: and chc.yr_perd_id = yrpr.yr_perd_id;
1328: --