APPS.BEN_EFC_ADJUSTMENTS dependencies on BEN_ACTY_BASE_RT_F

Line 39: to new column ord_num on ben_acty_base_rt_f

35: 115.24 08-Jun-02 pabodla Do not select the contingent worker
36: assignment when assignment data is
37: fetched.
38: 115.25 11-Oct-02 vsethi Rates Sequence no enhancements. Modified to cater
39: to new column ord_num on ben_acty_base_rt_f
40: 115.26 30-Dec-2002 mmudigon NOCOPY
41: 115.27 13-feb-2003 kmahendr Added a parameter to call -acty_base_rt.main
42: -----------------------------------------------------------------------------
43: */

Line 71: from ben_acty_base_rt_f abr,

67: is
68: select abr2.acty_base_rt_id,
69: abr2.entr_val_at_enrt_flag,
70: abr2.val
71: from ben_acty_base_rt_f abr,
72: ben_acty_base_rt_f abr2
73: where abr.acty_base_rt_id = c_abr_id
74: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
75: and abr2.parnt_chld_cd = 'PARNT'

Line 72: ben_acty_base_rt_f abr2

68: select abr2.acty_base_rt_id,
69: abr2.entr_val_at_enrt_flag,
70: abr2.val
71: from ben_acty_base_rt_f abr,
72: ben_acty_base_rt_f abr2
73: where abr.acty_base_rt_id = c_abr_id
74: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
75: and abr2.parnt_chld_cd = 'PARNT'
76: and c_eff_date

Line 4727: from ben_acty_base_rt_f abr

4723: abr.entr_ann_val_flag,
4724: abr.mn_elcn_val,
4725: abr.mx_elcn_val,
4726: abr.incrmt_elcn_val
4727: from ben_acty_base_rt_f abr
4728: where abr.acty_base_rt_id = c_abr_id
4729: and c_eff_date
4730: between abr.effective_start_date
4731: and abr.effective_end_date;