APPS.BEN_EPZ_BUS dependencies on BEN_PSTL_ZIP_RNG_F

Line 123: from ben_pstl_zip_rng_f a

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

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

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

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

160: if c1%notfound then
161: --
162: close c1;
163: --
164: -- raise error as FK does not relate to PK in ben_pstl_zip_rng_f
165: -- table.
166: --
167: ben_epz_shd.constraint_error('BEN_ELIG_PSTL_CD_FK2');
168: --

Line 401: (p_base_table_name => 'ben_pstl_zip_rng_f',

397: Raise l_integrity_error;
398: End If;
399: If ((nvl(p_pstl_zip_rng_id, hr_api.g_number) <> hr_api.g_number) and
400: NOT (dt_api.check_min_max_dates
401: (p_base_table_name => 'ben_pstl_zip_rng_f',
402: p_base_key_column => 'pstl_zip_rng_id',
403: p_base_key_value => p_pstl_zip_rng_id,
404: p_from_date => p_validation_start_date,
405: p_to_date => p_validation_end_date))) Then

Line 406: l_table_name := 'ben_pstl_zip_rng_f';

402: p_base_key_column => 'pstl_zip_rng_id',
403: p_base_key_value => p_pstl_zip_rng_id,
404: p_from_date => p_validation_start_date,
405: p_to_date => p_validation_end_date))) Then
406: l_table_name := 'ben_pstl_zip_rng_f';
407: Raise l_integrity_error;
408: End If;
409: --
410: End If;