APPS.BEN_SAR_BUS dependencies on BEN_SVC_AREA_F

Line 125: from ben_svc_area_f a

121: l_exists varchar2(1);
122: --
123: cursor c1 is
124: select null
125: from ben_svc_area_f a
126: where a.svc_area_id = p_svc_area_id
127: and a.business_group_id = p_business_group_id
128: and p_effective_date between effective_start_date
129: and nvl(effective_end_date,p_effective_date);

Line 157: -- check if p_svc_area_id value exists in ben_svc_area_f table

153: and nvl(p_svc_area_id,hr_api.g_number)
154: <> nvl(ben_sar_shd.g_old_rec.svc_area_id,hr_api.g_number)
155: or not l_api_updating) then
156: --
157: -- check if p_svc_area_id value exists in ben_svc_area_f table
158: --
159: open c1;
160: --
161: fetch c1 into l_dummy;

Line 166: -- raise error as FK does not relate to PK in ben_svc_area_f

162: if c1%notfound then
163: --
164: close c1;
165: --
166: -- raise error as FK does not relate to PK in ben_svc_area_f
167: -- table.
168: --
169: ben_pzr_shd.constraint_error('BEN_SVC_AREA_RT_PK');
170: --

Line 406: (p_base_table_name => 'ben_svc_area_f',

402: Raise l_integrity_error;
403: End If;
404: If ((nvl(p_svc_area_id, hr_api.g_number) <> hr_api.g_number) and
405: NOT (dt_api.check_min_max_dates
406: (p_base_table_name => 'ben_svc_area_f',
407: p_base_key_column => 'svc_area_id',
408: p_base_key_value => p_svc_area_id,
409: p_from_date => p_validation_start_date,
410: p_to_date => p_validation_end_date))) Then

Line 411: l_table_name := 'ben_svc_area_f';

407: p_base_key_column => 'svc_area_id',
408: p_base_key_value => p_svc_area_id,
409: p_from_date => p_validation_start_date,
410: p_to_date => p_validation_end_date))) Then
411: l_table_name := 'ben_svc_area_f';
412: Raise l_integrity_error;
413: End If;
414: --
415: End If;