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_ESR_BUS dependencies on BEN_EE_STAT_RT_F

Line 127: from ben_ee_stat_rt_f

123: l_exists varchar2(1);
124: --
125: cursor c_dup is
126: select null
127: from ben_ee_stat_rt_f
128: where assignment_status_type_id = p_assignment_status_type_id
129: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
130: and ee_stat_rt_id <> nvl(p_ee_stat_rt_id,hr_api.g_number)
131: and business_group_id + 0 = p_business_group_id

Line 204: from ben_ee_stat_rt_f

200: is
201: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
202: l_dummy char(1);
203: cursor c1 is select null
204: from ben_ee_stat_rt_f
205: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
206: and ee_stat_rt_id <> nvl(p_ee_stat_rt_id,-1)
207: and p_effective_date between effective_start_date
208: and effective_end_date

Line 660: ben_ee_stat_rt_f b

656: --
657: cursor csr_leg_code is
658: select a.legislation_code
659: from per_business_groups a,
660: ben_ee_stat_rt_f b
661: where b.ee_stat_rt_id = p_ee_stat_rt_id
662: and a.business_group_id = b.business_group_id;
663: --
664: -- Declare local variables