Line 151: FROM pa_resources_denorm rsd, fnd_user usr
147: -- Populating person id person name
148: BEGIN
149: SELECT rsd.resource_name,rsd.person_id
150: INTO x_login_person_name,x_login_person_id 151: FROM pa_resources_denorm rsd, fnd_user usr 152: WHERE rsd.person_id = usr.employee_id
153: AND usr.user_id = fnd_global.user_id
154: AND rsd.resource_effective_end_date >= sysdate
155: AND rownum < 2