APPS.BEN_EMS_BUS dependencies on BEN_ELIG_MRTL_STAT_CVG_F

Line 646: cursor c1 is select null from ben_elig_mrtl_stat_cvg_f

642: l_proc varchar2(72) := g_package||'chk_duplicate_rows';
643: l_api_updating boolean;
644:
645: dummy varchar2(1);
646: cursor c1 is select null from ben_elig_mrtl_stat_cvg_f
647: where (elig_mrtl_stat_cvg_id <> p_elig_mrtl_stat_cvg_id or p_elig_mrtl_stat_cvg_id is null) and
648: dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id and
649: mrtl_stat_cd = p_mrtl_stat_cd and
650: business_group_id = p_business_group_id and

Line 1080: ben_elig_mrtl_stat_cvg_f b

1076: --
1077: cursor csr_leg_code is
1078: select a.legislation_code
1079: from per_business_groups a,
1080: ben_elig_mrtl_stat_cvg_f b
1081: where b.elig_mrtl_stat_cvg_id = p_elig_mrtl_stat_cvg_id
1082: and a.business_group_id = b.business_group_id;
1083: --
1084: -- Declare local variables