APPS.BEN_RTS_INS dependencies on BEN_CWB_PERSON_RATES

Line 94: -- Insert the row into: ben_cwb_person_rates

90: p_rec.object_version_number := 1; -- Initialise the object version
91: --
92: ben_rts_shd.g_api_dml := true; -- Set the api dml status
93: --
94: -- Insert the row into: ben_cwb_person_rates
95: --
96: insert into ben_cwb_person_rates
97: (person_rate_id
98: ,group_per_in_ler_id

Line 96: insert into ben_cwb_person_rates

92: ben_rts_shd.g_api_dml := true; -- Set the api dml status
93: --
94: -- Insert the row into: ben_cwb_person_rates
95: --
96: insert into ben_cwb_person_rates
97: (person_rate_id
98: ,group_per_in_ler_id
99: ,pl_id
100: ,oipl_id

Line 272: Cursor C_Sel1 is select ben_cwb_person_rates_s.nextval from sys.dual;

268: Procedure pre_insert
269: (p_rec in out nocopy ben_rts_shd.g_rec_type
270: ) is
271: --
272: Cursor C_Sel1 is select ben_cwb_person_rates_s.nextval from sys.dual;
273: --
274: Cursor C_Sel2 is
275: Select null
276: from ben_cwb_person_rates

Line 276: from ben_cwb_person_rates

272: Cursor C_Sel1 is select ben_cwb_person_rates_s.nextval from sys.dual;
273: --
274: Cursor C_Sel2 is
275: Select null
276: from ben_cwb_person_rates
277: where person_rate_id =
278: ben_rts_ins.g_person_rate_id_i;
279: --
280: l_proc varchar2(72) := g_package||'pre_insert';

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

296: --
297: -- The primary key values are already in use.
298: --
299: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
300: fnd_message.set_token('TABLE_NAME','ben_cwb_person_rates');
301: fnd_message.raise_error;
302: End If;
303: Close C_Sel2;
304: --

Line 483: (p_module_name => 'BEN_CWB_PERSON_RATES'

479: --
480: when hr_api.cannot_find_prog_unit then
481: --
482: hr_api.cannot_find_prog_unit_error
483: (p_module_name => 'BEN_CWB_PERSON_RATES'
484: ,p_hook_type => 'AI');
485: --
486: end;
487: --