DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_PROCESS dependencies on HR_PERSON_TYPE_USAGE_INFO

Line 75: hr_person_type_usage_info.get_user_person_type (p_start_period, ppf.person_id) person_type

71: IN VARCHAR2
72: ) IS
73: SELECT ppf.person_id person_id, ppf.full_name,
74: NVL (ppf.employee_number, ppf.npw_number) employee_number,
75: hr_person_type_usage_info.get_user_person_type (p_start_period, ppf.person_id) person_type
76: FROM hxc_tk_group_queries htgq,
77: hxc_tk_groups htg,
78: hxc_tk_group_query_criteria htgqc,
79: per_all_people_f ppf,

Line 122: hr_person_type_usage_info.get_user_person_type (p_start_period, ppf.person_id) person_type

118: AND ppf2.person_id = ppf.person_id)
119: UNION
120: SELECT ppf.person_id person_id, ppf.full_name,
121: NVL (ppf.employee_number, ppf.npw_number) employee_number,
122: hr_person_type_usage_info.get_user_person_type (p_start_period, ppf.person_id) person_type
123: FROM hxc_tk_group_queries htgq,
124: hxc_tk_groups htg,
125: hxc_tk_group_query_criteria htgqc,
126: per_all_people_f ppf,