APPS.BEN_RTS_SHD dependencies on BEN_CWB_PERSON_RATES

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

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

111: ,comp_posting_date
112: ,ws_rt_start_date
113: ,currency
114: ,object_version_number
115: from ben_cwb_person_rates
116: where group_per_in_ler_id = p_group_per_in_ler_id
117: and pl_id = p_pl_id
118: and oipl_id = p_oipl_id;
119: --

Line 242: from ben_cwb_person_rates

238: ,comp_posting_date
239: ,ws_rt_start_date
240: ,currency
241: ,object_version_number
242: from ben_cwb_person_rates
243: where group_per_in_ler_id = p_group_per_in_ler_id
244: and pl_id = p_pl_id
245: and oipl_id = p_oipl_id
246: for update nowait;

Line 305: fnd_message.set_token('TABLE_NAME', 'ben_cwb_person_rates');

301: -- The object is locked therefore we need to supply a meaningful
302: -- error message.
303: --
304: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
305: fnd_message.set_token('TABLE_NAME', 'ben_cwb_person_rates');
306: fnd_message.raise_error;
307: End lck;
308: --
309: -- ----------------------------------------------------------------------------