[Home] [Help]
16: Date Who Version What?
17: ---- --- ------- -----
18: 24 Jan 98 G Perry 110.0 Created.
19: 08 Apr 98 G Perry 110.1 Accounted for schema change
20: to ben_ler_f.
21: 16 Jun 98 G Perry 110.2 Rewrote insert going straight
22: to the table to avoid mutating
23: table issues.
24: 31-dec-98 jlamoure 110.3 Added new life events QMSCO and
52: begin
53: --
54: hr_utility.set_location ('Entering '||l_package,10);
55: --
56: insert into ben_ler_f
57: (ler_id,
58: effective_start_date,
59: effective_end_date,
60: name,
67: tmlns_eval_cd, -- 5367645
68: tmlns_dys_num, -- 5367645
69: object_version_number)
70: select
71: ben_ler_f_s.nextval,
72: to_date('01-01-1950','DD-MM-YYYY'),
73: to_date('31-12-4712','DD-MM-YYYY'),
74: name,
75: p_business_group_id,
82: decode(TYP_CD,'DRVDAGE',90, 'DRVDCAL',90,'DRVDCMP',90,'DRVDHRW',90,'DRVDLOS',90,NULL) ,
83: 1
84: from ben_startup_lers s_ler
85: where not exists (select 1
86: from ben_ler_f ler
87: where s_ler.typ_cd = ler.typ_cd
88: and ler.business_group_id = p_business_group_id
89: );
90:
92: -- from the above select statement to make it lesser restrictive.
93: --
94: -- Insert into MLS table.
95: --
96: insert into ben_ler_f_tl (
97: ler_id,
98: effective_start_date,
99: effective_end_date,
100: typ_cd,
118: b.last_updated_by,
119: b.last_update_login,
120: b.created_by,
121: b.creation_date
122: from ben_ler_f b
123: ,ben_startup_lers_tl tl
124: where b.business_group_id = p_business_group_id
125: and b.typ_cd = tl.typ_cd
126: and not exists
124: where b.business_group_id = p_business_group_id
125: and b.typ_cd = tl.typ_cd
126: and not exists
127: (select 'Y'
128: from ben_ler_f_tl t
129: where t.ler_id = b.ler_id
130: and t.effective_start_date = b.effective_start_date
131: and t.source_lang = userenv('LANG'));
132: