DBA Data[Home] [Help]

APPS.WIP_TIME_ENTRY_PUB dependencies on PER_ALL_PEOPLE_F

Line 242: from per_all_people_f papf,

238: l_stmt_num := 55;
239: /* Added for Bug 6908314. This SQL will default employee_id from badge_id. */
240: update wip_time_entry_interface wtei
241: set wtei.employee_id = ( select bre.person_id
242: from per_all_people_f papf,
243: bom_resource_employees bre
244: where papf.person_id = bre.person_id
245: and sysdate between papf.effective_start_date and nvl(papf.effective_end_date,sysdate+1)
246: and bre.organization_id = wtei.organization_id

Line 263: from per_all_people_f papf,

259: /* Added for to default employee_id for contingent Workers
260: No need as we don't currently support Emp and CW having same badge in same org from MES UI.
261: update wip_time_entry_interface wtei
262: set wtei.employee_id = ( select bre.person_id
263: from per_all_people_f papf,
264: bom_resource_employees bre
265: where papf.person_id = bre.person_id
266: and sysdate between papf.effective_start_date and nvl(papf.effective_end_date,sysdate+1)
267: and bre.organization_id = wtei.organization_id