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_SAR_BUS dependencies on BEN_SVC_AREA_RT_F

Line 134: from ben_svc_area_rt_f

130: --
131:
132: cursor c3 is
133: select null
134: from ben_svc_area_rt_f
135: where svc_area_id = p_svc_area_id
136: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
137: and svc_area_rt_id <> nvl(p_svc_area_rt_id,hr_api.g_number)
138: and business_group_id + 0 = p_business_group_id

Line 233: from ben_svc_area_rt_f

229: is
230: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
231: l_dummy char(1);
232: cursor c1 is select null
233: from ben_svc_area_rt_f
234: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
235: and svc_area_rt_id <> nvl(p_svc_area_rt_id,-1)
236: and p_effective_date between effective_start_date
237: and effective_end_date

Line 692: ben_svc_area_rt_f b

688: --
689: cursor csr_leg_code is
690: select a.legislation_code
691: from per_business_groups a,
692: ben_svc_area_rt_f b
693: where b.svc_area_rt_id = p_svc_area_rt_id
694: and a.business_group_id = b.business_group_id;
695: --
696: -- Declare local variables