APPS.BEN_ETC_BUS dependencies on BEN_ELIG_TTL_CVG_VOL_PRTE_F

Line 116: from ben_elig_ttl_cvg_vol_prte_f

112: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
113: l_dummy char(1);
114: cursor c1 is
115: select null
116: from ben_elig_ttl_cvg_vol_prte_f
117: where elig_ttl_cvg_vol_prte_id <> nvl(p_elig_ttl_cvg_vol_prte_id,-1)
118: and eligy_prfl_id = p_eligy_prfl_id
119: and ordr_num = p_ordr_num
120: and business_group_id = p_business_group_id;

Line 1061: ben_elig_ttl_cvg_vol_prte_f b

1057: --
1058: cursor csr_leg_code is
1059: select a.legislation_code
1060: from per_business_groups a,
1061: ben_elig_ttl_cvg_vol_prte_f b
1062: where b.elig_ttl_cvg_vol_prte_id = p_elig_ttl_cvg_vol_prte_id
1063: and a.business_group_id = b.business_group_id;
1064: --
1065: -- Declare local variables