DBA Data[Home] [Help]

APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on BOM_RESOURCE_EMPLOYEES

Line 163: from bom_resource_employees

159: from per_people_f
160: where
161: TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
162: and person_id in (select person_id
163: from bom_resource_employees
164: where organization_id =p_organization_id
165: and resource_id = l_temp_res_id2 );
166:
167: CURSOR c_equip_cur(l_temp_res_id3 NUMBER) IS --for rhshriva

Line 404: 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;

400: l_actual_employee_id := l_person_id;
401: l_actual_employee_number := l_employee_number;
402: x_employee_id := l_actual_employee_id;
403: x_employee_number := l_actual_employee_number;
404: 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;
405: end if;
406: end loop;
407: close c_empl_cur;
408: