APPS.BEN_ORG_DELETE dependencies on BEN_ORG_UNIT_PRDCT_F

Line 222: is select 1 from BEN_ORG_UNIT_PRDCT_F

218: is select 1 from BEN_EXT_DFN
219: where business_group_id = p_bg_id;
220:
221: cursor c55(p_bg_id NUMBER)
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

Line 1991: -- Testing for values in BEN_ORG_UNIT_PRDCT_F

1987: --
1988: close c54;
1989:
1990: --
1991: -- Testing for values in BEN_ORG_UNIT_PRDCT_F
1992: --
1993: open c55(p_bg_id);
1994: --
1995: fetch c55 into l_temp;

Line 1999: fnd_message.set_token('TABLE_NAME','BEN_ORG_UNIT_PRDCT_F');

1995: fetch c55 into l_temp;
1996: if c55%found then
1997: close c55;
1998: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1999: fnd_message.set_token('TABLE_NAME','BEN_ORG_UNIT_PRDCT_F');
2000: fnd_message.raise_error;
2001: end if;
2002: --
2003: close c55;

Line 5739: delete from BEN_ORG_UNIT_PRDCT_F

5735:
5736: delete from BEN_EXT_DFN
5737: where business_group_id = p_bg_id;
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;

Line 6459: delete from BEN_ORG_UNIT_PRDCT_F

6455:
6456: end delete_below_bg;
6457: procedure delete_below_org(p_org_id NUMBER) is
6458: BEGIN
6459: delete from BEN_ORG_UNIT_PRDCT_F
6460: where organization_id = p_org_id;
6461:
6462: delete from BEN_ELIG_LGL_ENTY_PRTE_F
6463: where organization_id = p_org_id;