APPS.BEN_SEED_ACTION_ITEM_TYPES dependencies on BEN_ACTN_TYP

Line 40: insert into ben_actn_typ

36: --
37: hr_utility.set_location ('Entering '||l_package,10);
38: --
39: --
40: insert into ben_actn_typ
41: (actn_typ_id,
42: business_group_id,
43: type_cd,
44: name,

Line 48: ben_actn_typ_s.nextval,

44: name,
45: description,
46: object_version_number)
47: select
48: ben_actn_typ_s.nextval,
49: p_business_group_id,
50: s_at.type_cd,
51: s_at.name,
52: s_at.description,

Line 56: from ben_actn_typ act

52: s_at.description,
53: 1
54: from ben_startup_actn_typ s_at
55: where not exists (select 'Y'
56: from ben_actn_typ act
57: where s_at.type_cd = act.type_cd
58: and s_at.name = act.name
59: -- and s_at.description = act.description
60: and p_business_group_id = act.business_group_id);

Line 64: insert into ben_actn_typ_tl (

60: and p_business_group_id = act.business_group_id);
61: --
62: -- Also insert into MLS table.
63: --
64: insert into ben_actn_typ_tl (
65: actn_typ_id,
66: name,
67: description,
68: language,

Line 88: from ben_actn_typ b,

84: b.last_updated_by,
85: b.last_update_login,
86: b.created_by,
87: b.creation_date
88: from ben_actn_typ b,
89: ben_startup_actn_typ_tl tl
90: where b.business_group_id = p_business_group_id
91: and b.type_cd = tl.type_cd
92: and not exists

Line 94: from ben_actn_typ_tl t

90: where b.business_group_id = p_business_group_id
91: and b.type_cd = tl.type_cd
92: and not exists
93: (select 'Y'
94: from ben_actn_typ_tl t
95: where t.actn_typ_id = b.actn_typ_id
96: and t.source_lang = userenv('LANG'));
97: --
98: hr_utility.set_location ('Leaving '||l_package,10);