APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on BOM_DEPT_RES_INSTANCES

Line 165: from bom_dept_res_instances

161: and resource_id = l_temp_res_id2 );
162:
163: CURSOR c_equip_cur(l_temp_res_id3 NUMBER) IS --for rhshriva
164: select distinct serial_number
165: from bom_dept_res_instances
166: where instance_id in (select instance_id
167: from bom_resource_equipments
168: where organization_id =p_organization_id
169: and resource_id =l_temp_res_id3 );

Line 448: select instance_id into l_instance_id from bom_dept_res_instances where resource_id = l_temp_res_id and serial_number = l_equip_serial_no ;

444: -- Check for equipment name to find out that the value entered does indeed exist in the valid list of values
445:
446: if (l_equip_serial_no = p_equipment_name ) then
447: equipment_exists := 1;
448: select instance_id into l_instance_id from bom_dept_res_instances where resource_id = l_temp_res_id and serial_number = l_equip_serial_no ;
449: end if;
450: end loop;
451: close c_equip_cur;
452: