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 761: from ben_acty_base_rt_f abr

757: abr.ordr_num,
758: abr.rate_periodization_rl, --BUG 3463457
759: abr.mn_mx_elcn_rl, -- Min Max Enhancement : 3981982
760: abr.input_va_calc_rl
761: from ben_acty_base_rt_f abr
762: where abr.acty_base_rt_id = p_acty_base_rt_id
763: and c_effective_date
764: between abr.effective_start_date
765: and abr.effective_end_date ;

Line 834: from ben_acty_base_rt_f abr,

830: (c_effective_date in date
831: )
832: is
833: select abr2.acty_base_rt_id,abr2.entr_val_at_enrt_flag
834: from ben_acty_base_rt_f abr,
835: ben_acty_base_rt_f abr2
836: where abr.acty_base_rt_id = p_acty_base_rt_id
837: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
838: and abr2.parnt_chld_cd = 'PARNT'

Line 835: ben_acty_base_rt_f abr2

831: )
832: is
833: select abr2.acty_base_rt_id,abr2.entr_val_at_enrt_flag
834: from ben_acty_base_rt_f abr,
835: ben_acty_base_rt_f abr2
836: where abr.acty_base_rt_id = p_acty_base_rt_id
837: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
838: and abr2.parnt_chld_cd = 'PARNT'
839: and c_effective_date

Line 1094: from ben_elig_per_elctbl_chc epe, ben_acty_base_rt_f abr

1090: --
1091: cursor get_rt_and_element(c_pgm_id in number,
1092: c_per_in_ler_id in number) is
1093: select abr.acty_base_rt_id, abr.element_type_id, epe.elig_per_elctbl_chc_id
1094: from ben_elig_per_elctbl_chc epe, ben_acty_base_rt_f abr
1095: where (epe.pl_id = abr.pl_id or epe.plip_id = abr.plip_id)
1096: and epe.pgm_id = c_pgm_id and epe.per_in_ler_id = c_per_in_ler_id
1097: and epe.comp_lvl_cd = 'PLANFC';
1098: l_rt_and_element get_rt_and_element%rowtype;

Line 1117: from ben_acty_base_rt_f abr

1113: --ICM Changes
1114: --
1115: cursor c_abr_level is
1116: select pl_id,oipl_id
1117: from ben_acty_base_rt_f abr
1118: where abr.acty_base_rt_id = p_acty_base_rt_id
1119: and p_effective_date between abr.effective_start_date
1120: and abr.effective_end_date;
1121: --

Line 4327: from ben_acty_base_rt_f abr

4323: and ecr.acty_base_rt_id = p_acty_base_rt_id; --Bug 4143012 get the correct rate
4324: --
4325: cursor c_acty_base_rt is
4326: select element_type_id,rate_periodization_rl
4327: from ben_acty_base_rt_f abr
4328: where abr.acty_base_rt_id = p_acty_base_rt_id
4329: and l_effective_date between abr.effective_start_date
4330: and abr.effective_end_date;
4331: --