APPS.HXC_RPT_LOAD_TC_SNAPSHOT dependencies on PER_ALL_PEOPLE_F

Line 187: per_all_people_f ppf

183: '' ''
184: )||'']''),
185: ''p_request_id''
186: FROM hxc_time_building_blocks hxc,
187: per_all_people_f ppf
188: WHERE scope = ''TIMECARD''
189: AND person_id = resource_id
190: AND start_time >= effective_start_date
191: AND stop_time <= effective_end_date

Line 2082: per_all_people_f ppf

2078: ppf.full_name||']'
2079: FROM hxc_rpt_tc_resource_temp gt,
2080: hxc_rpt_tc_details_all det,
2081: fnd_user fnd,
2082: per_all_people_f ppf
2083: WHERE gt.tc_bb_id = det.tc_bb_id
2084: AND gt.request_id = p_request_id
2085: AND det.created_by = fnd.user_id
2086: AND fnd.employee_id = ppf.person_id

Line 2100: -- and full_name from PER_ALL_PEOPLE_F for the employee_ids from

2096:
2097:
2098: -- Public Procedure translate_created_by
2099: -- Find out user_name for the corresponding user_ids from FND_USER
2100: -- and full_name from PER_ALL_PEOPLE_F for the employee_ids from
2101: -- FND_USER.
2102: -- Update HXC_RPT_TC_DETAILS_ALL with the corresponding values.
2103:
2104: IF g_debug

Line 2168: per_all_people_f ppf

2164: ppf.full_name||']'
2165: FROM hxc_rpt_tc_resource_temp gt,
2166: hxc_rpt_tc_details_all det,
2167: fnd_user fnd,
2168: per_all_people_f ppf
2169: WHERE gt.tc_bb_id = det.tc_bb_id
2170: AND gt.request_id = p_request_id
2171: AND det.last_updated_by = fnd.user_id
2172: AND fnd.employee_id = ppf.person_id

Line 2185: -- and full_name from PER_ALL_PEOPLE_F for the employee_ids from

2181: BEGIN
2182:
2183: -- Public Procedure translate_last_updated_by
2184: -- Find out user_name for the corresponding user_ids from FND_USER
2185: -- and full_name from PER_ALL_PEOPLE_F for the employee_ids from
2186: -- FND_USER.
2187: -- Update HXC_RPT_TC_DETAILS_ALL with the corresponding values.
2188:
2189: