APPS.BEN_OLA_BUS dependencies on BEN_CSR_ACTIVITIES

Line 56: ben_ola_shd.constraint_error('BEN_CSR_ACTIVITIES_PK');

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

Line 66: ben_ola_shd.constraint_error('BEN_CSR_ACTIVITIES_PK');

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

Line 275: from ben_csr_activities

271: --
272: l_proc varchar2(72) := g_package||'chk_duplicate_function_name';
273: l_dummy varchar2(1) ;
274: Cursor c1 is select null
275: from ben_csr_activities
276: where (csr_activities_id <> p_csr_activities_id or p_csr_activities_id is null)and
277: function_name = p_function_name and
278: business_group_id = p_business_group_id;
279: --

Line 356: from BEN_CSR_ACTIVITIES bca

352: l_api_updating boolean;
353: --
354: cursor c1 is
355: select 1
356: from BEN_CSR_ACTIVITIES bca
357: where bca.business_group_id +0 = p_business_group_id
358: and bca.csr_activities_id <> nvl(p_csr_activities_id,-1)
359: and bca.ordr_num = p_ordr_num
360: and nvl(bca.end_date, hr_api.g_eot) >= nvl(p_csr_start_date, hr_api.g_sot)

Line 534: ben_csr_activities b

530: --
531: cursor csr_leg_code is
532: select a.legislation_code
533: from per_business_groups a,
534: ben_csr_activities b
535: where b.csr_activities_id = p_csr_activities_id
536: and a.business_group_id = b.business_group_id;
537: --
538: -- Declare local variables