APPS.BEN_DCR_BUS dependencies on BEN_DPNT_CVG_RQD_RLSHP_F

Line 735: cursor c1 is select null from ben_dpnt_cvg_rqd_rlshp_f

731: l_proc varchar2(72) := g_package||'chk_duplicate_rows';
732: l_api_updating boolean;
733:
734: dummy varchar2(1);
735: cursor c1 is select null from ben_dpnt_cvg_rqd_rlshp_f
736: where (dpnt_cvg_rqd_rlshp_id <> p_dpnt_cvg_rqd_rlshp_id or p_dpnt_cvg_rqd_rlshp_id is null) and
737: dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id and
738: per_relshp_typ_cd = p_per_relshp_typ_cd and
739: business_group_id = p_business_group_id and

Line 1170: ben_dpnt_cvg_rqd_rlshp_f b

1166: --
1167: cursor csr_leg_code is
1168: select a.legislation_code
1169: from per_business_groups a,
1170: ben_dpnt_cvg_rqd_rlshp_f b
1171: where b.dpnt_cvg_rqd_rlshp_id = p_dpnt_cvg_rqd_rlshp_id
1172: and a.business_group_id = b.business_group_id;
1173: --
1174: -- Declare local variables