APPS.BEN_ELR_BUS dependencies on BEN_ELIG_LOA_RSN_PRTE_F

Line 59: ben_elr_shd.constraint_error('BEN_ELIG_LOA_RSN_PRTE_F_PK');

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

Line 69: ben_elr_shd.constraint_error('BEN_ELIG_LOA_RSN_PRTE_F_PK');

65: if p_elig_loa_rsn_prte_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_elr_shd.constraint_error('BEN_ELIG_LOA_RSN_PRTE_F_PK');
70: --
71: end if;
72: --
73: end if;

Line 220: ben_elr_shd.constraint_error('BEN_ELIG_LOA_RSN_PRTE_F_FK2');

216: --
217: -- raise error as FK does not relate to PK in
218: -- per_absence_attendance_types table.
219: --
220: ben_elr_shd.constraint_error('BEN_ELIG_LOA_RSN_PRTE_F_FK2');
221: --
222: end if;
223: --
224: close c1;

Line 301: ben_elr_shd.constraint_error('BEN_ELIG_LOA_RSN_PRTE_F_FK3');

297: --
298: -- raise error as FK does not relate to PK in
299: -- per_abs_attendance_reasons table.
300: --
301: ben_elr_shd.constraint_error('BEN_ELIG_LOA_RSN_PRTE_F_FK3');
302: --
303: end if;
304: --
305: close c1;

Line 356: from ben_elig_loa_rsn_prte_f elr

352: l_dummy varchar2(1);
353: --
354: cursor c1 is
355: select null
356: from ben_elig_loa_rsn_prte_f elr
357: where nvl(elr.absence_attendance_type_id,-1) = nvl(p_absence_attendance_type_id, -1)
358: and nvl(elr.abs_attendance_reason_id,-1) = nvl(p_abs_attendance_reason_id,-1)
359: and elr.eligy_prfl_id = p_eligy_prfl_id
360: and elr.elig_loa_rsn_prte_id <> nvl(p_elig_loa_rsn_prte_id,hr_api.g_number)

Line 428: from ben_elig_loa_rsn_prte_f

424: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
425: l_dummy char(1);
426: cursor c1 is
427: select null
428: from ben_elig_loa_rsn_prte_f
429: where elig_loa_rsn_prte_id <> nvl(p_elig_loa_rsn_prte_id,-1)
430: and eligy_prfl_id = p_eligy_prfl_id
431: and ordr_num = p_ordr_num
432: and business_group_id = p_business_group_id;

Line 826: ben_elig_loa_rsn_prte_f b

822: --
823: cursor csr_leg_code is
824: select a.legislation_code
825: from per_business_groups a,
826: ben_elig_loa_rsn_prte_f b
827: where b.elig_loa_rsn_prte_id = p_elig_loa_rsn_prte_id
828: and a.business_group_id = b.business_group_id;
829: --
830: -- Declare local variables