APPS.BEN_ORG_DELETE dependencies on BEN_PER_BNFTS_BAL_F

Line 226: is select 1 from BEN_PER_BNFTS_BAL_F

222: is select 1 from BEN_ORG_UNIT_PRDCT_F
223: where business_group_id = p_bg_id;
224:
225: cursor c56(p_bg_id NUMBER)
226: is select 1 from BEN_PER_BNFTS_BAL_F
227: where business_group_id = p_bg_id;
228:
229: cursor c57(p_bg_id NUMBER)
230: is select 1 from BEN_PER_PIN_F

Line 2006: -- Testing for values in BEN_PER_BNFTS_BAL_F

2002: --
2003: close c55;
2004:
2005: --
2006: -- Testing for values in BEN_PER_BNFTS_BAL_F
2007: --
2008: open c56(p_bg_id);
2009: --
2010: fetch c56 into l_temp;

Line 2014: fnd_message.set_token('TABLE_NAME','BEN_PER_BNFTS_BAL_F');

2010: fetch c56 into l_temp;
2011: if c56%found then
2012: close c56;
2013: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2014: fnd_message.set_token('TABLE_NAME','BEN_PER_BNFTS_BAL_F');
2015: fnd_message.raise_error;
2016: end if;
2017: --
2018: close c56;

Line 5742: delete from BEN_PER_BNFTS_BAL_F

5738:
5739: delete from BEN_ORG_UNIT_PRDCT_F
5740: where business_group_id = p_bg_id;
5741:
5742: delete from BEN_PER_BNFTS_BAL_F
5743: where business_group_id = p_bg_id;
5744:
5745: delete from BEN_PER_PIN_F
5746: where business_group_id = p_bg_id;