APPS.PAY_PRF_INS dependencies on PAY_RANGE_TABLES_F

Line 135: -- Insert the row into: pay_range_tables_f

131: p_rec.object_version_number := 1; -- Initialise the object version
132: --
133: --
134: --
135: -- Insert the row into: pay_range_tables_f
136: --
137: insert into pay_range_tables_f
138: (range_table_id
139: ,effective_start_date

Line 137: insert into pay_range_tables_f

133: --
134: --
135: -- Insert the row into: pay_range_tables_f
136: --
137: insert into pay_range_tables_f
138: (range_table_id
139: ,effective_start_date
140: ,effective_end_date
141: ,range_table_number

Line 355: Cursor C_Sel1 is select pay_range_tables_f_s.nextval from sys.dual;

351: Procedure pre_insert
352: (p_rec in out nocopy pay_prf_shd.g_rec_type
353: ) is
354: --
355: Cursor C_Sel1 is select pay_range_tables_f_s.nextval from sys.dual;
356: --
357: Cursor C_Sel2 is
358: Select null
359: from pay_range_tables_f

Line 359: from pay_range_tables_f

355: Cursor C_Sel1 is select pay_range_tables_f_s.nextval from sys.dual;
356: --
357: Cursor C_Sel2 is
358: Select null
359: from pay_range_tables_f
360: where range_table_id =
361: pay_prf_ins.g_range_table_id_i;
362: --
363: l_proc varchar2(72) := g_package||'pre_insert';

Line 381: fnd_message.set_token('TABLE_NAME','pay_range_tables_f');

377: --
378: -- The primary key values are already in use.
379: --
380: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
381: fnd_message.set_token('TABLE_NAME','pay_range_tables_f');
382: fnd_message.raise_error;
383: End If;
384: Close C_Sel2;
385: --

Line 610: (p_module_name => 'PAY_RANGE_TABLES_F'

606: --
607: when hr_api.cannot_find_prog_unit then
608: --
609: hr_api.cannot_find_prog_unit_error
610: (p_module_name => 'PAY_RANGE_TABLES_F'
611: ,p_hook_type => 'AI');
612: --
613: end;
614: --