APPS.BEN_EES_BUS dependencies on BEN_ELIG_EE_STAT_PRTE_F

Line 168: from ben_elig_ee_stat_prte_f

164: select null from ben_elig_py_bss_prte_f a where a.eligy_prfl_id = p_eligy_prfl_id;
165: --
166: cursor c3 is
167: select null
168: from ben_elig_ee_stat_prte_f
169: where assignment_status_type_id = p_assignment_status_type_id
170: and eligy_prfl_id = p_eligy_prfl_id
171: and elig_ee_stat_prte_id <> nvl(p_elig_ee_stat_prte_id,hr_api.g_number)
172: and business_group_id + 0 = p_business_group_id

Line 355: from ben_elig_ee_stat_prte_f

351: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
352: l_dummy char(1);
353: cursor c1 is
354: select null
355: from ben_elig_ee_stat_prte_f
356: where elig_ee_stat_prte_id <> nvl(p_elig_ee_stat_prte_id,-1)
357: and eligy_prfl_id = p_eligy_prfl_id
358: and ordr_num = p_ordr_num
359: and business_group_id = p_business_group_id;

Line 726: ben_elig_ee_stat_prte_f b

722: --
723: cursor csr_leg_code is
724: select a.legislation_code
725: from per_business_groups a,
726: ben_elig_ee_stat_prte_f b
727: where b.elig_ee_stat_prte_id = p_elig_ee_stat_prte_id
728: and a.business_group_id = b.business_group_id;
729: --
730: -- Declare local variables