APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on BOM_DEPT_RES_INSTANCES

Line 169: from bom_dept_res_instances

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

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

448: -- Check for equipment name to find out that the value entered does indeed exist in the valid list of values
449:
450: if (l_equip_serial_no = p_equipment_name ) then
451: equipment_exists := 1;
452: 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 ;
453: end if;
454: end loop;
455: close c_equip_cur;
456: