DBA Data[Home] [Help]

APPS.BEN_ESC_BUS dependencies on BEN_ELIG_STDNT_STAT_CVG_F

Line 647: cursor c1 is select null from ben_elig_stdnt_stat_cvg_f

643: l_proc varchar2(72) := g_package||'chk_duplicate_rows';
644: l_api_updating boolean;
645:
646: dummy varchar2(1);
647: cursor c1 is select null from ben_elig_stdnt_stat_cvg_f
648: where (elig_stdnt_stat_cvg_id <> p_elig_stdnt_stat_cvg_id or p_elig_stdnt_stat_cvg_id is null) and
649: dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id and
650: stdnt_stat_cd = p_stdnt_stat_cd and
651: business_group_id = p_business_group_id and

Line 1081: ben_elig_stdnt_stat_cvg_f b

1077: --
1078: cursor csr_leg_code is
1079: select a.legislation_code
1080: from per_business_groups a,
1081: ben_elig_stdnt_stat_cvg_f b
1082: where b.elig_stdnt_stat_cvg_id = p_elig_stdnt_stat_cvg_id
1083: and a.business_group_id = b.business_group_id;
1084: --
1085: -- Declare local variables