APPS.BEN_EPT_BUS dependencies on BEN_ELIG_PER_TYP_PRTE_F

Line 25: from ben_elig_per_typ_prte_f b

21:
22: /*--
23: cursor c1 is
24: select null
25: from ben_elig_per_typ_prte_f b
26: where b.eligy_prfl_id = p_eligy_prfl_id
27: and b.per_typ_cd NOT IN ('EMP', 'EMP_APL')
28: and b.excld_flag = 'N';
29: -- */

Line 205: from ben_elig_per_typ_prte_f

201: --
202: --
203: cursor c3 is
204: select null
205: from ben_elig_per_typ_prte_f
206: where per_typ_cd = p_per_typ_cd
207: and eligy_prfl_id = p_eligy_prfl_id
208: and elig_per_typ_prte_id <> nvl(p_elig_per_typ_prte_id,hr_api.g_number)
209: and business_group_id + 0 = p_business_group_id

Line 280: ben_ept_shd.constraint_error('BEN_ELIG_PER_TYP_PRTE_FK2');

276: --
277: -- raise error as FK does not relate to PK in per_person_types
278: -- table.
279: --
280: ben_ept_shd.constraint_error('BEN_ELIG_PER_TYP_PRTE_FK2');
281: --
282: end if;
283: --
284: close c1;

Line 312: -- ben_ept_shd.constraint_error('BEN_ELIG_PER_TYP_PRTE_FK2');

308: close c2;
309: --
310: -- raise error as person type can not be set to not employee
311: -- need to create message
312: -- ben_ept_shd.constraint_error('BEN_ELIG_PER_TYP_PRTE_FK2');
313: fnd_message.set_name('BEN', 'BEN_91387_INV_PER_TYPE');
314: fnd_message.raise_error;
315: --
316: end if;

Line 538: from ben_elig_per_typ_prte_f

534: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
535: l_dummy char(1);
536: cursor c1 is
537: select null
538: from ben_elig_per_typ_prte_f
539: where elig_per_typ_prte_id <> nvl(p_elig_per_typ_prte_id,-1)
540: and eligy_prfl_id = p_eligy_prfl_id
541: and ordr_num = p_ordr_num
542: and business_group_id = p_business_group_id;

Line 936: ben_elig_per_typ_prte_f b

932: --
933: cursor csr_leg_code is
934: select a.legislation_code
935: from per_business_groups a,
936: ben_elig_per_typ_prte_f b
937: where b.elig_per_typ_prte_id = p_elig_per_typ_prte_id
938: and a.business_group_id = b.business_group_id;
939: --
940: -- Declare local variables