APPS.BEN_CQR_BUS dependencies on BEN_PGM_F

Line 218: from ben_pgm_f a

214: l_dummy varchar2(1);
215: --
216: cursor c1 is
217: select null
218: from ben_pgm_f a
219: where a.pgm_id = p_pgm_id;
220: --
221: Begin
222: --

Line 235: -- check if pgm_id value exists in ben_pgm_f table

231: and nvl(p_pgm_id,hr_api.g_number)
232: <> nvl(ben_cqr_shd.g_old_rec.pgm_id,hr_api.g_number)
233: or not l_api_updating) and p_pgm_id is not null then
234: --
235: -- check if pgm_id value exists in ben_pgm_f table
236: --
237: open c1;
238: --
239: fetch c1 into l_dummy;

Line 244: -- raise error as FK does not relate to PK in ben_pgm_f

240: if c1%notfound then
241: --
242: close c1;
243: --
244: -- raise error as FK does not relate to PK in ben_pgm_f
245: -- table.
246: --
247: ben_cqr_shd.constraint_error('BEN_CBR_QUALD_BNF_RT_F_DT3');
248: --

Line 553: (p_base_table_name => 'ben_pgm_f',

549: Raise l_integrity_error;
550: End If;
551: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
552: NOT (dt_api.check_min_max_dates
553: (p_base_table_name => 'ben_pgm_f',
554: p_base_key_column => 'pgm_id',
555: p_base_key_value => p_pgm_id,
556: p_from_date => p_validation_start_date,
557: p_to_date => p_validation_end_date))) Then

Line 558: l_table_name := 'ben_pgm_f';

554: p_base_key_column => 'pgm_id',
555: p_base_key_value => p_pgm_id,
556: p_from_date => p_validation_start_date,
557: p_to_date => p_validation_end_date))) Then
558: l_table_name := 'ben_pgm_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