APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_JOB_PRTE_F

Line 982: is select 1 from BEN_ELIG_JOB_PRTE_F

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
983: where business_group_id = p_bg_id;
984:
985: cursor c247(p_bg_id NUMBER)
986: is select 1 from BEN_WV_PRTN_RSN_CTFN_PTIP_F

Line 4841: -- Testing for values in BEN_ELIG_JOB_PRTE_F

4837: --
4838: close c245;
4839:
4840: --
4841: -- Testing for values in BEN_ELIG_JOB_PRTE_F
4842: --
4843: open c246(p_bg_id);
4844: --
4845: fetch c246 into l_temp;

Line 4849: fnd_message.set_token('TABLE_NAME','BEN_ELIG_JOB_PRTE_F');

4845: fetch c246 into l_temp;
4846: if c246%found then
4847: close c246;
4848: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4849: fnd_message.set_token('TABLE_NAME','BEN_ELIG_JOB_PRTE_F');
4850: fnd_message.raise_error;
4851: end if;
4852: --
4853: close c246;

Line 6309: delete from BEN_ELIG_JOB_PRTE_F

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;
6311:
6312: delete from BEN_WV_PRTN_RSN_CTFN_PTIP_F
6313: where business_group_id = p_bg_id;