DBA Data[Home] [Help]

APPS.HXT_CLOCK_USER_EDITS dependencies on PER_PEOPLE_F

Line 10: the per_people_f using the input value employee_number

6: of what an Employee Number is, get_person_id exists
7: as a user exit.
8: For base system, this call will return
9: a valid person_id, last_name, and first_name from
10: the per_people_f using the input value employee_number
11: passed in as a parameter.
12: *********************************************************/
13: FUNCTION get_person_id(i_employee_number IN VARCHAR2,
14: i_business_group_id IN NUMBER,

Line 26: FROM per_people_f

22: first_name
23: INTO o_person_id,
24: o_last_name,
25: o_first_name
26: FROM per_people_f
27: WHERE employee_number = i_employee_number
28: AND i_date_worked BETWEEN effective_start_date
29: AND effective_end_date
30: AND business_group_id = i_business_group_id;