APPS.BEN_SEED_COMMUNICATION_TYPES dependencies on BEN_CM_TYP_F_TL

Line 72: insert into ben_cm_typ_f_tl (

68: and ct.business_group_id = p_business_group_id);
69: --
70: -- Insert into MLS table.
71: --
72: insert into ben_cm_typ_f_tl (
73: cm_typ_id,
74: effective_start_date,
75: effective_end_date,
76: shrt_name,

Line 104: from ben_cm_typ_f_tl t

100: where b.business_group_id = p_business_group_id
101: and b.shrt_name = tl.shrt_name
102: and not exists
103: (select 'Y'
104: from ben_cm_typ_f_tl t
105: where t.cm_typ_id = b.cm_typ_id
106: and t.effective_start_date = b.effective_start_date
107: and t.source_lang = userenv('LANG'));
108: --