APPS.BEN_CPG_SHD dependencies on BEN_CWB_PERSON_GROUPS

Line 33: If (p_constraint_name = 'BEN_CWB_PERSON_GROUPS_PK') Then

29: l_proc varchar2(72) := g_package||'constraint_error';
30: --
31: Begin
32: --
33: If (p_constraint_name = 'BEN_CWB_PERSON_GROUPS_PK') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;

Line 99: from ben_cwb_person_groups

95: ,ws_bdgt_val_last_upd_by
96: ,dist_bdgt_val_last_upd_by
97: ,rsrv_val_last_upd_by
98: ,object_version_number
99: from ben_cwb_person_groups
100: where group_per_in_ler_id = p_group_per_in_ler_id
101: and group_pl_id = p_group_pl_id
102: and group_oipl_id = p_group_oipl_id;
103: --

Line 210: from ben_cwb_person_groups

206: ,ws_bdgt_val_last_upd_by
207: ,dist_bdgt_val_last_upd_by
208: ,rsrv_val_last_upd_by
209: ,object_version_number
210: from ben_cwb_person_groups
211: where group_per_in_ler_id = p_group_per_in_ler_id
212: and group_pl_id = p_group_pl_id
213: and group_oipl_id = p_group_oipl_id
214: for update nowait;

Line 283: fnd_message.set_token('TABLE_NAME', 'ben_cwb_person_groups');

279: -- The object is locked therefore we need to supply a meaningful
280: -- error message.
281: --
282: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
283: fnd_message.set_token('TABLE_NAME', 'ben_cwb_person_groups');
284: fnd_message.raise_error;
285: End lck;
286: --
287: -- ----------------------------------------------------------------------------