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 2154: per_all_people_f ppf

2150: ppf.full_name||']'
2151: FROM hxc_rpt_tc_resource_temp gt,
2152: hxc_rpt_tc_details_all det,
2153: fnd_user fnd,
2154: per_all_people_f ppf
2155: WHERE gt.tc_bb_id = det.tc_bb_id
2156: AND gt.request_id = p_request_id
2157: AND det.created_by = fnd.user_id
2158: AND fnd.employee_id = ppf.person_id

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

2168:
2169:
2170: -- Public Procedure translate_created_by
2171: -- Find out user_name for the corresponding user_ids from FND_USER
2172: -- and full_name from PER_ALL_PEOPLE_F for the employee_ids from
2173: -- FND_USER.
2174: -- Update HXC_RPT_TC_DETAILS_ALL with the corresponding values.
2175:
2176: IF g_debug

Line 2240: per_all_people_f ppf

2236: ppf.full_name||']'
2237: FROM hxc_rpt_tc_resource_temp gt,
2238: hxc_rpt_tc_details_all det,
2239: fnd_user fnd,
2240: per_all_people_f ppf
2241: WHERE gt.tc_bb_id = det.tc_bb_id
2242: AND gt.request_id = p_request_id
2243: AND det.last_updated_by = fnd.user_id
2244: AND fnd.employee_id = ppf.person_id

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

2253: BEGIN
2254:
2255: -- Public Procedure translate_last_updated_by
2256: -- Find out user_name for the corresponding user_ids from FND_USER
2257: -- and full_name from PER_ALL_PEOPLE_F for the employee_ids from
2258: -- FND_USER.
2259: -- Update HXC_RPT_TC_DETAILS_ALL with the corresponding values.
2260:
2261: