APPS.BEN_SEED_REGULATIONS dependencies on BEN_REGN_F

Line 35: insert into ben_regn_f

31: begin
32: --
33: hr_utility.set_location ('Entering '||l_package,10);
34: --
35: insert into ben_regn_f
36: (regn_id,
37: effective_start_date,
38: effective_end_date,
39: name,

Line 44: ben_regn_f_s.nextval,

40: sttry_citn_name,
41: business_group_id,
42: object_version_number)
43: select
44: ben_regn_f_s.nextval,
45: to_date('01-01-1950','DD-MM-YYYY'),
46: to_date('31-12-4712','DD-MM-YYYY'),
47: name,
48: sttry_citn_name,

Line 53: from ben_regn_f reg

49: p_business_group_id,
50: 1
51: from ben_startup_regn s_reg
52: where not exists (select 1
53: from ben_regn_f reg
54: where s_reg.sttry_citn_name = reg.sttry_citn_name
55: and reg.business_group_id = p_business_group_id
56: );
57: --

Line 60: insert into ben_regn_f_tl (

56: );
57: --
58: -- Insert into MLS table.
59: --
60: insert into ben_regn_f_tl (
61: regn_id,
62: effective_start_date,
63: effective_end_date,
64: name,

Line 86: from ben_regn_f b

82: b.last_updated_by,
83: b.last_update_login,
84: b.created_by,
85: b.creation_date
86: from ben_regn_f b
87: ,ben_startup_regn_tl tl
88: where b.business_group_id = p_business_group_id
89: and b.sttry_citn_name = tl.sttry_citn_name
90: and not exists

Line 92: from ben_regn_f_tl t

88: where b.business_group_id = p_business_group_id
89: and b.sttry_citn_name = tl.sttry_citn_name
90: and not exists
91: (select 'Y'
92: from ben_regn_f_tl t
93: where t.regn_id = b.regn_id
94: and t.effective_start_date = b.effective_start_date
95: and t.source_lang = userenv('LANG'));
96: --