DBA Data[Home] [Help]

APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on BOM_RESOURCE_EMPLOYEES

Line 159: from bom_resource_employees

155: from per_people_f
156: where
157: p_start_time BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE --for bug 8532793
158: and person_id in (select person_id
159: from bom_resource_employees
160: where organization_id =p_organization_id
161: and resource_id = l_temp_res_id2 );
162:
163: CURSOR c_equip_cur(l_temp_res_id3 NUMBER) IS --for rhshriva

Line 400: select instance_id into l_instance_id from bom_resource_employees where resource_id = l_temp_res_id and person_id = l_actual_employee_id;

396: l_actual_employee_id := l_person_id;
397: l_actual_employee_number := l_employee_number;
398: x_employee_id := l_actual_employee_id;
399: x_employee_number := l_actual_employee_number;
400: select instance_id into l_instance_id from bom_resource_employees where resource_id = l_temp_res_id and person_id = l_actual_employee_id;
401: end if;
402: end loop;
403: close c_empl_cur;
404: