APPS.BEN_ECL_BUS dependencies on BEN_ELIG_COMP_LVL_PRTE_F

Line 121: from ben_elig_comp_lvl_prte_f

117: l_exists varchar2(1);
118: --
119: cursor c3 is
120: select null
121: from ben_elig_comp_lvl_prte_f
122: where comp_lvl_fctr_id = p_comp_lvl_fctr_id
123: and eligy_prfl_id = p_eligy_prfl_id
124: and elig_comp_lvl_prte_id <> nvl(p_elig_comp_lvl_prte_id,hr_api.g_number)
125: and business_group_id + 0 = p_business_group_id

Line 440: from ben_elig_comp_lvl_prte_f

436: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
437: l_dummy char(1);
438: cursor c1 is
439: select null
440: from ben_elig_comp_lvl_prte_f
441: where elig_comp_lvl_prte_id <> nvl(p_elig_comp_lvl_prte_id,-1)
442: and eligy_prfl_id = p_eligy_prfl_id
443: and ordr_num = p_ordr_num
444: and business_group_id = p_business_group_id;

Line 813: ben_elig_comp_lvl_prte_f b

809: --
810: cursor csr_leg_code is
811: select a.legislation_code
812: from per_business_groups a,
813: ben_elig_comp_lvl_prte_f b
814: where b.elig_comp_lvl_prte_id = p_elig_comp_lvl_prte_id
815: and a.business_group_id = b.business_group_id;
816: --
817: -- Declare local variables