370: and papf.person_id = pged.user_id
371: order by papf.effective_start_date desc;
372:
373: cursor c_get_user_name(personid number) is 374: select user_name from fnd_user 375: where employee_id = personid;
376:
377: cursor csr_get_ovn is
378: select object_version_number