APPS.BEN_ORG_DELETE dependencies on BEN_WV_PRTN_RSN_CTFN_PL_F

Line 870: is select 1 from BEN_WV_PRTN_RSN_CTFN_PL_F

866: is select 1 from BEN_PRTN_ELIG_PRFL_F
867: where business_group_id = p_bg_id;
868:
869: cursor c218(p_bg_id NUMBER)
870: is select 1 from BEN_WV_PRTN_RSN_CTFN_PL_F
871: where business_group_id = p_bg_id;
872:
873: cursor c219(p_bg_id NUMBER)
874: is select 1 from BEN_ACTL_PREM_VRBL_RT_F

Line 4421: -- Testing for values in BEN_WV_PRTN_RSN_CTFN_PL_F

4417: --
4418: close c217;
4419:
4420: --
4421: -- Testing for values in BEN_WV_PRTN_RSN_CTFN_PL_F
4422: --
4423: open c218(p_bg_id);
4424: --
4425: fetch c218 into l_temp;

Line 4429: fnd_message.set_token('TABLE_NAME','BEN_WV_PRTN_RSN_CTFN_PL_F');

4425: fetch c218 into l_temp;
4426: if c218%found then
4427: close c218;
4428: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4429: fnd_message.set_token('TABLE_NAME','BEN_WV_PRTN_RSN_CTFN_PL_F');
4430: fnd_message.raise_error;
4431: end if;
4432: --
4433: close c218;

Line 6225: delete from BEN_WV_PRTN_RSN_CTFN_PL_F

6221:
6222: delete from BEN_PRTN_ELIG_PRFL_F
6223: where business_group_id = p_bg_id;
6224:
6225: delete from BEN_WV_PRTN_RSN_CTFN_PL_F
6226: where business_group_id = p_bg_id;
6227:
6228: delete from BEN_ACTL_PREM_VRBL_RT_F
6229: where business_group_id = p_bg_id;