APPS.BEN_ELV_BUS dependencies on BEN_ELIG_LVG_RSN_PRTE_F

Line 120: from ben_elig_lvg_rsn_prte_f elv

116: l_exists varchar2(1);
117: --
118: cursor c3 is
119: select null
120: from ben_elig_lvg_rsn_prte_f elv
121: where elv.lvg_rsn_cd = p_lvg_rsn_cd
122: and elv.eligy_prfl_id = p_eligy_prfl_id
123: and elv.elig_lvg_rsn_prte_id <> nvl(p_elig_lvg_rsn_prte_id,hr_api.g_number)
124: and elv.business_group_id + 0 = p_business_group_id

Line 290: from ben_elig_lvg_rsn_prte_f

286: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
287: l_dummy char(1);
288: cursor c1 is
289: select null
290: from ben_elig_lvg_rsn_prte_f
291: where elig_lvg_rsn_prte_id <> nvl(p_elig_lvg_rsn_prte_id,-1)
292: and eligy_prfl_id = p_eligy_prfl_id
293: and ordr_num = p_ordr_num
294: and business_group_id = p_business_group_id;

Line 660: ben_elig_lvg_rsn_prte_f b

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