DBA Data[Home] [Help]

APPS.BEN_EDC_BUS dependencies on BEN_ELIG_DSBLD_STAT_CVG_F

Line 652: cursor c1 is select null from ben_elig_dsbld_stat_cvg_f

648: l_proc varchar2(72) := g_package||'chk_duplicate_rows';
649: l_api_updating boolean;
650:
651: dummy varchar2(1);
652: cursor c1 is select null from ben_elig_dsbld_stat_cvg_f
653: where (elig_dsbld_stat_cvg_id <> p_elig_dsbld_stat_cvg_id or p_elig_dsbld_stat_cvg_id is null) and
654: dsbld_cd = p_dsbld_cd and
655: dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id and
656: business_group_id = p_business_group_id and

Line 1086: ben_elig_dsbld_stat_cvg_f b

1082: --
1083: cursor csr_leg_code is
1084: select a.legislation_code
1085: from per_business_groups a,
1086: ben_elig_dsbld_stat_cvg_f b
1087: where b.elig_dsbld_stat_cvg_id = p_elig_dsbld_stat_cvg_id
1088: and a.business_group_id = b.business_group_id;
1089: --
1090: -- Declare local variables