476: -- PLEASE VERIFY: Inserted by Dinkar. Karumuri
477:
478: SELECT sysdate
479: INTO l_effective_date
480: FROM dual;
481:
482:
483: -- p_effective_date is currently date_from. Verify it.
484:
517: Begin
518:
519: select sysdate
520: into l_effective_date
521: from dual;
522:
523: hr_utility.set_location('Entering:'||l_proc, 5);
524: --
525: -- Set up the CLIENT_INFO