APPS.BEN_ORG_DELETE dependencies on BEN_PTNL_LER_FOR_PER

Line 462: is select 1 from BEN_PTNL_LER_FOR_PER

458: is select 1 from BEN_PER_IN_LER
459: where business_group_id = p_bg_id;
460:
461: cursor c115(p_bg_id NUMBER)
462: is select 1 from BEN_PTNL_LER_FOR_PER
463: where business_group_id = p_bg_id;
464:
465: cursor c116(p_bg_id NUMBER)
466: is select 1 from BEN_PGM_F

Line 2891: -- Testing for values in BEN_PTNL_LER_FOR_PER

2887: --
2888: close c114;
2889:
2890: --
2891: -- Testing for values in BEN_PTNL_LER_FOR_PER
2892: --
2893: open c115(p_bg_id);
2894: --
2895: fetch c115 into l_temp;

Line 2899: fnd_message.set_token('TABLE_NAME','BEN_PTNL_LER_FOR_PER');

2895: fetch c115 into l_temp;
2896: if c115%found then
2897: close c115;
2898: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2899: fnd_message.set_token('TABLE_NAME','BEN_PTNL_LER_FOR_PER');
2900: fnd_message.raise_error;
2901: end if;
2902: --
2903: close c115;

Line 5919: delete from BEN_PTNL_LER_FOR_PER

5915:
5916: delete from BEN_PER_IN_LER
5917: where business_group_id = p_bg_id;
5918:
5919: delete from BEN_PTNL_LER_FOR_PER
5920: where business_group_id = p_bg_id;
5921:
5922: delete from BEN_PGM_F
5923: where business_group_id = p_bg_id;