APPS.BEN_EXT_ELIG dependencies on BEN_ENRT_RT

Line 30: ben_enrt_rt ecr1,

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
34: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and

Line 31: ben_enrt_rt ecr2,

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
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(+)

Line 46: ben_enrt_rt ecr1

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
50: and ecr1.tx_typ_cd ='PRETAX'

Line 59: ben_enrt_rt ecr2,

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
63: and ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id

Line 76: ben_enrt_rt ecr1,

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
80: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and

Line 77: ben_enrt_rt ecr2,

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
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(+)

Line 92: ben_enrt_rt ecr1

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
96: and ecr1.tx_typ_cd='AFTERTAX'

Line 106: ben_enrt_rt ecr2,

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
110: ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id

Line 123: ben_enrt_rt ecr1,

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
127: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and

Line 124: ben_enrt_rt ecr2,

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
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(+)

Line 138: ben_enrt_rt ecr1

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
142: and ecr1.acty_typ_cd in ('EEPLC', 'EEIC' , 'EEPYC', 'PBC', 'PBC2', 'PXC')

Line 151: ben_enrt_rt ecr2,

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
155: ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id

Line 166: ben_enrt_rt ecr1,

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
170: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and

Line 167: ben_enrt_rt ecr2,

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
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(+)

Line 181: ben_enrt_rt ecr1

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
185: and ecr1.acty_typ_cd in ('ERPYC', 'ERMPLC', 'ERC')

Line 194: ben_enrt_rt ecr2,

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
198: ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id

Line 210: ben_enrt_rt ecr1,

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
214: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and

Line 211: ben_enrt_rt ecr2,

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
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(+)

Line 225: ben_enrt_rt ecr1

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
229: and ecr1.acty_typ_cd in ('EEPYD', 'EERIID', 'PBD', 'PXD', 'PXD1')

Line 238: ben_enrt_rt ecr2,

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
242: ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id

Line 254: ben_enrt_rt ecr1,

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
258: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and

Line 255: ben_enrt_rt ecr2,

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
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(+)

Line 269: ben_enrt_rt ecr1

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
273: and ecr1.acty_typ_cd in ('ERPYD', 'ERD')

Line 282: ben_enrt_rt ecr2,

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
286: ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id

Line 298: ben_enrt_rt ecr1,

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
302: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and

Line 299: ben_enrt_rt ecr2,

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
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(+)

Line 316: ben_enrt_rt ecr1

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
320: and ecr1.acty_typ_cd not in ('EEPYD', 'EEPRIID', 'PBD', 'PXD',

Line 331: ben_enrt_rt ecr2,

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
335: ele.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id

Line 350: from ben_enrt_rt enr

346: enr.mn_elcn_val,
347: enr.mx_elcn_val,
348: enr.incrmt_elcn_val,
349: enr.dflt_val
350: from ben_enrt_rt enr
351: where enr.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
352: --
353: cursor c_min_max_rt2 is
354: select

Line 359: from ben_enrt_rt enr,

355: enr.mn_elcn_val,
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:

Line 370: ben_enrt_rt ecr1,

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
374: p_elig_per_elctbl_chc_id = ele.elig_per_elctbl_chc_id and

Line 371: ben_enrt_rt ecr2,

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
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(+)