167: --
168: procedure load_rows
169: (p_mass_move_id in number)
170: is
171: l_effective_date per_mass_moves.effective_date%type;
172:
173: BEGIN
174: hr_utility.set_location('Inside Load_rows. before insert ',10);
175: -- added for 7214283
173: BEGIN
174: hr_utility.set_location('Inside Load_rows. before insert ',10);
175: -- added for 7214283
176: select effective_date into l_effective_date
177: from per_mass_moves where mass_move_id = p_mass_move_id;
178: -- added for 7214283
179:
180: insert into per_mm_valid_grades
181: (MASS_MOVE_ID,