APPS.BEN_ORG_DELETE dependencies on BEN_WV_PRTN_RSN_CTFN_PTIP_F

Line 986: is select 1 from BEN_WV_PRTN_RSN_CTFN_PTIP_F

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
987: where business_group_id = p_bg_id;
988:
989: cursor c248(p_bg_id NUMBER)
990: is select 1 from BEN_BATCH_COMMU_INFO

Line 4856: -- Testing for values in BEN_WV_PRTN_RSN_CTFN_PTIP_F

4852: --
4853: close c246;
4854:
4855: --
4856: -- Testing for values in BEN_WV_PRTN_RSN_CTFN_PTIP_F
4857: --
4858: open c247(p_bg_id);
4859: --
4860: fetch c247 into l_temp;

Line 4864: fnd_message.set_token('TABLE_NAME','BEN_WV_PRTN_RSN_CTFN_PTIP_F');

4860: fetch c247 into l_temp;
4861: if c247%found then
4862: close c247;
4863: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4864: fnd_message.set_token('TABLE_NAME','BEN_WV_PRTN_RSN_CTFN_PTIP_F');
4865: fnd_message.raise_error;
4866: end if;
4867: --
4868: close c247;

Line 6312: delete from BEN_WV_PRTN_RSN_CTFN_PTIP_F

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;
6314:
6315: delete from BEN_BATCH_COMMU_INFO
6316: where business_group_id = p_bg_id;