APPS.BEN_ECQ_BUS dependencies on BEN_PTIP_F

Line 192: from ben_ptip_f a

188: l_dummy varchar2(1);
189: --
190: cursor c1 is
191: select null
192: from ben_ptip_f a
193: where a.ptip_id = p_ptip_id;
194: --
195: Begin
196: --

Line 209: -- check if ptip_id value exists in ben_ptip_f table

205: and nvl(p_ptip_id,hr_api.g_number)
206: <> nvl(ben_ecq_shd.g_old_rec.ptip_id,hr_api.g_number)
207: or not l_api_updating) and p_ptip_id is not null then
208: --
209: -- check if ptip_id value exists in ben_ptip_f table
210: --
211: open c1;
212: --
213: fetch c1 into l_dummy;

Line 218: -- raise error as FK does not relate to PK in ben_ptip_f

214: if c1%notfound then
215: --
216: close c1;
217: --
218: -- raise error as FK does not relate to PK in ben_ptip_f
219: -- table.
220: --
221: ben_ecq_shd.constraint_error('BEN_ELIG_CBR_QUALD_BNF_F_DT2');
222: --

Line 452: (p_base_table_name => 'ben_ptip_f',

448: Raise l_integrity_error;
449: End If;
450: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
451: NOT (dt_api.check_min_max_dates
452: (p_base_table_name => 'ben_ptip_f',
453: p_base_key_column => 'ptip_id',
454: p_base_key_value => p_ptip_id,
455: p_from_date => p_validation_start_date,
456: p_to_date => p_validation_end_date))) Then

Line 457: l_table_name := 'ben_ptip_f';

453: p_base_key_column => 'ptip_id',
454: p_base_key_value => p_ptip_id,
455: p_from_date => p_validation_start_date,
456: p_to_date => p_validation_end_date))) Then
457: l_table_name := 'ben_ptip_f';
458: Raise l_integrity_error;
459: End If;
460: --
461: End If;