APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_DPNT

Line 494: is select 1 from BEN_ELIG_DPNT_CVRD_OTHR_PL_F

490: is select 1 from BEN_DPNT_CVRD_ANTHR_PL_CVG_F
491: where business_group_id = p_bg_id;
492:
493: cursor c124(p_bg_id NUMBER)
494: is select 1 from BEN_ELIG_DPNT_CVRD_OTHR_PL_F
495: where business_group_id = p_bg_id;
496:
497: cursor c125(p_bg_id NUMBER)
498: is select 1 from BEN_ELIG_ENRLD_ANTHR_PL_F

Line 770: is select 1 from BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F

766: is select 1 from BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F
767: where business_group_id = p_bg_id;
768:
769: cursor c193(p_bg_id NUMBER)
770: is select 1 from BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F
771: where business_group_id = p_bg_id;
772:
773: cursor c194(p_bg_id NUMBER)
774: is select 1 from BEN_ELIG_PER_F

Line 902: is select 1 from BEN_ELIG_DPNT

898: is select 1 from BEN_PRTT_ENRT_CTFN_PRVDD_F
899: where business_group_id = p_bg_id;
900:
901: cursor c226(p_bg_id NUMBER)
902: is select 1 from BEN_ELIG_DPNT
903: where business_group_id = p_bg_id;
904:
905: cursor c227(p_bg_id NUMBER)
906: is select 1 from BEN_LEE_RSN_RL_F

Line 3011: -- Testing for values in BEN_ELIG_DPNT_CVRD_OTHR_PL_F

3007: --
3008: close c122;
3009:
3010: --
3011: -- Testing for values in BEN_ELIG_DPNT_CVRD_OTHR_PL_F
3012: --
3013: open c124(p_bg_id);
3014: --
3015: fetch c124 into l_temp;

Line 3019: fnd_message.set_token('TABLE_NAME','BEN_ELIG_DPNT_CVRD_OTHR_PL_F');

3015: fetch c124 into l_temp;
3016: if c124%found then
3017: close c124;
3018: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3019: fnd_message.set_token('TABLE_NAME','BEN_ELIG_DPNT_CVRD_OTHR_PL_F');
3020: fnd_message.raise_error;
3021: end if;
3022: --
3023: close c124;

Line 4046: -- Testing for values in BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F

4042: --
4043: close c192;
4044:
4045: --
4046: -- Testing for values in BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F
4047: --
4048: open c193(p_bg_id);
4049: --
4050: fetch c193 into l_temp;

Line 4054: fnd_message.set_token('TABLE_NAME','BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F');

4050: fetch c193 into l_temp;
4051: if c193%found then
4052: close c193;
4053: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4054: fnd_message.set_token('TABLE_NAME','BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F');
4055: fnd_message.raise_error;
4056: end if;
4057: --
4058: close c193;

Line 4541: -- Testing for values in BEN_ELIG_DPNT

4537: --
4538: close c225;
4539:
4540: --
4541: -- Testing for values in BEN_ELIG_DPNT
4542: --
4543: open c226(p_bg_id);
4544: --
4545: fetch c226 into l_temp;

Line 4549: fnd_message.set_token('TABLE_NAME','BEN_ELIG_DPNT');

4545: fetch c226 into l_temp;
4546: if c226%found then
4547: close c226;
4548: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4549: fnd_message.set_token('TABLE_NAME','BEN_ELIG_DPNT');
4550: fnd_message.raise_error;
4551: end if;
4552: --
4553: close c226;

Line 5943: delete from BEN_ELIG_DPNT_CVRD_OTHR_PL_F

5939:
5940: delete from BEN_DPNT_CVRD_ANTHR_PL_CVG_F
5941: where business_group_id = p_bg_id;
5942:
5943: delete from BEN_ELIG_DPNT_CVRD_OTHR_PL_F
5944: where business_group_id = p_bg_id;
5945:
5946: delete from BEN_ELIG_ENRLD_ANTHR_PL_F
5947: where business_group_id = p_bg_id;

Line 6150: delete from BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F

6146:
6147: delete from BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F
6148: where business_group_id = p_bg_id;
6149:
6150: delete from BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F
6151: where business_group_id = p_bg_id;
6152:
6153: delete from BEN_ELIG_PER_F
6154: where business_group_id = p_bg_id;

Line 6249: delete from BEN_ELIG_DPNT

6245:
6246: delete from BEN_PRTT_ENRT_CTFN_PRVDD_F
6247: where business_group_id = p_bg_id;
6248:
6249: delete from BEN_ELIG_DPNT
6250: where business_group_id = p_bg_id;
6251:
6252: delete from BEN_LEE_RSN_RL_F
6253: where business_group_id = p_bg_id;