APPS.BEN_EMC_BUS dependencies on BEN_ELIG_MLTRY_STAT_CVG_F

Line 648: cursor c1 is select null from ben_elig_mltry_stat_cvg_f

644: l_proc varchar2(72) := g_package||'chk_duplicate_rows';
645: l_api_updating boolean;
646:
647: dummy varchar2(1);
648: cursor c1 is select null from ben_elig_mltry_stat_cvg_f
649: where (elig_mltry_stat_cvg_id <> p_elig_mltry_stat_cvg_id or p_elig_mltry_stat_cvg_id is null) and
650: dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id and
651: mltry_stat_cd = p_mltry_stat_cd and
652: business_group_id = p_business_group_id and

Line 1076: ben_elig_mltry_stat_cvg_f b

1072: --
1073: cursor csr_leg_code is
1074: select a.legislation_code
1075: from per_business_groups a,
1076: ben_elig_mltry_stat_cvg_f b
1077: where b.elig_mltry_stat_cvg_id = p_elig_mltry_stat_cvg_id
1078: and a.business_group_id = b.business_group_id;
1079: --
1080: -- Declare local variables