APPS.BEN_CTK_SHD dependencies on BEN_CWB_PERSON_TASKS

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

29: l_proc varchar2(72) := g_package||'constraint_error';
30: --
31: Begin
32: --
33: If (p_constraint_name = 'BEN_CWB_PERSON_TASKS_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 71: from ben_cwb_person_tasks

67: ,access_cd
68: ,task_last_update_date
69: ,task_last_update_by
70: ,object_version_number
71: from ben_cwb_person_tasks
72: where group_per_in_ler_id = p_group_per_in_ler_id
73: and task_id = p_task_id;
74: --
75: l_fct_ret boolean;

Line 150: from ben_cwb_person_tasks

146: ,access_cd
147: ,task_last_update_date
148: ,task_last_update_by
149: ,object_version_number
150: from ben_cwb_person_tasks
151: where group_per_in_ler_id = p_group_per_in_ler_id
152: and task_id = p_task_id
153: for update nowait;
154: --

Line 214: fnd_message.set_token('TABLE_NAME', 'ben_cwb_person_tasks');

210: -- The object is locked therefore we need to supply a meaningful
211: -- error message.
212: --
213: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
214: fnd_message.set_token('TABLE_NAME', 'ben_cwb_person_tasks');
215: fnd_message.raise_error;
216: End lck;
217: --
218: -- ----------------------------------------------------------------------------