DBA Data[Home] [Help]

APPS.BEN_GOS_BUS dependencies on BEN_GD_OR_SVC_TYP

Line 56: ben_gos_shd.constraint_error('BEN_GD_OR_SVC_TYP_PK');

52: <> ben_gos_shd.g_old_rec.gd_or_svc_typ_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_gos_shd.constraint_error('BEN_GD_OR_SVC_TYP_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: ben_gos_shd.constraint_error('BEN_GD_OR_SVC_TYP_PK');

62: if p_gd_or_svc_typ_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_gos_shd.constraint_error('BEN_GD_OR_SVC_TYP_PK');
67: --
68: end if;
69: --
70: end if;

Line 184: from BEN_GD_OR_SVC_TYP

180: --
181: --
182: cursor csr_name is
183: select null
184: from BEN_GD_OR_SVC_TYP
185: where name = p_name
186: and gd_or_svc_typ_id <> nvl(p_gd_or_svc_typ_id, hr_api.g_number)
187: and business_group_id + 0 = p_business_group_id;
188: --

Line 327: ben_gd_or_svc_typ b

323: --
324: cursor csr_leg_code is
325: select a.legislation_code
326: from per_business_groups a,
327: ben_gd_or_svc_typ b
328: where b.gd_or_svc_typ_id = p_gd_or_svc_typ_id
329: and a.business_group_id = b.business_group_id;
330: --
331: -- Declare local variables