APPS.BEN_PUMP_GET dependencies on BEN_ACTY_BASE_RT_F

Line 32: from ben_acty_base_rt_f abr

28: l_acty_base_rt_id := p_acty_base_rate_num1 ;
29: ELSIF p_acty_base_rate_name1 IS NOT NULL THEN
30: select abr.acty_base_rt_id
31: into l_acty_base_rt_id
32: from ben_acty_base_rt_f abr
33: where abr.name = p_acty_base_rate_name1
34: and abr.business_group_id + 0 = p_business_group_id
35: and p_effective_date between
36: abr.effective_start_date and abr.effective_end_date;

Line 60: from ben_acty_base_rt_f abr

56: l_acty_base_rt_id := p_acty_base_rate_num2 ;
57: ELSIF p_acty_base_rate_name2 IS NOT NULL THEN
58: select abr.acty_base_rt_id
59: into l_acty_base_rt_id
60: from ben_acty_base_rt_f abr
61: where abr.name = p_acty_base_rate_name2
62: and abr.business_group_id + 0 = p_business_group_id
63: and p_effective_date between
64: abr.effective_start_date and abr.effective_end_date;

Line 88: from ben_acty_base_rt_f abr

84: l_acty_base_rt_id := p_acty_base_rate_num3 ;
85: ELSIF p_acty_base_rate_name3 IS NOT NULL THEN
86: select abr.acty_base_rt_id
87: into l_acty_base_rt_id
88: from ben_acty_base_rt_f abr
89: where abr.name = p_acty_base_rate_name3
90: and abr.business_group_id + 0 = p_business_group_id
91: and p_effective_date between
92: abr.effective_start_date and abr.effective_end_date;

Line 116: from ben_acty_base_rt_f abr

112: l_acty_base_rt_id := p_acty_base_rate_num4 ;
113: ELSIF p_acty_base_rate_name4 IS NOT NULL THEN
114: select abr.acty_base_rt_id
115: into l_acty_base_rt_id
116: from ben_acty_base_rt_f abr
117: where abr.name = p_acty_base_rate_name4
118: and abr.business_group_id + 0 = p_business_group_id
119: and p_effective_date between
120: abr.effective_start_date and abr.effective_end_date;