APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_ACTY_BASE_RT_F

Line 281: to new column ord_num on ben_acty_base_rt_f

277: 17-Sep-2002 hnarayan 115.112 Bug 2569884 - communicated min and max values should
278: be calculated irrespective of whether calculate for
279: enrollment flag is checked or not
280: 11-Oct-2002 vsethi 115.113 Rates Sequence no enhancements. Modified to cater
281: to new column ord_num on ben_acty_base_rt_f
282: 24-Oct-2002 shdas 115.114 Added ben_env_object.init to main_w
283: 13-Nov-2002 vsethi 115.115 Bug 1210355, if variable rate is detected the mlt code
284: attached to the variable profile should be displayed
285: for the rate

Line 744: from ben_acty_base_rt_f abr

740: abr.ordr_num,
741: abr.rate_periodization_rl, --BUG 3463457
742: abr.mn_mx_elcn_rl, -- Min Max Enhancement : 3981982
743: abr.input_va_calc_rl
744: from ben_acty_base_rt_f abr
745: where abr.acty_base_rt_id = p_acty_base_rt_id
746: and c_effective_date
747: between abr.effective_start_date
748: and abr.effective_end_date ;

Line 817: from ben_acty_base_rt_f abr,

813: (c_effective_date in date
814: )
815: is
816: select abr2.acty_base_rt_id,abr2.entr_val_at_enrt_flag
817: from ben_acty_base_rt_f abr,
818: ben_acty_base_rt_f abr2
819: where abr.acty_base_rt_id = p_acty_base_rt_id
820: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
821: and abr2.parnt_chld_cd = 'PARNT'

Line 818: ben_acty_base_rt_f abr2

814: )
815: is
816: select abr2.acty_base_rt_id,abr2.entr_val_at_enrt_flag
817: from ben_acty_base_rt_f abr,
818: ben_acty_base_rt_f abr2
819: where abr.acty_base_rt_id = p_acty_base_rt_id
820: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
821: and abr2.parnt_chld_cd = 'PARNT'
822: and c_effective_date

Line 1077: from ben_elig_per_elctbl_chc epe, ben_acty_base_rt_f abr

1073: --
1074: cursor get_rt_and_element(c_pgm_id in number,
1075: c_per_in_ler_id in number) is
1076: select abr.acty_base_rt_id, abr.element_type_id, epe.elig_per_elctbl_chc_id
1077: from ben_elig_per_elctbl_chc epe, ben_acty_base_rt_f abr
1078: where (epe.pl_id = abr.pl_id or epe.plip_id = abr.plip_id)
1079: and epe.pgm_id = c_pgm_id and epe.per_in_ler_id = c_per_in_ler_id
1080: and epe.comp_lvl_cd = 'PLANFC';
1081: l_rt_and_element get_rt_and_element%rowtype;

Line 1100: from ben_acty_base_rt_f abr

1096: --ICM Changes
1097: --
1098: cursor c_abr_level is
1099: select pl_id,oipl_id
1100: from ben_acty_base_rt_f abr
1101: where abr.acty_base_rt_id = p_acty_base_rt_id
1102: and p_effective_date between abr.effective_start_date
1103: and abr.effective_end_date;
1104: --

Line 4128: from ben_acty_base_rt_f abr

4124: and ecr.acty_base_rt_id = p_acty_base_rt_id; --Bug 4143012 get the correct rate
4125: --
4126: cursor c_acty_base_rt is
4127: select element_type_id,rate_periodization_rl
4128: from ben_acty_base_rt_f abr
4129: where abr.acty_base_rt_id = p_acty_base_rt_id
4130: and l_effective_date between abr.effective_start_date
4131: and abr.effective_end_date;
4132: --