APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_OTHR_PTIP_PRTE_F

Line 918: is select 1 from BEN_ELIG_OTHR_PTIP_PRTE_F

914: is select 1 from BEN_SCHEDD_ENRT_RL_F
915: where business_group_id = p_bg_id;
916:
917: cursor c230(p_bg_id NUMBER)
918: is select 1 from BEN_ELIG_OTHR_PTIP_PRTE_F
919: where business_group_id = p_bg_id;
920:
921: cursor c231(p_bg_id NUMBER)
922: is select 1 from BEN_LER_CHG_PTIP_ENRT_F

Line 4601: -- Testing for values in BEN_ELIG_OTHR_PTIP_PRTE_F

4597: --
4598: close c229;
4599:
4600: --
4601: -- Testing for values in BEN_ELIG_OTHR_PTIP_PRTE_F
4602: --
4603: open c230(p_bg_id);
4604: --
4605: fetch c230 into l_temp;

Line 4609: fnd_message.set_token('TABLE_NAME','BEN_ELIG_OTHR_PTIP_PRTE_F');

4605: fetch c230 into l_temp;
4606: if c230%found then
4607: close c230;
4608: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4609: fnd_message.set_token('TABLE_NAME','BEN_ELIG_OTHR_PTIP_PRTE_F');
4610: fnd_message.raise_error;
4611: end if;
4612: --
4613: close c230;

Line 6261: delete from BEN_ELIG_OTHR_PTIP_PRTE_F

6257:
6258: delete from BEN_SCHEDD_ENRT_RL_F
6259: where business_group_id = p_bg_id;
6260:
6261: delete from BEN_ELIG_OTHR_PTIP_PRTE_F
6262: where business_group_id = p_bg_id;
6263:
6264: delete from BEN_LER_CHG_PTIP_ENRT_F
6265: where business_group_id = p_bg_id;