APPS.BEN_ORG_DELETE dependencies on BEN_PER_DLVRY_MTHD_F

Line 402: is select 1 from BEN_PER_DLVRY_MTHD_F

398: is select 1 from BEN_ELIG_GRD_PRTE_F
399: where business_group_id = p_bg_id;
400:
401: cursor c100(p_bg_id NUMBER)
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

Line 2666: -- Testing for values in BEN_PER_DLVRY_MTHD_F

2662: --
2663: close c99;
2664:
2665: --
2666: -- Testing for values in BEN_PER_DLVRY_MTHD_F
2667: --
2668: open c100(p_bg_id);
2669: --
2670: fetch c100 into l_temp;

Line 2674: fnd_message.set_token('TABLE_NAME','BEN_PER_DLVRY_MTHD_F');

2670: fetch c100 into l_temp;
2671: if c100%found then
2672: close c100;
2673: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2674: fnd_message.set_token('TABLE_NAME','BEN_PER_DLVRY_MTHD_F');
2675: fnd_message.raise_error;
2676: end if;
2677: --
2678: close c100;

Line 5874: delete from BEN_PER_DLVRY_MTHD_F

5870:
5871: delete from BEN_ELIG_GRD_PRTE_F
5872: where business_group_id = p_bg_id;
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;