APPS.BEN_PZR_BUS dependencies on BEN_PSTL_ZIP_RNG_F

Line 126: from ben_pstl_zip_rng_f a

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

Line 158: -- check if pstl_zip_rng_id value exists in ben_pstl_zip_rng_f table

154: and nvl(p_pstl_zip_rng_id,hr_api.g_number)
155: <> nvl(ben_pzr_shd.g_old_rec.pstl_zip_rng_id,hr_api.g_number)
156: or not l_api_updating) then
157: --
158: -- check if pstl_zip_rng_id value exists in ben_pstl_zip_rng_f table
159: --
160: open c1;
161: --
162: fetch c1 into l_dummy;

Line 167: -- raise error as FK does not relate to PK in ben_pstl_zip_rng_f

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

Line 407: (p_base_table_name => 'ben_pstl_zip_rng_f',

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

Line 412: l_table_name := 'ben_pstl_zip_rng_f';

408: p_base_key_column => 'pstl_zip_rng_id',
409: p_base_key_value => p_pstl_zip_rng_id,
410: p_from_date => p_validation_start_date,
411: p_to_date => p_validation_end_date))) Then
412: l_table_name := 'ben_pstl_zip_rng_f';
413: Raise l_integrity_error;
414: End If;
415: --
416: End If;