APPS.BEN_ORG_DELETE dependencies on BEN_POPL_ORG_ROLE_F

Line 978: is select 1 from BEN_POPL_ORG_ROLE_F

974: is select 1 from BEN_PER_CM_USG_F
975: where business_group_id = p_bg_id;
976:
977: cursor c245(p_bg_id NUMBER)
978: is select 1 from BEN_POPL_ORG_ROLE_F
979: where business_group_id = p_bg_id;
980:
981: cursor c246(p_bg_id NUMBER)
982: is select 1 from BEN_ELIG_JOB_PRTE_F

Line 4826: -- Testing for values in BEN_POPL_ORG_ROLE_F

4822: --
4823: close c244;
4824:
4825: --
4826: -- Testing for values in BEN_POPL_ORG_ROLE_F
4827: --
4828: open c245(p_bg_id);
4829: --
4830: fetch c245 into l_temp;

Line 4834: fnd_message.set_token('TABLE_NAME','BEN_POPL_ORG_ROLE_F');

4830: fetch c245 into l_temp;
4831: if c245%found then
4832: close c245;
4833: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4834: fnd_message.set_token('TABLE_NAME','BEN_POPL_ORG_ROLE_F');
4835: fnd_message.raise_error;
4836: end if;
4837: --
4838: close c245;

Line 6306: delete from BEN_POPL_ORG_ROLE_F

6302:
6303: delete from BEN_PER_CM_USG_F
6304: where business_group_id = p_bg_id;
6305:
6306: delete from BEN_POPL_ORG_ROLE_F
6307: where business_group_id = p_bg_id;
6308:
6309: delete from BEN_ELIG_JOB_PRTE_F
6310: where business_group_id = p_bg_id;