DBA Data[Home] [Help]

APPS.BEN_EDD_BUS dependencies on BEN_ELIG_DSBLTY_DGR_PRTE_F

Line 134: from ben_elig_dsblty_dgr_prte_f

130: --
131: --
132: cursor c3 is
133: select null
134: from ben_elig_dsblty_dgr_prte_f
135: where degree = p_degree
136: and eligy_prfl_id = p_eligy_prfl_id
137: and elig_dsblty_dgr_prte_id <> nvl(p_elig_dsblty_dgr_prte_id,hr_api.g_number)
138: and business_group_id + 0 = p_business_group_id

Line 208: ben_edd_shd.constraint_error('BEN_ELIG_dsblty_dgr_PRTE_FK2');

204: --
205: -- raise error as FK does not relate to PK in per_person_types
206: -- table.
207: --
208: ben_edd_shd.constraint_error('BEN_ELIG_dsblty_dgr_PRTE_FK2');
209: --
210: end if;
211: --
212: close c1;

Line 240: -- ben_edd_shd.constraint_error('BEN_ELIG_dsblty_dgr_PRTE_FK2');

236: close c2;
237: --
238: -- raise error as person type can not be set to not employee
239: -- need to create message
240: -- ben_edd_shd.constraint_error('BEN_ELIG_dsblty_dgr_PRTE_FK2');
241: fnd_message.set_name('BEN', 'BEN_91387_INV_dsblty_dgrE');
242: fnd_message.raise_error;
243: --
244: end if;

Line 758: ben_elig_dsblty_dgr_prte_f b

754: --
755: cursor csr_leg_code is
756: select a.legislation_code
757: from per_business_groups a,
758: ben_elig_dsblty_dgr_prte_f b
759: where b.elig_dsblty_dgr_prte_id = p_elig_dsblty_dgr_prte_id
760: and a.business_group_id = b.business_group_id;
761: --
762: -- Declare local variables