APPS.BEN_SHR_BUS dependencies on BEN_SCHEDD_HRS_RT_F

Line 188: from ben_schedd_hrs_rt_f

184: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
185: l_dummy char(1);
186: cursor c1 is
187: select null
188: from ben_schedd_hrs_rt_f
189: where schedd_hrs_rt_id <> nvl(p_schedd_hrs_rt_id,hr_api.g_number)
190: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
191: and ordr_num = p_ordr_num
192: and business_group_id = p_business_group_id;

Line 261: from ben_schedd_hrs_rt_f

257: l_exists varchar2(1);
258: --
259: cursor c_dup is
260: select null
261: from ben_schedd_hrs_rt_f
262: where nvl(hrs_num,-99999999999) = nvl(p_hrs_num,-99999999999)
263: and nvl(freq_cd,'freq_cd') = nvl(p_freq_cd,'freq_cd')
264: and nvl(max_hrs_num,-99999999999) = nvl(p_max_hrs_num,-99999999999)
265: and nvl(schedd_hrs_rl,-99999999999) = nvl(p_schedd_hrs_rl,-99999999999)

Line 1328: ben_schedd_hrs_rt_f b

1324: --
1325: cursor csr_leg_code is
1326: select a.legislation_code
1327: from per_business_groups a,
1328: ben_schedd_hrs_rt_f b
1329: where b.schedd_hrs_rt_id = p_schedd_hrs_rt_id
1330: and a.business_group_id = b.business_group_id;
1331: --
1332: -- Declare local variables