APPS.BEN_ERG_BUS dependencies on BEN_ELIG_PERF_RTNG_PRTE_F

Line 60: ben_erg_shd.constraint_error('BEN_ELIG_PERF_RTNG_PRTE_F_PK');

56: <> ben_erg_shd.g_old_rec.ELIG_PERF_RTNG_PRTE_id) then
57: --
58: -- raise error as PK has changed
59: --
60: ben_erg_shd.constraint_error('BEN_ELIG_PERF_RTNG_PRTE_F_PK');
61: --
62: elsif not l_api_updating then
63: --
64: -- check if PK is null

Line 70: ben_erg_shd.constraint_error('BEN_ELIG_PERF_RTNG_PRTE_F_PK');

66: if p_ELIG_PERF_RTNG_PRTE_id is not null then
67: --
68: -- raise error as PK is not null
69: --
70: ben_erg_shd.constraint_error('BEN_ELIG_PERF_RTNG_PRTE_F_PK');
71: --
72: end if;
73: --
74: end if;

Line 347: from ben_ELIG_PERF_RTNG_PRTE_f erg

343: l_dummy varchar2(1);
344: --
345: cursor c1 is
346: select null
347: from ben_ELIG_PERF_RTNG_PRTE_f erg
348: where nvl(erg.event_type,'xxxx') = nvl(p_event_type,'xxxx')
349: and nvl(erg.perf_rtng_cd,'xxxx') = nvl(p_perf_rtng_cd,'xxxx')
350: and erg.ELIGY_PRFL_id = p_ELIGY_PRFL_id
351: and erg.ELIG_PERF_RTNG_PRTE_id <> nvl(p_ELIG_PERF_RTNG_PRTE_id,hr_api.g_number)

Line 415: from ben_ELIG_PERF_RTNG_PRTE_f

411: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
412: l_dummy char(1);
413: cursor c1 is
414: select null
415: from ben_ELIG_PERF_RTNG_PRTE_f
416: where ELIG_PERF_RTNG_PRTE_id <> nvl(p_ELIG_PERF_RTNG_PRTE_id,-1)
417: and eligy_prfl_id = p_eligy_prfl_id
418: and ordr_num = p_ordr_num
419: and business_group_id = p_business_group_id;

Line 807: ben_ELIG_PERF_RTNG_PRTE_f b

803: --
804: cursor csr_leg_code is
805: select a.legislation_code
806: from per_business_groups a,
807: ben_ELIG_PERF_RTNG_PRTE_f b
808: where b.ELIG_PERF_RTNG_PRTE_id = p_ELIG_PERF_RTNG_PRTE_id
809: and a.business_group_id = b.business_group_id;
810: --
811: -- Declare local variables