APPS.BEN_CQR_BUS dependencies on BEN_PTIP_F

Line 295: from ben_ptip_f a

291: l_dummy varchar2(1);
292: --
293: cursor c1 is
294: select null
295: from ben_ptip_f a
296: where a.ptip_id = p_ptip_id;
297: --
298: Begin
299: --

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

308: and nvl(p_ptip_id,hr_api.g_number)
309: <> nvl(ben_cqr_shd.g_old_rec.ptip_id,hr_api.g_number)
310: or not l_api_updating) and p_ptip_id is not null then
311: --
312: -- check if ptip_id value exists in ben_ptip_f table
313: --
314: open c1;
315: --
316: fetch c1 into l_dummy;

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

317: if c1%notfound then
318: --
319: close c1;
320: --
321: -- raise error as FK does not relate to PK in ben_ptip_f
322: -- table.
323: --
324: ben_cqr_shd.constraint_error('BEN_CBR_QUALD_BNF_RT_F_DT2');
325: --

Line 563: (p_base_table_name => 'ben_ptip_f',

559: Raise l_integrity_error;
560: End If;
561: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
562: NOT (dt_api.check_min_max_dates
563: (p_base_table_name => 'ben_ptip_f',
564: p_base_key_column => 'ptip_id',
565: p_base_key_value => p_ptip_id,
566: p_from_date => p_validation_start_date,
567: p_to_date => p_validation_end_date))) Then

Line 568: l_table_name := 'ben_ptip_f';

564: p_base_key_column => 'ptip_id',
565: p_base_key_value => p_ptip_id,
566: p_from_date => p_validation_start_date,
567: p_to_date => p_validation_end_date))) Then
568: l_table_name := 'ben_ptip_f';
569: Raise l_integrity_error;
570: End If;
571: --
572: End If;