APPS.BEN_ORG_DELETE dependencies on BEN_PRTN_ELIG_PRFL_F

Line 866: is select 1 from BEN_PRTN_ELIG_PRFL_F

862: is select 1 from BEN_ELIG_PPL_GRP_PRTE_F
863: where business_group_id = p_bg_id;
864:
865: cursor c217(p_bg_id NUMBER)
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

Line 4406: -- Testing for values in BEN_PRTN_ELIG_PRFL_F

4402: --
4403: close c216;
4404:
4405: --
4406: -- Testing for values in BEN_PRTN_ELIG_PRFL_F
4407: --
4408: open c217(p_bg_id);
4409: --
4410: fetch c217 into l_temp;

Line 4414: fnd_message.set_token('TABLE_NAME','BEN_PRTN_ELIG_PRFL_F');

4410: fetch c217 into l_temp;
4411: if c217%found then
4412: close c217;
4413: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4414: fnd_message.set_token('TABLE_NAME','BEN_PRTN_ELIG_PRFL_F');
4415: fnd_message.raise_error;
4416: end if;
4417: --
4418: close c217;

Line 6222: delete from BEN_PRTN_ELIG_PRFL_F

6218:
6219: delete from BEN_ELIG_PPL_GRP_PRTE_F
6220: where business_group_id = p_bg_id;
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;