APPS.BEN_SEED_COMMUNICATION_TYPES dependencies on BEN_CM_TYP_F

Line 37: insert into ben_cm_typ_f

33: begin
34: --
35: hr_utility.set_location ('Entering '||l_package,10);
36: --
37: insert into ben_cm_typ_f
38: (cm_typ_id,
39: effective_start_date,
40: effective_end_date,
41: name,

Line 65: from ben_cm_typ_f ct

61: p_business_group_id,
62: 1
63: from ben_startup_cm_typ s_ct
64: where not exists (select 1
65: from ben_cm_typ_f ct
66: where s_ct.name = ct.name
67: and s_ct.shrt_name = ct.shrt_name
68: and ct.business_group_id = p_business_group_id);
69: --

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 98: from ben_cm_typ_f b

94: b.last_updated_by,
95: b.last_update_login,
96: b.created_by,
97: b.creation_date
98: from ben_cm_typ_f b
99: ,ben_startup_cm_typ_tl tl
100: where b.business_group_id = p_business_group_id
101: and b.shrt_name = tl.shrt_name
102: and not exists

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: --