APPS.BEN_LCC_BUS dependencies on BEN_LER_CHG_DPNT_CVG_CTFN_F

Line 163: -- p_ler_chg_dpnt_cvg_ctfn_id is primary key for ben_ler_chg_dpnt_cvg_ctfn_f

159: --
160: -- In Parameters
161: -- p_dpnt_cvg_ctfn_typ_cd is dependent certification type code
162: -- p_rlshp_typ_cd is relationship type code
163: -- p_ler_chg_dpnt_cvg_ctfn_id is primary key for ben_ler_chg_dpnt_cvg_ctfn_f
164: -- p_ler_chg_dpnt_cvg_id
165: -- p_business_group_id
166: -- p_validation_start_date
167: -- p_validation_end_date

Line 191: from ben_ler_chg_dpnt_cvg_ctfn_f

187: is
188: l_proc varchar2(72) := g_package||'chk_dpnt_cvg_ctfn_typ_unique';
189: l_dummy char(1);
190: cursor c1 is select null
191: from ben_ler_chg_dpnt_cvg_ctfn_f
192: Where ler_chg_dpnt_cvg_ctfn_id <> nvl(p_ler_chg_dpnt_cvg_ctfn_id,-1)
193: and nvl(dpnt_cvg_ctfn_typ_cd,0) = nvl(p_dpnt_cvg_ctfn_typ_cd,0)
194: and nvl(rlshp_typ_cd,0) = nvl(p_rlshp_typ_cd,0)
195: and ler_chg_dpnt_cvg_id = p_ler_chg_dpnt_cvg_id

Line 720: ben_ler_chg_dpnt_cvg_ctfn_f b

716: --
717: cursor csr_leg_code is
718: select a.legislation_code
719: from per_business_groups a,
720: ben_ler_chg_dpnt_cvg_ctfn_f b
721: where b.ler_chg_dpnt_cvg_ctfn_id = p_ler_chg_dpnt_cvg_ctfn_id
722: and a.business_group_id = b.business_group_id;
723: --
724: -- Declare local variables