APPS.BEN_ORG_DELETE dependencies on BEN_CM_DLVRY_MTHD_TYP

Line 178: is select 1 from BEN_CM_DLVRY_MTHD_TYP

174: is select 1 from BEN_CMBN_AGE_LOS_FCTR
175: where business_group_id = p_bg_id;
176:
177: cursor c44(p_bg_id NUMBER)
178: is select 1 from BEN_CM_DLVRY_MTHD_TYP
179: where business_group_id = p_bg_id;
180:
181: cursor c45(p_bg_id NUMBER)
182: is select 1 from BEN_CNTNU_PRTN_CTFN_TYP_F

Line 1826: -- Testing for values in BEN_CM_DLVRY_MTHD_TYP

1822: --
1823: close c43;
1824:
1825: --
1826: -- Testing for values in BEN_CM_DLVRY_MTHD_TYP
1827: --
1828: open c44(p_bg_id);
1829: --
1830: fetch c44 into l_temp;

Line 1834: fnd_message.set_token('TABLE_NAME','BEN_CM_DLVRY_MTHD_TYP');

1830: fetch c44 into l_temp;
1831: if c44%found then
1832: close c44;
1833: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1834: fnd_message.set_token('TABLE_NAME','BEN_CM_DLVRY_MTHD_TYP');
1835: fnd_message.raise_error;
1836: end if;
1837: --
1838: close c44;

Line 5706: delete from BEN_CM_DLVRY_MTHD_TYP

5702:
5703: delete from BEN_CMBN_AGE_LOS_FCTR
5704: where business_group_id = p_bg_id;
5705:
5706: delete from BEN_CM_DLVRY_MTHD_TYP
5707: where business_group_id = p_bg_id;
5708:
5709: delete from BEN_CNTNU_PRTN_CTFN_TYP_F
5710: where business_group_id = p_bg_id;