DBA Data[Home] [Help]

APPS.BEN_CCP_BUS dependencies on BEN_CVRD_DPNT_CTFN_PRVDD_F

Line 192: from ben_cvrd_dpnt_ctfn_prvdd_f ccp,

188: l_exists varchar2(1);
189: --
190: cursor c3 is
191: select null
192: from ben_cvrd_dpnt_ctfn_prvdd_f ccp,
193: ben_prtt_enrt_actn_f pea,
194: ben_per_in_ler pil
195: where ccp.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
196: and ccp.dpnt_dsgn_ctfn_typ_cd = p_dpnt_dsgn_ctfn_typ_cd

Line 704: ben_cvrd_dpnt_ctfn_prvdd_f b

700: --
701: cursor csr_leg_code is
702: select a.legislation_code
703: from per_business_groups a,
704: ben_cvrd_dpnt_ctfn_prvdd_f b
705: where b.cvrd_dpnt_ctfn_prvdd_id = p_cvrd_dpnt_ctfn_prvdd_id
706: and a.business_group_id = b.business_group_id;
707: --
708: -- Declare local variables