eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EXT_ENRT dependencies on BEN_PRTT_RT_VAL

Line 229: from ben_prtt_rt_val b, pay_element_entry_values_f p

225: ) IS
226: --
227: cursor ee_pre_tax_c is
228: select sum(b.rt_val), sum(p.screen_entry_value)
229: from ben_prtt_rt_val b, pay_element_entry_values_f p
230: where b.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
231: and p_effective_date between nvl(b.rt_strt_dt, p_effective_date)
232: and nvl(b.rt_end_dt, p_effective_date)
233: and b.tx_typ_cd = 'PRETAX'

Line 241: from ben_prtt_rt_val b, pay_element_entry_values_f p

237: and nvl(p.effective_end_date, p_effective_date);
238: --
239: cursor ee_after_tax_c is
240: select sum(b.rt_val), sum(p.screen_entry_value)
241: from ben_prtt_rt_val b, pay_element_entry_values_f p
242: where b.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
243: and p_effective_date between nvl(b.rt_strt_dt, p_effective_date)
244: and nvl(b.rt_end_dt, p_effective_date)
245: and b.tx_typ_cd = 'AFTERTAX'

Line 253: from ben_prtt_rt_val b, pay_element_entry_values_f p

249: and nvl(p.effective_end_date, p_effective_date);
250: --
251: cursor ee_ttl_c is
252: select sum(b.rt_val), sum(p.screen_entry_value)
253: from ben_prtt_rt_val b, pay_element_entry_values_f p
254: where b.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
255: and p_effective_date between nvl(b.rt_strt_dt, p_effective_date)
256: and nvl(b.rt_end_dt, p_effective_date)
257: and b.acty_typ_cd IN ('EEPLC', 'EEIC', 'EEPYC', 'PBC', 'PBC2', 'PXC')

Line 264: from ben_prtt_rt_val b, pay_element_entry_values_f p

260: and nvl(p.effective_end_date, p_effective_date);
261: --
262: cursor er_ttl_c is
263: select sum(b.rt_val), sum(p.screen_entry_value)
264: from ben_prtt_rt_val b, pay_element_entry_values_f p
265: where b.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
266: and p_effective_date between nvl(b.rt_strt_dt, p_effective_date)
267: and nvl(b.rt_end_dt, p_effective_date)
268: and b.acty_typ_cd IN ('ERPYC', 'ERMPLC', 'ERC')

Line 275: from ben_prtt_rt_val b, pay_element_entry_values_f p

271: and nvl(p.effective_end_date, p_effective_date);
272: --
273: cursor ee_ttl_dist_c is
274: select sum(b.rt_val), sum(p.screen_entry_value)
275: from ben_prtt_rt_val b, pay_element_entry_values_f p
276: where b.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
277: and p_effective_date between nvl(b.rt_strt_dt, p_effective_date)
278: and nvl(b.rt_end_dt, p_effective_date)
279: and b.acty_typ_cd IN ('EEPYD', 'EEPRIID', 'PBD', 'PXD', 'PXD1')

Line 286: from ben_prtt_rt_val b, pay_element_entry_values_f p

282: and nvl(p.effective_end_date, p_effective_date);
283: --
284: cursor er_ttl_dist_c is
285: select sum(b.rt_val), sum(p.screen_entry_value)
286: from ben_prtt_rt_val b, pay_element_entry_values_f p
287: where b.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
288: and p_effective_date between nvl(b.rt_strt_dt, p_effective_date)
289: and nvl(b.rt_end_dt, p_effective_date)
290: and b.acty_typ_cd IN ('ERPYD', 'ERD')

Line 297: from ben_prtt_rt_val b, pay_element_entry_values_f p

293: and nvl(p.effective_end_date, p_effective_date);
294: --
295: cursor ttl_oth_rt_c is
296: select sum(b.rt_val), sum(p.screen_entry_value)
297: from ben_prtt_rt_val b, pay_element_entry_values_f p
298: where b.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
299: and p_effective_date between nvl(b.rt_strt_dt, p_effective_date)
300: and nvl(b.rt_end_dt, p_effective_date)
301: and b.acty_typ_cd NOT IN ('EEPYD', 'EEPRIID', 'PBD', 'PXD', 'PXD1', 'ERPYD',

Line 310: from ben_prtt_rt_val b, pay_element_entry_values_f p

306: and nvl(p.effective_end_date, p_effective_date);
307: -- cwb 2832419
308: cursor ttl_type_cd_c (c_acty_typ_cd varchar2) is
309: select sum(b.rt_val), sum(p.screen_entry_value)
310: from ben_prtt_rt_val b, pay_element_entry_values_f p
311: where b.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
312: /* if the type is non recirring rate is creatted for one day so it may not return any row
313: and p_effective_date between nvl(b.rt_strt_dt, p_effective_date)
314: and nvl(b.rt_end_dt, p_effective_date) */

Line 322: from ben_prtt_rt_val b, pay_element_entry_values_f p

318: and p.effective_end_date (+);
319:
320: cursor ttl_reimb_c is
321: select sum(b.rt_val), sum(p.screen_entry_value)
322: from ben_prtt_rt_val b, pay_element_entry_values_f p
323: where b.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
324: and b.acty_typ_cd IN ('PRDPER', 'PRDPPR', 'PRDPR')
325: and b.element_entry_value_id = p.element_entry_value_id (+)
326: and p_effective_date between nvl(p.effective_start_date, p_effective_date)

Line 329: l_dummy ben_prtt_rt_val.rt_val%TYPE;

325: and b.element_entry_value_id = p.element_entry_value_id (+)
326: and p_effective_date between nvl(p.effective_start_date, p_effective_date)
327: and nvl(p.effective_end_date, p_effective_date);
328:
329: l_dummy ben_prtt_rt_val.rt_val%TYPE;
330:
331: l_proc varchar2(72) := g_package||'get_rt_info';
332: --
333: Begin