DBA Data[Home] [Help]

APPS.HXT_TIM_COL_UTIL dependencies on PER_PEOPLE_F

Line 42: the per_people_f using the input value employee_number

38: of what an Employee Number is, get_person_id exists
39: as a user exit.
40: For base system, this call will return
41: a valid person_id, last_name, and first_name from
42: the per_people_f using the input value employee_number
43: passed in as a parameter.
44: *********************************************************/
45: FUNCTION get_person_id(i_employee_number IN VARCHAR2,
46: i_business_group_id IN NUMBER,

Line 58: FROM per_people_f

54: first_name
55: INTO o_person_id,
56: o_last_name,
57: o_first_name
58: FROM per_people_f
59: WHERE employee_number = i_employee_number
60: AND i_date_worked BETWEEN effective_start_date
61: AND effective_end_date
62: AND business_group_id = i_business_group_id;