APPS.BEN_ORG_DELETE dependencies on BEN_PER_IN_LGL_ENTY_F

Line 406: is select 1 from BEN_PER_IN_LGL_ENTY_F

402: is select 1 from BEN_PER_DLVRY_MTHD_F
403: where business_group_id = p_bg_id;
404:
405: cursor c101(p_bg_id NUMBER)
406: is select 1 from BEN_PER_IN_LGL_ENTY_F
407: where business_group_id = p_bg_id;
408:
409: cursor c102(p_bg_id NUMBER)
410: is select 1 from BEN_PER_IN_ORG_UNIT_F

Line 2681: -- Testing for values in BEN_PER_IN_LGL_ENTY_F

2677: --
2678: close c100;
2679:
2680: --
2681: -- Testing for values in BEN_PER_IN_LGL_ENTY_F
2682: --
2683: open c101(p_bg_id);
2684: --
2685: fetch c101 into l_temp;

Line 2689: fnd_message.set_token('TABLE_NAME','BEN_PER_IN_LGL_ENTY_F');

2685: fetch c101 into l_temp;
2686: if c101%found then
2687: close c101;
2688: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2689: fnd_message.set_token('TABLE_NAME','BEN_PER_IN_LGL_ENTY_F');
2690: fnd_message.raise_error;
2691: end if;
2692: --
2693: close c101;

Line 5877: delete from BEN_PER_IN_LGL_ENTY_F

5873:
5874: delete from BEN_PER_DLVRY_MTHD_F
5875: where business_group_id = p_bg_id;
5876:
5877: delete from BEN_PER_IN_LGL_ENTY_F
5878: where business_group_id = p_bg_id;
5879:
5880: delete from BEN_PER_IN_ORG_UNIT_F
5881: where business_group_id = p_bg_id;

Line 6474: delete from BEN_PER_IN_LGL_ENTY_F

6470:
6471: delete from BEN_REGN_FOR_REGY_BODY_F
6472: where organization_id = p_org_id;
6473:
6474: delete from BEN_PER_IN_LGL_ENTY_F
6475: where organization_id = p_org_id;
6476:
6477: delete from BEN_PER_IN_ORG_UNIT_F
6478: where organization_id = p_org_id;