2255:
2256: CURSOR c_person_fullname IS
2257: select
2258: p.full_name person_name 2259: from per_people_f p 2260: where
2261: p.person_id = p_user_id
2262: and sysdate between p.effective_start_date and p.effective_end_date;
2263:
Line 2298: from per_people_f p , fnd_user fus
2294:
2295: CURSOR c_person_fullname IS
2296: select
2297: p.full_name person_name 2298: from per_people_f p , fnd_user fus 2299: where p.person_id = fus.employee_id
2300: and
2301: fus.user_id = p_user_id;
2302: