APPS.BEN_EPO_BUS dependencies on BEN_ELIG_PER_F

Line 49: from ben_elig_per_f e,

45: l_dummy varchar2(1);
46: --
47: cursor c1 is
48: select null
49: from ben_elig_per_f e,
50: ben_oipl_f o
51: where e.elig_per_id = p_elig_per_id
52: and p_opt_id = o.opt_id
53: and p_effective_date

Line 76: ben_epo_shd.constraint_error('BEN_ELIG_PER_F_PK');

72: <> ben_epo_shd.g_old_rec.elig_per_opt_id) then
73: --
74: -- raise error as PK has changed
75: --
76: ben_epo_shd.constraint_error('BEN_ELIG_PER_F_PK');
77: --
78: elsif not l_api_updating then
79: --
80: -- check if PK is null

Line 86: ben_epo_shd.constraint_error('BEN_ELIG_PER_F_PK');

82: if p_elig_per_opt_id is not null then
83: --
84: -- raise error as PK is not null
85: --
86: ben_epo_shd.constraint_error('BEN_ELIG_PER_F_PK');
87: --
88: end if;
89: --
90: end if;

Line 1427: (p_base_table_name => 'ben_elig_per_f',

1423: p_argument_value => p_validation_end_date);
1424: --
1425: If ((nvl(p_elig_per_id, hr_api.g_number) <> hr_api.g_number) and
1426: NOT (dt_api.check_min_max_dates
1427: (p_base_table_name => 'ben_elig_per_f',
1428: p_base_key_column => 'elig_per_id',
1429: p_base_key_value => p_elig_per_id,
1430: p_from_date => p_validation_start_date,
1431: p_to_date => p_validation_end_date))) Then

Line 1432: l_table_name := 'ben_elig_per_f';

1428: p_base_key_column => 'elig_per_id',
1429: p_base_key_value => p_elig_per_id,
1430: p_from_date => p_validation_start_date,
1431: p_to_date => p_validation_end_date))) Then
1432: l_table_name := 'ben_elig_per_f';
1433: Raise l_integrity_error;
1434: End If;
1435: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and
1436: NOT (dt_api.check_min_max_dates