APPS.BEN_ESH_BUS dependencies on BEN_ELIG_SCHEDD_HRS_PRTE_F

Line 185: from ben_elig_schedd_hrs_prte_f

181: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
182: l_dummy char(1);
183: cursor c1 is
184: select null
185: from ben_elig_schedd_hrs_prte_f
186: where elig_schedd_hrs_prte_id <> nvl(p_elig_schedd_hrs_prte_id,-1)
187: and eligy_prfl_id = p_eligy_prfl_id
188: and ordr_num = p_ordr_num
189: and business_group_id = p_business_group_id;

Line 251: from ben_elig_schedd_hrs_prte_f

247: --
248: --
249: cursor c3 is
250: select null
251: from ben_elig_schedd_hrs_prte_f
252: where nvl(freq_cd,hr_api.g_number) = nvl(p_freq_cd,hr_api.g_number)
253: and nvl(hrs_num,hr_api.g_number) = nvl(p_hrs_num,hr_api.g_number)
254: and nvl(max_hrs_num,hr_api.g_number) = nvl(p_max_hrs_num,hr_api.g_number)
255: and nvl(schedd_hrs_rl,hr_api.g_number) = nvl(p_schedd_hrs_rl,hr_api.g_number)

Line 1437: ben_elig_schedd_hrs_prte_f b

1433: --
1434: cursor csr_leg_code is
1435: select a.legislation_code
1436: from per_business_groups a,
1437: ben_elig_schedd_hrs_prte_f b
1438: where b.elig_schedd_hrs_prte_id = p_elig_schedd_hrs_prte_id
1439: and a.business_group_id = b.business_group_id;
1440: --
1441: -- Declare local variables