APPS.BEN_ORG_DELETE dependencies on BEN_PRTT_PREM_F

Line 838: is select 1 from BEN_PRTT_PREM_F

834: is select 1 from BEN_PL_R_OIPL_PREM_BY_MO_F
835: where business_group_id = p_bg_id;
836:
837: cursor c210(p_bg_id NUMBER)
838: is select 1 from BEN_PRTT_PREM_F
839: where business_group_id = p_bg_id;
840:
841: cursor c211(p_bg_id NUMBER)
842: is select 1 from BEN_ENRT_PREM

Line 4301: -- Testing for values in BEN_PRTT_PREM_F

4297: --
4298: close c209;
4299:
4300: --
4301: -- Testing for values in BEN_PRTT_PREM_F
4302: --
4303: open c210(p_bg_id);
4304: --
4305: fetch c210 into l_temp;

Line 4309: fnd_message.set_token('TABLE_NAME','BEN_PRTT_PREM_F');

4305: fetch c210 into l_temp;
4306: if c210%found then
4307: close c210;
4308: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4309: fnd_message.set_token('TABLE_NAME','BEN_PRTT_PREM_F');
4310: fnd_message.raise_error;
4311: end if;
4312: --
4313: close c210;

Line 6201: delete from BEN_PRTT_PREM_F

6197:
6198: delete from BEN_PL_R_OIPL_PREM_BY_MO_F
6199: where business_group_id = p_bg_id;
6200:
6201: delete from BEN_PRTT_PREM_F
6202: where business_group_id = p_bg_id;
6203:
6204: delete from BEN_ENRT_PREM
6205: where business_group_id = p_bg_id;