APPS.WIP_TIME_ENTRY_PUB dependencies on BOM_RESOURCE_EMPLOYEES

Line 243: bom_resource_employees bre

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
247: and papf.employee_number = wtei.badge_id

Line 769: from bom_resource_employees bre,

765: begin
766: if p_dep_id is not null then
767: select count(1)
768: into l_count
769: from bom_resource_employees bre,
770: bom_department_resources bdr
771: where bdr.department_id = p_dep_id
772: and bdr.resource_id = p_res_id
773: and bdr.resource_id = bre.resource_id

Line 779: from bom_resource_employees bre

775: and bre.person_id = p_emp_id;
776: else
777: select count(1)
778: into l_count
779: from bom_resource_employees bre
780: where bre.organization_id = p_org_id
781: and bre.person_id = p_emp_id
782: and bre.resource_id = nvl(p_res_id,bre.resource_id);
783: end if;