APPS.BEN_ORG_DELETE dependencies on BEN_PSTL_ZIP_RT_F

Line 674: is select 1 from BEN_PSTL_ZIP_RT_F

670: is select 1 from BEN_PPL_GRP_RT_F
671: where business_group_id = p_bg_id;
672:
673: cursor c169(p_bg_id NUMBER)
674: is select 1 from BEN_PSTL_ZIP_RT_F
675: where business_group_id = p_bg_id;
676:
677: cursor c170(p_bg_id NUMBER)
678: is select 1 from BEN_PYRL_RT_F

Line 3686: -- Testing for values in BEN_PSTL_ZIP_RT_F

3682: --
3683: close c168;
3684:
3685: --
3686: -- Testing for values in BEN_PSTL_ZIP_RT_F
3687: --
3688: open c169(p_bg_id);
3689: --
3690: fetch c169 into l_temp;

Line 3694: fnd_message.set_token('TABLE_NAME','BEN_PSTL_ZIP_RT_F');

3690: fetch c169 into l_temp;
3691: if c169%found then
3692: close c169;
3693: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3694: fnd_message.set_token('TABLE_NAME','BEN_PSTL_ZIP_RT_F');
3695: fnd_message.raise_error;
3696: end if;
3697: --
3698: close c169;

Line 6078: delete from BEN_PSTL_ZIP_RT_F

6074:
6075: delete from BEN_PPL_GRP_RT_F
6076: where business_group_id = p_bg_id;
6077:
6078: delete from BEN_PSTL_ZIP_RT_F
6079: where business_group_id = p_bg_id;
6080:
6081: delete from BEN_PYRL_RT_F
6082: where business_group_id = p_bg_id;