DBA Data[Home] [Help]

APPS.HRI_OLTP_PTL_PARAM dependencies on PER_ALL_PEOPLE_F

Line 10: FROM per_all_people_f per

6: BEGIN
7: employee_id := hri_bpl_security.get_apps_signin_person_id;
8: BEGIN
9: SELECT per.full_name INTO employee_name
10: FROM per_all_people_f per
11: WHERE per.person_id = employee_id
12: AND TRUNC(SYSDATE) BETWEEN per.effective_start_date
13: AND per.effective_end_date;
14: EXCEPTION