APPS.BEN_ECQ_BUS dependencies on BEN_PGM_F

Line 115: from ben_pgm_f a

111: l_dummy varchar2(1);
112: --
113: cursor c1 is
114: select null
115: from ben_pgm_f a
116: where a.pgm_id = p_pgm_id;
117: --
118: Begin
119: --

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

128: and nvl(p_pgm_id,hr_api.g_number)
129: <> nvl(ben_ecq_shd.g_old_rec.pgm_id,hr_api.g_number)
130: or not l_api_updating) and p_pgm_id is not null then
131: --
132: -- check if pgm_id value exists in ben_pgm_f table
133: --
134: open c1;
135: --
136: fetch c1 into l_dummy;

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

137: if c1%notfound then
138: --
139: close c1;
140: --
141: -- raise error as FK does not relate to PK in ben_pgm_f
142: -- table.
143: --
144: ben_ecq_shd.constraint_error('BEN_ELIG_CBR_QUALD_BNF_F_DT3');
145: --

Line 442: (p_base_table_name => 'ben_pgm_f',

438: Raise l_integrity_error;
439: End If;
440: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
441: NOT (dt_api.check_min_max_dates
442: (p_base_table_name => 'ben_pgm_f',
443: p_base_key_column => 'pgm_id',
444: p_base_key_value => p_pgm_id,
445: p_from_date => p_validation_start_date,
446: p_to_date => p_validation_end_date))) Then

Line 447: l_table_name := 'ben_pgm_f';

443: p_base_key_column => 'pgm_id',
444: p_base_key_value => p_pgm_id,
445: p_from_date => p_validation_start_date,
446: p_to_date => p_validation_end_date))) Then
447: l_table_name := 'ben_pgm_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